I am working with an application where we will assign our customer data to each client in separate SQL databases Archive. So far this has done great work, even in a case where the wrong customer ID was chosen from some bad code database and since the database contained only one data related to that customer, the damage was not as bad as it could have been done. My concerns are about the number of databases you have on SQL Server.
Is there an additional overhead for each new database you create? We finally hit a wall where we have many databases on one server? SQL Server Access says that you can have something like 32000 databases, but it is possible that one has a large number of databases on one server and the problems you are encountering.
Thank you,
<- Disk Space
Example:
- Rebuild indexes for 32k databases? when?
- If at the time, 10% out of 32% of the database has an active set of 100 MB of data, then you are already in the 320 GB target server memory
- Knowing this For whether DB you '
- ...
Effective limit depends on load, usage, database size etc.
Edit: Voet Barnett as Banditith mentions ... I forgot about the network, everyone forgets the obstacles ...
Comments
Post a Comment