I am the 'default' database admin for our 2008 SQL Server (not an expert). I am trying to figure out the clearest way to identify a database lock that is preventing some users from accessing the database.
I have vb application (windows form) that hits my SQL 2008 Database. Every once in a while, a request times out b/c of the unidentified database lock. Restarting the SQL Server obviously fixes the issue, but I am trying to identify the specific lock, so I can go back into the VB code and modify it.
I can get into the Activity Monitor and view it. What am I looking for? Any tips? Any direction?