AnsweredAssumed Answered

How Many Database States is too many?

Question asked by Tyler.SmithSRQ on Aug 25, 2020
Latest reply on Aug 27, 2020 by Tyler.SmithSRQ



I currently run a weekly Compress and Rebuild Indices/Analyze every Friday at 11:30 PM. This works because it avoids conflicts with the maintenance IT does over the weekends. 


My question is: should I compress daily? There has only been one time the compress did not get to state 0, and this was due to an orphaned lock. We have never had orphaned states (thankfully) and the highest state count I have seen in the compress log table was around 900 or so. 


Since I haven't found good documentation on how many DB states is considered "too much" I am not sure if less than 1000 is fine for a weekly compress, or if I should be compressing daily. 


Thank you!