SQL Server Management Studio Standard Reports – Object Execution Statistics: [DatabaseName]

SQL Server Management Studio Standard Reports – Object Execution Statistics: [DatabaseName]

Rate This
  • Comments 3
I'm continuing my series on the Standard Reports in SQL Server Management Studio, and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, click the Standard Reports, and then select the title at the top of this post.

I promised that I would come back and pick up this report since I skipped it. True to my word, here we are!

This report shows information about the methods that SQL Server uses to locate data, called a plan. If you want more information about that, check here. The report is organized by objects, such as stored procedures.

The first area of the report has five graphs, which show you the objects grouped by CPU, and average reads and writes. You’ll see a lot logical and physical read and write information not only in these graphs but throughout the report, so you might want to check out this reference for more information on those.

The first band in the report groups the information by the object number:

Column Description
Object Number A unique number within the report assigned to each object such as a stored procedure, that has a cached plan
Object Name The “friendly” name of the object
Object Type The type of the object within SQL Server
Avg. CPU Time (ms.) The average CPU time taken by this object
Total CPU Time (ms.) The total CPU time taken by this object
Total CPU Time (%) The total percentage of the CPU time taken by this object
# Avg. Logical Reads The number of average logical read operations taken by this object
# Avg. Logical Writes The number of average logical write operations taken by this object
# Total Logical Writes The number of total logical read operations taken by this object
# Avg. Logical IO The number of average IO operations taken by this object – note – a SAN or other abstracted IO subsystem can affect this number dramatically
# Total Logical IO The number of total IO operations taken by this object – note – a SAN or other abstracted IO subsystem can affect this number dramatically
Total Logical IO (%) The total percentage of IO operations taken by this object – note – a SAN or other abstracted IO subsystem can affect this number dramatically

The second band shows more detail per SQL Statement against the number:

Column Description
SQL Statement Part of the SQL Statement run against the object
# Executions (With Last Plan) How many times this statement has executed against this object, within this plan
# Plans Generated The number of plans that had to be generated for this SQL Statement
Avg. CPU Time (ms.) The average amount of CPU time taken by this SQL Statement
Total CPU Time (ms.) The total amount of CPU time taken by this SQL Statement
Last CPU Time (ms.) The last amount of CPU time taken by this SQL Statement
Min. CPU Time (ms.) The minimum amount of CPU time taken by this SQL Statement
Last CPU Time (ms.) The last amount of CPU time taken by this SQL Statement
Min. CPU Time (ms.) The minimum amount of CPU time taken by this SQL Statement
Max. CPU Time (ms.) The maximum amount of CPU time taken by this SQL Statement
# Avg. Logical Reads The average number of logical read operations taken by this SQL Statement
# Total Physical Reads The total number of physical read operations taken by this SQL Statement – note – a SAN can drastically affect this number
# Last Logical Reads The last number of logical read operations taken by this SQL Statement
# Min. Logical Reads The minimum number of logical read operations taken by this SQL Statement
# Avg. Logical Writes The average number of logical write operations taken by this SQL Statement
# Total Logical Writes The total number of logical write operations taken by this SQL Statement
# Last Logical Writes The last number of logical write operations taken by this SQL Statement
# Min. Logical Writes The minimum number of logical write operations taken by this SQL Statement
# Max. Logical Writes The maximum number of logical write operations taken by this SQL Statement
# Avg. Logical IO The average number of logical IO operations taken by this SQL Statement
# Total Logical IO The total number of logical IO operations taken by this SQL Statement
# Last Logical IO The last number of logical IO operations taken by this SQL Statement
# Min. Logical IO The minimum number of logical IO operations taken by this SQL Statement
# Max. Logical IO The maximum number of logical IO operations taken by this SQL Statement

Leave a Comment
  • Please add 2 and 5 and type the answer here:
  • Post
  • I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re

  • Hi

    Your article is wonderful, But how can I know the T-SQL behind of this report?

  • Object Number is defined above as a unique number within the report. In the pie charts, unlike the bar charts, this number is totally useless since it is not searchable or tied to anything useful. Why not replace it with the actual object_id, something that would be useful.

Page 1 of 1 (3 items)