SQLTeam.com | Weblogs | Forums

Identify slow running queries in stored proc


#1

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.


#2

SQL Profiler?


#3

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


#4

Please have a look on here: