Find Shared instance scheam locks

DrewDowling — Wed, 10 Nov 2021 22:11:17 GMT

I'm trying to track down schema locks coming from map services. I have noticed that shared instances no longer have the check box to "lock database schema". The attached images shows this difference.

However I have determined that the locks are coming from shared instances using the code below. Is there a way to tell shared instances to not lock schemas in the same way as you can with dedicated instances? The shared instance process ID doesn't tell me which map service is causing the lock.

SELECT A.SERVER_ID, B.OWNER || '.'|| B.TABLE_NAME "TABLE", A.NODENAME, L.LOCK_TYPE FROM SDE.SDE_PROCESS_INFORMATION A, SDE.SDE_TABLE_REGISTRY B, SDE.SDE_TABLE_LOCKS L WHERE A.SDE_ID = L.SDE_ID AND L.REGISTRATION_ID = B.REGISTRATION_ID ORDER BY NODENAME, SERVER_ID;

Re: Find Shared instance scheam locks

Ann-MarieFalkowski1 — Fri, 06 Jan 2023 14:04:23 GMT

It does not look like it is possible. According to the documentation, "Note: You cannot disable schema locking on map services configured to use the shared instance pool."

Source: https://enterprise.arcgis.com/en/server/latest/administer/windows/disabling-schema-locking-on-a-map-service.htm

topic Re: Find Shared instance scheam locks in ArcGIS Enterprise Questions

Find Shared instance scheam locks

Re: Find Shared instance scheam locks