topic Re: SQL Server SDE database locked in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/sql-server-sde-database-locked/m-p/841933#M4727 <HTML><HEAD></HEAD><BODY><P>Hi Christian,</P><P></P><P>Is there a way to get both?&nbsp; Get notified when SDE gets locked and also what process or workstation locked it.&nbsp;&nbsp;</P><P></P><P>Thanks</P></BODY></HTML> Wed, 02 Oct 2019 18:30:05 GMT JoseSanchez 2019-10-02T18:30:05Z SQL Server SDE database locked https://community.esri.com/t5/geodatabase-questions/sql-server-sde-database-locked/m-p/841931#M4725 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>What&nbsp; tools do you recommend to monitor&nbsp; an SDE SQL Server database that gets locked and it does not allow to open any connection using ArcCatalog.</P><P></P><P>We are using this link to check the locks, but we wil like to monitor the database to prevent these locks:</P><P></P><P><A class="link-titled" href="https://support.esri.com/en/technical-article/000010395" title="https://support.esri.com/en/technical-article/000010395">How To: Obtain a listing of user processes and locks from a geodatabase when there is no ArcSDE service</A>&nbsp;</P><P></P><P>Thanks</P></BODY></HTML> Tue, 01 Oct 2019 20:12:58 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-sde-database-locked/m-p/841931#M4725 JoseSanchez 2019-10-01T20:12:58Z Re: SQL Server SDE database locked https://community.esri.com/t5/geodatabase-questions/sql-server-sde-database-locked/m-p/841932#M4726 <HTML><HEAD></HEAD><BODY><P>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 <EM style="text-decoration: underline; "><STRONG>who</STRONG></EM> is locking the database? Or just to be notified <EM style="text-decoration: underline; "><STRONG>when</STRONG> </EM>is becomes locked?</P></BODY></HTML> Tue, 01 Oct 2019 21:51:17 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-sde-database-locked/m-p/841932#M4726 ChristianWells 2019-10-01T21:51:17Z Re: SQL Server SDE database locked https://community.esri.com/t5/geodatabase-questions/sql-server-sde-database-locked/m-p/841933#M4727 <HTML><HEAD></HEAD><BODY><P>Hi Christian,</P><P></P><P>Is there a way to get both?&nbsp; Get notified when SDE gets locked and also what process or workstation locked it.&nbsp;&nbsp;</P><P></P><P>Thanks</P></BODY></HTML> Wed, 02 Oct 2019 18:30:05 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-sde-database-locked/m-p/841933#M4727 JoseSanchez 2019-10-02T18:30:05Z