Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-19 : 08:11:37
|
| Alan writes "Dear SQL Team,I have a pentium 3 14000MHz server with 1GB of Ram running windows 2000 server. This server is a file and print server as well as a database server running SQl 2000 with 15 users. The current SQl database size is 100MB. what is the maximum size database and number of users I can have with this hardware before I am forced to upgrade the server?, archive the database?, or configure the use of this database over multiple servers?RegardsAlan" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-01-19 : 10:14:51
|
| This is one of those "it depends" type question.What you need to do is to run perfmon now to see how your resources are being used. Periodically run perfmon again to note performance trends. Hit http://www.sql-server-performance.com for some tips on this and what counters to look at. Average Disk Queue Length under Physical disk is the most important one IMHO.Since your database is less than the amount of physical RAM in the machine, you should be fine until that database get's closer 1GB (probably around 600-700MB's you might start to see slow downs). At that point, you can add more RAM, or start investigating disk subsystem upgrades.With smaller databases, the upgrades should be RAM, DISK, CPU in that order. With larger databases (generally 2GB+), you'll want to upgrade DISK, RAM, CPU in that order.HTH!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-01-19 : 15:29:19
|
quote:
Originally posted by AskSQLTeam
Alan writes "Dear SQL Team,I have a pentium 3 14000MHz server with 1GB of Ram running windows 2000 server. This server is a file and print server as well as a database server running SQl 2000 with 15 users. The current SQl database size is 100MB. what is the maximum size database and number of users I can have with this hardware before I am forced to upgrade the server?, archive the database?, or configure the use of this database over multiple servers?RegardsAlan"
Well, you should isolate SQL Server to it's own box.But...100MB...you sure you don't mean 100GB?In any event, you'd need to worry more about bandwidth as a file/print server than the database, which will probably slow everything down (depending on activity)Brett8-) |
|
|
|
|
|
|
|
|
Database Size Limit