number of open databases sets the maximum number of databases that can be open simultaneously on SAP ASE.
|
Summary Information |
|
|---|---|
|
Default value |
12 |
|
Range of values |
6 –2147483647 |
|
Status |
Dynamic |
|
Display level |
Basic |
|
Required role |
System administrator |
|
Configuration groups |
Memory Use, Meta-Data Caches, SQL Server Administration |
When you calculate a value, include the system databases master, model, sybsystemprocs, and tempdb. If you have installed auditing, include the sybsecurity database. Also, count the sample databases pubs2 and pubs3, the syntax database sybsyntax, and the dbcc database dbccdb if they are installed.
If you are planning to make a substantial change, such as loading a large database from another server, use sp_helpconfig to calculate an estimated metadata cache size by using sp_helpconfig. sp_helpconfig displays the amount of memory required for a given number of metadata descriptors, as well as the number of descriptors that can be accommodated by a given amount of memory. A database metadata descriptor represents the state of the database while it is in use or cached between uses.