Select to view content in your preferred language

SQL Server SDE database locked

440
2
10-01-2019 01:12 PM
JoseSanchez
Regular Contributor

Hello everyone,

What  tools do you recommend to monitor  an SDE SQL Server database that gets locked and it does not allow to open any connection using ArcCatalog.

We are using this link to check the locks, but we wil like to monitor the database to prevent these locks:

How To: Obtain a listing of user processes and locks from a geodatabase when there is no ArcSDE serv... 

Thanks

0 Kudos
2 Replies
ChristianWells
Esri Regular Contributor

Great question, Jose. I don't have a specific tool to recommend, but I'd like to help narrow it down. What are you hoping to monitor? Is it to find who is locking the database? Or just to be notified when is becomes locked?

0 Kudos
JoseSanchez
Regular Contributor

Hi Christian,

Is there a way to get both?  Get notified when SDE gets locked and also what process or workstation locked it.  

Thanks

0 Kudos