SQL Server SDE database locked

427
2
10-01-2019 01:12 PM
JoseSanchez
Occasional Contributor III

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
Occasional Contributor III

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