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 |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2008-07-31 : 06:52:17
|
| Hi Our Srever CPU load is suddenly max of 90%, we dont know wat hpnd. How to find where is the max load load applying on the server.Please help. |
|
|
RKinney
Starting Member
2 Posts |
Posted - 2008-07-31 : 10:06:12
|
| Have you tried Windows Task Manager? Look at the Processes Tab and look at the CPU column. This will show you which process is eating up your CPU. You will need to determine if need to end the process. |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-07-31 : 11:39:44
|
| Do what RKinney says. If SQLServer is eating up the CPU, use Profiler to see what queries are running up a lot of CPU. After that, see if you can tune those queries. |
|
|
|
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2008-07-31 : 13:04:07
|
| Thanks for giving way to analyze. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-31 : 13:07:21
|
| you can use Standard Reports that comes with SQL 2005.check Top transaction by Total CPU time. |
|
|
|
|
|
|
CPU Max Load