I am having continual issues with scheme locks on our ArcSDE database, as soon as users are disconnected schema locks start appearing. We have 20 or so feature classes and it will show anywhere from 30-90 locks at a time. The timestamps show that they start up as soon as the user is disconnected, either by a system restart or the DBA disconnecting the user. I am the only user; however, am not the DBA.
We are running ArcGIS for Server 10.4.1 on SQL Server R2 2012 and I am connecting using ArcGIS Desktop Advanced. The feature classes in our enterprise geodatabase are published to our Portal as feature services and we do not use the data store.
What could be causing all these schema locks to occur, and is this something on the publisher and software user side, or on the database side?