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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2008-12-02 : 21:06:09
|
| How to start investigation in this situation?How to check cpu spikes,blocking, open connections?Please guide me, kind of new to this |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 09:35:56
|
| Performance Monitor : Cpu CountersSQL ProfilerTask ManagerStandard Reports if SQL 2005(for query)DMV for CPU(like sys.dm_os_schedules). |
 |
|
|
|
|
|
CPU reached 100% utilization