LinkedIn | FaceBook | Twitter
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:
The second band shows more detail per SQL Statement against the number:
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re
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.