开发者

How to debug query timeout in SQL Server?

开发者 https://www.devze.com 2023-03-14 11:13 出处:网络
I\'m getting an SQL query timeout for a simple query: delete from Prices where Id=123 Id is a PK column. The server is not under high load - something is w开发者_如何学编程rong with few other queri

I'm getting an SQL query timeout for a simple query:

delete from Prices where Id=123

Id is a PK column. The server is not under high load - something is w开发者_如何学编程rong with few other queries. How can I debug this situation? I use SQL Server Express 2008.

Thank you!

UPD1 Renamed table to match real name.


If you believe the query is blocking on another you can follow the query from this blog post which shows how to identify what it is blocking on. Once you figure that out you can investigate the query for issues.


You have a table named table? That might be the problem. How are you executing the query? Through SQL Studio? Stored Procedure? SqlCommand?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号