SQLTeam.com | Weblogs | Forums

Identify slow running queries in stored proc


Hi Team,
I have multiple stored proc where multiple queries are written but I want to find out which stored proc and which query in that proc is actually slowing down the system.


SQL Profiler?


i am looking for best practices and steps to identify the culprit.


Please have a look on here: