The 'Op stats' are the numbers that give us the best information about index usage but can be reset at any time.
If I look to the number of writes on the Clustered index (20.716), and I have approximately the same database usage every day, Is it then safe to conclude that numbers in the 'Op stats' haven't been reset for about 6 days?
My argumentation for this is:
Writes on the clustered index happen on insert, updates and deletes. (20.716)
My server has been up for 16.67 days.
I have 7590 updates in the 'Op stats' (insert, updates, deletes)
16.67/20716*7590 = 6.1
So, my conclusion is, the 'Op stats' haven't been reset for the last 6 days.
Would you tend to agree with me on this or am I missing something?

Asked by Bart
(21 rep)
Dec 8, 2022, 08:25 AM
Last activity: Dec 8, 2022, 03:36 PM
Last activity: Dec 8, 2022, 03:36 PM