use of sys.dm_exec_requests and sys.dm_exec_sessions

Friday, September 14, 2012 |

As a DBA, it is mandatory to keep an eye on your database and server too, especially during the business hour. SQL Server providing very helpful Dynamic Management View to help in this situation. Dynamic Management View (DMV) are as follow:


Get the script of the SQL Server view, click on the below given link:

Reference: Ritesh Shah
Note: Microsoft Books online is a default reference of all articles but examples and explanations