• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

At what size does a MSSQL database begin to see performance degrade

Hello,

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?

Thanks.
0
tatton777
Asked:
tatton777
  • 2
1 Solution
 
LowfatspreadCommented:



when you say master database do you mean the system database?
or one of your own?

 DO NOT PUT ANYTHING INTO THE MASTER DATABASE (system)


the user databases...

what is the reason for them being individual databases in the first place?

do they all have the same structure?

how would you attempt to merge them... same tables, separate schemas?
are ther security implications merginmg the clients?

what sort of processing is performed on the client databases...
(oltp, data warehouses, ...)

what are the transaction rates...
are the batch processing requirements the same...

confirm what your maintenance issues are
0
 
LowfatspreadCommented:
which version of sql server are you using?

do any of the client have specific tailored database options in use e.g. collation, memory specifications?
0
 
Anthony PerkinsCommented:
>>At what size does a MSSQL database begin to see performance degrade<<
At the point that you fail to optimize your queries.

>>How much of the database performance is effected by the size of the database<<
It depends.  If the queries are optimized appropriately, then it has no affect.

Is there a maximum recommended size?
No.  See above.

Is there a maximum recommended size based on computer specs formula?
No. See above.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now