当前在存储过程中运行查询 [英] Currently running query inside a stored procedure
本文介绍了当前在存储过程中运行查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个当前正在运行的存储过程,并且似乎在特定查询上挂起/锁定.我怎样才能看到哪个查询?最好不要修改程序.
I have a stored procedure that is currently running, and seems to hang/lock on a specific query. How can i see which query? Preferably without modifying the proc.
使用
DBCC Inputbuffer (65)
给我
语言事件 0 EXEC mySP;
Language Event 0 EXEC mySP;
推荐答案
有一个出色的存储过程可以获取有关当前正在运行的查询的扩展信息.可从以下网址下载:http://whoisactive.com
There is an excellent stored procedure to get extended information on currently running queries. It's available to download from: http://whoisactive.com
这篇关于当前在存储过程中运行查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文