Identify source of database Locks

Asked

Viewed 68 times

1

good morning!

On my server, I own Sqlserver 2008R2 Express.

I am having lock problems in the database, however, I am not able to identify which process or which application might be causing these Ocks. I already searched the Windows Event Viewer and could not identify anything that helped.

In Sqlserver appear the processes in the situation "Suspended" and this is holding new queries.

Do you indicate any tool to assist in finding the cause of these Ocks, or, what are the procedures I should perform to try to identify?

sql sql-server sql-server-2008 microsoft

  • can use the "SQL Server Profiler" and create a Trace, has an option to view deadlocks

1 answer

1

  • Hello Jose! thanks for your reply, it was of great help the articles you indicated.

  • Fernando, the two articles are complete; the first is didactic; the second, although arid, also contains useful information.

Browser other questions tagged sql sql-server sql-server-2008 microsoft

You are not signed in. Login or sign up in order to post.