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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-02-18 : 09:39:09
|
| hi,I have sql 2k sp3 win2k advanced server.since today morning my server is constantly showing 100% cpu .I had put a profiler but everything seems to be quite normal.I could not find any long running queries.what should I be looking for when running the profiler?and what is the cut out range for the cpu ,reads ,writes and duration that are considered to be normal?Is my sql server corrupt?are there any known issues withsp3?Expect the UnExpected |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-18 : 18:08:13
|
| Are you sure its SQL Server that is consuming the CPU? Run the System Monitor to determine if it is. You will need to look at the "Process: % Processor Time: sqlservr" object. If it is SQL Server, then run Profiler to determine the longest running queries. From here, you should have a good idea of what is consuming the CPU. If it isn't SQL Server, then you will need to figure out which process on the server is the culprit. |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-02-21 : 01:19:36
|
| hi,The problem got solved don't know how restarted the server and everything alright. I guess it was some long running backup job and the pc anywhere exe running in the background which was causing the problem.anyways thanks for the help.Regards,Harshal.Expect the UnExpected |
|
|
|
|
|
|
abrupt inserase in cpu usage