Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    5

    Unanswered: how to measure the performance of a stored procedure

    Hi

    how to measure the performance of a stored procedure?

    Expecting Proper

    Thanks

    ----------------

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    TRACE and TKPROF

    the efficiency of a proc is based on how efficient the cursors and statements
    in the proc are. Tracing and TKPROF will give you this information.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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