Sample Header Ad - 728x90

sp_blitzIndex Usage stats vs. Op Stats

0 votes
1 answer
618 views
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:enter image description here 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