Solved

sql server 2008 capacity

Posted on 2011-09-29
2
245 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:al4629740
2 Comments
 
LVL 13

Accepted Solution

by:
Govvy earned 250 total points
ID: 36817082
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
0
 
LVL 21

Assisted Solution

by:JestersGrind
JestersGrind earned 250 total points
ID: 36817100
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.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Greg

0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question