At what size does a MSSQL database begin to see performance degrade
Posted on 2011-10-30
I have a group of databases that could all be put together into a single databases that would make my job of maintaining these databases much simpler. The problem is that the database's growth rate is increasing rapidly as we add new clients.
Right now the Master Database is about 8 gigs. There are a hundred clients, those databases hold about 3 gigs of data. So, if I was to combine all of this data, we'd be looking at the 300+ gig database. Another thing to consider is the fact that we are adding clients every year so this database will increase over time.
How much of the database performance is effected by the size of the database. Is there a maximum recommended size? Is there a maximum recommended size based on computer specs formula?