We received a deadlock condition on a SQL server running a proprietary software application. The software vendor said this occurred because of a computer network issue. This application is running on a VMware virtual server. Any suggestions for finding a solution to this issue are welcome. Is it possible for this to occur due to a network issue? The application runs on the server where SQL is installed (the database is not on a separate server).
Error message [Microsoft] [ODBC SQL Server Driver] [SQL Server] Transaction (Process ID 117) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
We have not been able to identify the specific transaction.