Home Forums SQL Server 2005 Administering Calculate amount of time taken to create a execution plan RE: Calculate amount of time taken to create a execution plan

  • SET STATISTICS TIME ON;

    EXEC YourProcedureNameGoesHere;

    Then check the 'Messages' output window.

    You may need to force a recompile of your proc before running it in order to see the compilation time (no compile time if it's already in cache).

    Eddie Wuerch
    MCM: SQL