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 - 2002-09-04 : 18:14:56
|
| K R Srinivasan writes "Hai can anyone clarify me..?My NT Server and sql server perfomance is very very slow, I can able to see that my CPU usage is always 100% in that sqlserver.exe is taking almost 99% most of the time. My memory usage is around 1.2 gd...most of the time it seems good all the time. I am using MS Sql Server 7.0. almost 40 to 50 users are connected to my server normally i have 100 user licence. The server has 2 gb ram and one Processor P3 800.Can any one pls help me.RegardsK R Srinivasan" |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-09-04 : 18:59:26
|
| Try upgrading to a dual processor ... 40-50 for a single processor sounds about right ... what kind of queries are they running? are you on a RAID array? or normal IDE ? |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-09-04 : 20:28:41
|
| Is your CPU this high, even right after a reboot?Lets say you reboot, all 50 users come online. Is your CPU 100% then?What application are your 50 users running? Is it a custom application?Depending on the answers, you probably need a faster disk subsystem or a second processor. I would think 50 users is a bit much for a single processor.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
99% cpu usage by sql server