Performance Dashboard is an add-on feature for SQL Server.

Type this into Google and you'll get a bunch of hits: "sql server performance dashboard". Pick the selection that is appropriate to your version of SQL Server.

It is one of the most useful set of tools I've ever used. I'm not sure why it is not part of the SQL Server installation.

You'll need to download it, install it, then execute the "Setup.sql" script to get it ready to run as a Custom Report in the Reports section of SQL Server Management Studio.

If you have any difficulties getting it to execute, let me know.

LC