Trace one SP | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Trace one SP

My 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
http://www.SQL-Server-Performance.Com
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.
]]>