SQL Server Performance

how to trace a SP

Discussion in 'General DBA Questions' started by ufobox, Dec 5, 2002.

  1. ufobox New Member

    Does anybody know how to trace a SP?
    Except SQL-profiler & DBCC inputbuffer().

  2. jfou New Member

    A good product : CAST Application Mining Suite from CAST Software... But very expensive :-(

    My own method is to use Query Analyzer and SQL-Profiler :
    For example if I have the following stored procedure
    CREATE sp_proc @Key INT
    SELECT * FROM MyTable WHERE Key = @Key
    Instead of executing EXEC sp_Proc @Key = 1 on Query Analyzer, I do :
    SET @Key = 1
    SELECT * FROM MyTable WHERE Key = @Key

    I think that it is a good method because SQL-Profiler allows me to trace my stocked procedures, but also to optimize them.

    Jean-Paul FOURNIAUD
  3. ufobox New Member

    thank you for you reply.

    I'll try it later.
  4. bradmcgehee New Member

    Another third-party program to consider is Coefficient from Intrinsic Design athttp://www.idisoft.com.

    Brad M. McGehee

Share This Page