Timing a Stored Procedure

Results 1 to 2 of 2

Thread: Timing a Stored Procedure

  1. #1
    Join Date
    Dec 1969

    Default Timing a Stored Procedure

    Can anyone tell me how I can time a stored procedure? I have a fairly large sp and I would like to be able to time each procedure that it runs within it to look for bottlenecks. I have heard that there is a system stored procedure that I can run against it but I don't know what it is or how to use it.

  2. #2
    Join Date
    Dec 1969

    Default RE: Timing a Stored Procedure

    Why not use the Profiler, that's made for this kind of work!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts