SQL Server Performance Forum – Threads Archive

Database Size

Hi,
What is the maximum size of the database in SQL Server 2000? We are using Visual Basic Application connected to SQL Server 2000 database. The database that we use has 150 tables with some having millions of records. I took backup and the size is 6GB. This is only for last 4 months data. At the end of the year it may reach nearly 15GB. The application responds slowly as database size is increasing. To take a print out sometimes it takes 5 minutes. Is this because of the size of the database? If so,is there any way to speed up the application? Thanks in advance
Madhivanan

BOL defines the max size of database is allowed upto 1,048,516 TB.
How about database health checks?
How about archiving the data for previous months in order to keep up the size of current database? Check out the hardware of the server and assess whether CPU & Memory are sufficient to cache most of the database and all of the indexes. Sizing hardware is very difficult and very dependent on your specific needs and database layouts. http://www.sql-server-performance.com/default.asp for further information on tuning database.
http://www.databasejournal.com/features/mssql/article.php/1439801 optimization on using file/filegroups.
http://vyaskn.tripod.com/analyzing_profiler_output.htm – use profiler troubleshoot performance issues. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

You need to check your tables are adequately indexed and that your indexes are appropriate for your queries. A database that’s 15Gb in size should not be slow. It should not need archiving (unless you’re running out of disk space). You may be lacking required indexes if your queries are getting slower with table growth. Tom Pullen
DBA, Oxfam GB

If you know in advance that your DB will grow _very_ large, the best thing you can do is to hire a consultant with proven experience with VLDB right when you start designing it.
A sound schema and sound applications are mandatory to keep such a db usable. Btw, 6 GB for four months isn’t that much. Not that I have such databases, however I’ve seen postings from guys who run SAP on SQL Server and whose DB’s grow at a rate of 15-20 GB each month. ———————–
–Frank
http://www.insidesql.de
———————–

… we have a database which increases at a rate of 15 GB per month and no performance issues so far. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

satya,
are you running SAP?
Would be interested in that topic. ———————–
–Frank
http://www.insidesql.de
———————–

No, a dedicated SQL Server with archived data used for Reports, MIS queries.
Total 5 databases with 250 GB. (edit: should say 5 db’s amounting 250gb totally) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

aah, OLAP stuff… ———————–
–Frank
http://www.insidesql.de
———————–

[<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />] Nope, no OLAP is involved [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

glad to hear that! [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] ———————– –Frank http://www.insidesql.de</a> ———————–

Moved to General DBA Questions Cheers
Twan

Hi,
Thanks for ur kind replies. Madhivanan

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by Twan Moved to General DBA Questions Cheers Twan <hr height="1" noshade id="quote"></blockquote id="quote"> Hey, first avtion as moderator? [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] ———————– –Frank http://www.insidesql.de</a> ———————–

yip, the all powerful feeling is quite cool… and sad! Twan

May the power be with you [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] ———————– –Frank http://www.insidesql.de</a> ———————–

]]>