use of sys.dm_exec_requests and sys.dm_exec_sessions

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:

sys.dm_exec_requests
sys.dm_exec_sessions

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

http://blog.extreme-advice.com/2012/09/14/find-currently-running-sessionprocess-in-sql-server-databaseinstance/

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations