How to Check blocking, Long running transactions SSMS in MSSQL server in Hindi

MSSQL ADMINISTRATION IN HINDI | MSSQL DBA CLASS IN HINDI | LEARN MSSQL IN HINDI Hi All,
today we are going to learn about standard reports in mssql on instance and DB level , this will help us to get various information with any query and presentable format ,its really very simple to learn and understand .

please watch complete video without miss till the end.

Activity Monitor Activity Monitor is one of the features available in SQL Server Management Studio that quickly provides a set of most common performance metric values. What makes it more useful is that no previous setup is needed. Metrics are available at just a couple of clicks.
Keep in mind that the feature provides only basic information for a pre-defined set of SQL Server performance metrics, not useful for any deeper investigation and troubleshooting. No customization is possible. The metrics are shown in real-time graphs, they cannot be saved for later analysis, nor threshold values specified. But it can be useful to begin with performance monitoring and troubleshooting.
Standard reports The largest set of SQL Server performance metric reports available in SQL Server Management Studio are Standard reports. It is a set of built-in reports that cover most common performance and monitoring requirements. The feature was introduced in SQL Server 2005. The available reports have changed over time, but the logic behind them is the same.

They can be used to quickly identify memory issues, most expensive queries, blocking transactions, and more.

Server dashboard,Memory Consumption Memory Consumption
Performance –Top Queries by Average CPU Time and Top Queries by Total CPU Time

In SQL Server Management Studio Object Explorer, right-click the SQL Server instance if you want the instance level reports, or the database object node for adequate standards reports
In the context menu, select Reports | Standard reports
Select the report from the list.

If you select Custom reports, you’ll be prompted to navigate to the folder where custom reports are saved.
These are the .rdl and .rdlc files. If you haven’t created or used any custom reports on this SQL Server instance, the menu will be empty.
Right-click the report and print it or save as an Excel or PDF file

Please share and subscribe if you feel its useful for you