<div>
<div class="content wysiwyg-content">
Hello experts - <br />
<br />
I am by no means a SQL expert, so your assistance is appreciated. &nbsp;We have two instances of SQL Server on a Windows 2003 Server...a 2000 version and a 2005 version. &nbsp;We have just a handful of databases being hosted right now. &nbsp;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? &nbsp; Or at a minimum, how can I tell if it is the 2000 or the 2005 instance? &nbsp;The process list simply shows two line items of sqlservr.exe.<br />
<br />
Thanks!
</div>
</div>


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.

Thanks!

What to do when SQL server CPU spikes

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.