Post reply

Calculate amount of time taken to create a execution plan

  • April 10, 2013 at 12:32 pm

    #292304

    I have a sproc which i run manually, i am interested to know how much time does it take to create the plan from scratch of the total execution time?

  • April 10, 2013 at 6:17 pm

    #1605441

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply