Select to view content in your preferred language

Find Shared instance scheam locks

1259
1
Jump to solution
11-10-2021 02:11 PM
DrewDowling
Frequent Contributor

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;

 

1 Solution

Accepted Solutions
Ann-MarieFalkowski1
Occasional Contributor

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-...

-Ann-Marie

View solution in original post

1 Reply
Ann-MarieFalkowski1
Occasional Contributor

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-...

-Ann-Marie