![Why would a SQL Server query request the same lock twice and deadlock? - Database Administrators Stack Exchange Why would a SQL Server query request the same lock twice and deadlock? - Database Administrators Stack Exchange](https://i.stack.imgur.com/JPRiJ.png)
Why would a SQL Server query request the same lock twice and deadlock? - Database Administrators Stack Exchange
![Diagnosing: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time - SQLGrease SQL Server Performance tips Diagnosing: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time - SQLGrease SQL Server Performance tips](http://blog.sqlgrease.com/wp-content/uploads/2018/12/output_of_locks.gif)
Diagnosing: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time - SQLGrease SQL Server Performance tips
![SQL Server Deadlocks: What They Are and How to Avoid Them - Database Management - Blogs - Quest Community SQL Server Deadlocks: What They Are and How to Avoid Them - Database Management - Blogs - Quest Community](https://s38063.pcdn.co/wp-content/uploads/2021/09/the-anatomy-of-sql-server-3-1.png)