Today’s tip is a very basic functionality that comes with any SSMS (SQL Server Management studio), we are talking about SSMS Instance and Database level reports.
These SSMS reports does not require any additional plugin or either SSRS (SQL Server Reporting Services), all these aware reports are part of any out of box SSMS instance you might have installed in your environment.
As mentioned above, there are two different levels of reports please keep in mind each set has unique reports that only applies to the specific level selected.
In order to explore the Instance level reports you just need to simply right click on your SQL Server instance, then select Reports, then Standard Reports:
In order to explore the Database level reports you just need to simply right click on any or your existing SQL Server databases, then select Reports, then Standard Reports:
We are not going to dive deep on all these reports because as you may noticed there are too many and the report name does well job describing their purpose.
Note:
We will cover the Custom Reports option in the near future, stay tune for more DBA mastery tips.
Carlos Robles is a Solutions Architect at AWS, a former Microsoft Data Platform MVP, a Friend of Redgate, but more than anything a technology lover. He has worked in the database management field on multiple platforms for over ten years in various industries.
He has diverse experience as a Consultant, DBA and DBA Manager. He is currently working as a Solution Architect, helping customers to solve software/infrastructure problems in their on-premise or cloud environments.
Speaker, author, blogger, mentor, Guatemala SQL User group leader. If you don’t find him chatting with friends about geek stuff, he will be enjoying life with his family.