SQL Server Management Studio – standard reports in the Summary Page

In SQL Server Management Studio, the Summary Page can be displayed at any time by pressing F7 (or, to be chosen from the menu –> View –> Summary). When you select an item in the Object Explorer of SQL Server Management Studio, information about that object is presented in the document window called the Summary Page.

You can opt to display the Summary Page when starting SQL Server Management Studio.

–> Tools –> Options –> Environment –> General –> At startup: Open Object Explorer

Note that the Summary Page will be displayed when the option ‘Open Object Explorer’ is being chosen. Other options will *not* bring up the Summary Page at startup (which include ‘Open new query window’, ‘Open Object Explorer and new query’, ‘Open empty environment’).

Following is the list of reports that can be found within the Summary Page when you choose a *SQL Server* in the Object Explorer. This list will be changed when you choose different kinds of database objects.

~ server dashboard
~ configuration changes history
~ schema changes history
~ scheduler health
~ memory consumption
~ activity – all blocking transactions
~ activity – all cursors
~ activity – top cursors
~ activity – all sessions
~ activity – top sessions
~ activity – dormant sessions
~ activity – top connections
~ top transactions by age
~ top transactions by blocked transactions count
~ top transactions by locks count
~ performance – batch execution statistics
~ performance – object execution statistics
~ performance – top queries by average CPU time
~ performance – top queries by average IO
~ performance – top queries by total CPU time
~ performance – top queries by total IO
~ service broker statistics
~ transaction log shipping status

Recently, Buck Woody blogged the standard reports that can be found under the Summary Page. More information can be found here.


One Reply to “SQL Server Management Studio – standard reports in the Summary Page”

  1. I set “at startup” to “Open Object Explorer”. But pressing F7 doesn’t show up the summary page. Is there any other trick?

Leave a Reply to Chris Cancel reply

Your email address will not be published. Required fields are marked *