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

sql server 2008 capacity

We have an SQL Server 2008.  I have one db that is passing 1 GB.  I have over 600,000 records on one of the tables.  I would like to add more tables with many more records coming.  Are there any capacity issues that I will run into?
2 Solutions
Nowhere close - we have 500GB+ databases. See: http://msdn.microsoft.com/en-us/library/ms143432.aspx

The first bottleneck you may run into is disk IO so you may wish to monitor perfmon statistics before and after you expand to do proper capacity planning
Here is the list of maximum capacity specifications for SQL Server.  There is database size limit of 524,272 terabytes.  A 1 GB database is tiny.  The number of rows is limited by the available storage.  You should be safe there as well unless it's on a drive without a lot of disk space.



Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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