I have a Enterprise Geodatabase (SDE) in SQL Server 2016. I have a nightly python script to preform some maintenance including the compress function (among other things).
I am noticing that the state counts after the compress are not going lower than 8. The before state count is higher but no matter what the count never reaches 1 (sometimes it does go to 7).
Why is the count staying at this number after the compress? does this indicate something is wrong, or a possible conflict/issue in the near future?