What to do when SQL server CPU spikes
Posted on 2006-11-21
Hello experts -
I am by no means a SQL expert, so your assistance is appreciated. We have two instances of SQL Server on a Windows 2003 Server...a 2000 version and a 2005 version. We have just a handful of databases being hosted right now. When the CPU spikes to 100% on that server, and I can see that at least one of the instances of sqlservr.exe is the problem....what can I do to determine which specific database is causing the spike? Or at a minimum, how can I tell if it is the 2000 or the 2005 instance? The process list simply shows two line items of sqlservr.exe.