June 28, 2004 at 4:36 pm
I am just curious to know if there are resources required to track all databases on one SQL instance. What are the suggested number of databases per one server???
We have one server running over 100+ databases in one instance.... To increase the performance...Should we detach some while reattach them when we needed to use them?
Thanks,
JON
DBA/OLAP Developer -
San Francisco, CA
June 28, 2004 at 5:25 pm
Other than space in master to track their location it only matters if these Databases will not be needed for long with long times between use and are not set to Auto Close. It takes about 30k to keep the DB open in memory not to mention all it's objects that are in the cache and any connections (about 50k per connection) on them. If you have DBs that you will access maybe once or twice every few days you might consider using the Auto Close option for the DB. Otherwise there is not too much impact for unused DBs especially once all data ansd procedures are flushed due to last time used.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply