SQL Server Performance Forum – Threads Archive
Trace one SPMy CPU is going upto 90%.I found the SP which is taking the longest time. Can anyone tell me how can I open a trace for only one SP to see what its doing.
http://sqlserver-qa.net/blogs/perftune/archive/2007/04/26/high-cpu-spikes-affecting-performance.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.