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

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