Post reply

SQL Server parse and compile time

  • May 4, 2009 at 5:05 am

    #209084

    Hi all

    I want to know if its possible to find out the SQL Server parse and compile time of a query without 'set statistics time on'. We can get the total cpu time from the DMV sys.dm_exec_query_stats, what I need is a similar source to get the parse and compile time and execution time separately for each query in SQL Server 2005 and 2008?

    Thanks for your help.

    Regards

    Nabeel Mukhtar

  • May 4, 2009 at 12:40 pm

    #988299

    You might be able to get that by using a trace and capturing the cache miss event and then pairing that with the sp or rpc starting events to see the difference between the two. That would be the parse & compile time, I think.

    I've never tried that before, so I might be off.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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