question

sqlrookie avatar image
sqlrookie asked

SQL Server with large database

Hi Experts, I have a database which is growing rapidly and will reach 100GB shortly. I would like to know whether SQL Server 2008 will handle more than 100GB databases? What are the best practices to handle such big databases especially when my indexes are not well maintained. Thanks in advance!
sql-server-2008databasebest-practice
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This site runs off of votes. Please mark all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that answer.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
I had a SQL Server 7.0 system with over 700gb of data that was collecting a gb of data a day and that was 15 years ago. Yes, SQL Server 2008 can certainly handle 100gb of data and lots more. You just have to make sure you maintain your statistics properly, make sure you have enough space to get good backups in place, and as @Dave_Green says, take into account that it's going to need more memory, CPU and disk. People are running multi-terrabyte systems on SQL Server. The largest in the world is well over 100tb and working fine according to the people running it. You just have to do the necessary work to ensure it's performance and maintenance.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

The only thing I would add is that as they reach the very large range the skills of the DBA are more important. You can't get by with out-of-the-box anymore. You need someone who understands how the whole thing works.
3 Likes 3 ·
Dave_Green avatar image
Dave_Green answered
On a purely limitations basis, [SQL Server 2008's capacity limitations are specified here][1]. However, there are a number of other considerations, such as memory and CPU (and the way which the database is used - % of records that are queried, written to, etc) that will impact how well a server runs as it's databases grow in size. [1]: http://technet.microsoft.com/en-us/library/ms143432(v=sql.100).aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.