当前位置: 首页 > Microsoft > 正文

How to Find Currently Running Query in SQL Server

This can be an important query for your while debugging slowness of SQL server. This will help you find currently running SQL queries on SQL Server. You can find which queries are running from a long time and utilizing CPU.

To run this query, start SQL Server Management Studio, Open New Query window and copy below query in it. Now click on Execute button to run this query.

Run the above query using SQL server management studio. The result will be different than below screenshot.

Output Details:

TEXT: The query is being executed.
session_id: Session id assigned to query. We can use this id to kill this query
status: Current status of the query
Start_time: The time query was started.

本文固定链接: http://t.yjsec.com/index.php/2017/12/02/28/ | 下一站

该日志由 admin 于2017年12月02日发表在 Microsoft 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: How to Find Currently Running Query in SQL Server | 下一站
关键字:

How to Find Currently Running Query in SQL Server:等您坐沙发呢!

发表评论

快捷键:Ctrl+Enter