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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-01-10 : 15:33:52
|
| I have recently been told that an app is running poorly becauseof a sql server config. This is crazy cause it's a 4 zeon 900+4 Gb Ram Dual Raid 5 blah blah overkill almost. But it only hasabout two hundred users on it.I am looking for some good reference stats that says:recommended memory/userprocessor per transactionserver config /...upper range for sql serverthese types of recommendations.Any suggestions...Thanksslow down to move faster... |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-10 : 16:59:58
|
| Your system seems good enough to run most SQL installations, but really the most important thing is the transaction load. How many transactions are hitting the server? When you say it is running poorly, what exactly do you mean? Do you have a benchmark, was it running fast, then one day, poof, it started running poorly? Does it run poorly all the time, or just certain times of the day? Have you run perfmon to find out where the bottlenecks are? What is the application architechture? N-Tier?I think what you are looking for is really different for every system, and takes testing and monitoring to determine. You need a benchmark, without one, how do you know it is slow?This is at least something that might help you though:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnduwon/html/d5cpctyplan.aspHTH-Chad |
 |
|
|
|
|
|
sql stats