How to check running Sql queries in Sql Server?

 Posted by vishalneeraj-24503 on 7/9/2014 | Category: Sql Server Interview questions | Views: 2274 | Points: 40
Answer:

Write below query to check which Sql Statement is running
Select [Text] as Sql_Statement,Status as [Running_Info]

From sys.dm_exec_requests
Cross Apply sys.dm_exec_sql_text(sql_handle)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response