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.