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