Sometimes, your server might be running slow and you are wondering which of the processes is consuming your resources. For me, I would run this query and it helps me to see the culprit. You can also kill the task.
SELECT sqltext.TEXT, req.session_id,req.status, req.command,req.cpu_time,req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
Abayomi Obawomiye
I am a SQL Server/Business Intelligence Developer in Chandler Arizona. I share resources on beginner & advanced concepts in SQL Server.
Read Also
0
0
votes
Article Rating
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments