Search code examples
sql-server-2008-expressquery-timeout

How to debug query timeout in SQL Server?

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 wrong 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.

Solution

  • 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.