5

Possible Duplicate:
How to find slowest queries

In Sql Server 2008, is there any option to find out which stored procedure running slowly among all (When the no. of stored procedures is very large. Ex: 500)

Community
  • 1
  • 1
gee'K'iran
  • 431
  • 2
  • 7
  • 21
  • 7
    SQL Profiler, server-side tracing, inspecting the relevant DMV's ..... just Google for "identify slow running query sql server" and you'll get **tons** of articles showing you how to do it... – marc_s Dec 19 '12 at 08:23
  • 1
    I believe the query execution plan would help too... You can also turn on client statistics once you have some hunches as to the culprit – Rikon Dec 19 '12 at 08:31
  • @Rikon: Using query execution plan, we can check the stored procedure one by one manually. I am looking for automated approach (may be a query) – gee'K'iran Dec 19 '12 at 08:35

1 Answers1

4

Hey Kiran Please refer to this question may be it will answer you

How to find slowest queries

Community
  • 1
  • 1
Sigar Dave
  • 2,598
  • 1
  • 20
  • 42