MSSQL ADMINISTRATION IN HINDI | MSSQL DBA CLASS IN HINDI | LEARN MSSQL IN HINDI 1. check services using configuration manager .
2. check db online
3. check no of connection and remote connection not disable values.
4. error logs in sql using sql and error logs files
5.check system resources like memory and CPU
6. check disk availability using disk.mgmt using run .

You can get information on blocking with the following query:

SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
The counters that indicate most common causes for processor pressure are Batch Requests/sec, SQL Compilations/sec, and SQL Recompilations/sec. These counters are available in Performance Monitor and in the sys.dm_os_performance_counters view

select * from sys.dm_os_performance_counters
where counter_name in (‘Batch Requests/sec’, ‘SQL Compilations/sec’ , ‘SQL Re-Compilations/sec’)