来自哪个数据库是锁定请求 [英] Which database are the lock requests comming from

问题描述

美好的一天，我的数据库服务器突然每秒锁定请求突然跳转。去年锁定请求每秒接近4000，然后突然跳到40,000并保持在那里。如何判断哪些数据库，应用程序或进程有
这些额外的锁请求，以便我可以找出导致它们的原因？

---

肯

Good Day, My database server empierced a sudden jump in locks requests per second. The locks requests per second was near 4000 for the last year, then suddenly jump to 40,000 and stayed there. How can I tell which database, application, or process have these extra locks requests, so I can track down what's causing them?

---

Ken

推荐答案

你必须看看DMV
sys.dm_db_tran_locks。

请参阅链接中提到的有关如何使用查询的示例

See the example mentioned in the link for how to use the query

这篇关于来自哪个数据库是锁定请求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！