Post reply

performand reports in SQL Server 2005

  • July 9, 2010 at 6:38 am

    #147925

    Hi All ,

    As per the lcient requirement I generated the TOP CPU Consumer report ( using IN built reports ) in SQL Server 2005 . I need to understand the column : #Execution Count . Does the count mentioned in this column shows the number of executions after the Compilation Time ( 1st column in the report ) ??

    Can anyone please clarify ?

  • July 9, 2010 at 5:32 pm

    #1191078

    If you mean "Performance - Top Queries by Total CPU Time" report then yes, this is "Number of times that the plan has been executed since it was last compiled.". This is execution_count column from sys.dm_exec_query_stats dynamic management view.

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

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