Browse by Tags

• performance
• stored procedure
• sysmon

SQL Server 2005 high CPU occurrence - why it is?
18 June 07 07:33 AM | SQL Master | 2 Comments   

If a particular query is performing poorly the first thing you would check is relevant indexes, even though having associated indexes against those tables may not help any better to the performance. The next phase you observe is high CPU count from the Read More...

Filed under: performance, profiler, sysmon, recompile, stored procedure