Our ERP software uses a SQL Server 2000 database. When we run a specific task on the software that used to take few seconds, a 300 seconds delay happens and SQL Server returns the error "Lock Timeout. SQL Server connection timeout".
I tried to identify the problem using SQL Server Profiler, and I could see some ROLLBACK's there, but I had no conclusions.
Is there a better way to identify what query is locking what resource and what query timeouts?