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 |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2004-07-07 : 05:19:24
|
| Hi, In my shop I have a Sql server 7, with latest patches installed. customers of the application are for intranet. The Sql server had been quite and calm for the past week and before. But on 7/6, the CPU usage has shot abruptly and caused slow response..cpu to 50% - 95% in regular interval. I am trying to figure, why did this happen without any changes applied either to application or database nor the server. Can anybody throw some light on this ? Thanks in advance.RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-07-07 : 05:37:54
|
| Well, I am guessing you didn't have Profiler running, which might have shown you an increase in cleint connections/SQL work.Is most of your code calling SP's ? Maybe you had a spike in transactions, or an infrequently called transaction calling an infrequently used SP ? Is there any way to determine in yuor environment whether there was a change in the "mix" of transaction/work being done from the client side?Do you have performance monitor logging, or a 3rd party performance monitoring tool (MOM, Patrol, etc. etc.) - I'm wondering if the CPU activity was all SQL, or perhaps something else ? I've seen soemthing similar when admin's managed to launch a virus scan of all drives during an online day.CiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
cpu usage high