It is very easy to create a custom report and use it inside SQL Server Management Studio.
As we know, we have standard reports from Microsoft to monitor the Server and Database information.
These reports are available for instance and database level, If you are not aware of this standard reports, please check it below to access those reports.
Steps to use custom report in SQL Server Management Studio.
Just created a Report as like below,
We need to adjust the data source properties to use inside SSMS. Modify the data source like below. Once modified the data source, save the report. We will take this rdl file and attach in SSMS.
Once added the report, open and see the information.
Now, you can refresh the report and see the real time information and even you can build a report to specific database for monitoring purpose.