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().

    Thanks.
    HJ
  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
    AS
    SELECT * FROM MyTable WHERE Key = @Key
    ...
    GO
    Instead of executing EXEC sp_Proc @Key = 1 on Query Analyzer, I do :
    DECLARE @Key INT
    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
    Webmaster
    SQL-Server-Performance.Com

Share This Page