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 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?