As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are the most common place to get the information we need but every now and again it’s nice to get an organized/pretty view. To that end, you can write your own reports or you can use the default reports that Microsoft makes available through SSMS. There are reports at the Server, Database and Agent level.
Server
Database
Agent
It’s easy enough to get to them. Just right click (ServerName, DBName, or Agent) -> Reports -> Standard Reports -> Select your report. Then once you start using them your recent reports will start showing up under the reports menu.
Filed under: Documentation, Microsoft SQL Server, SQLServerPedia Syndication, SSMS Tagged: microsoft sql server, reports, SSMS