Post reply

Index Usage Statistics - Reports

  • August 15, 2018 at 5:57 pm

    #408073

    Hi All,
    I am looking at the default reports in SQL 2016 the Index Usage/Operational Statistics and trying to understand what the different columns mean whether the numbers are good or bad. I have googled for a explanation does anyone have any blogs or reference material that explains these reports?

    Thanks

  • August 23, 2018 at 3:36 pm

    #2003120

    I generally do not run this Report  much for gathering Index usage stats ( operational) . Some good information is provided in this link . 

    https://www.sqlshack.com/gathering-sql-server-indexes-statistics-and-usage-information/

  • August 23, 2018 at 7:10 pm

    #2003135

    ringovski - Wednesday, August 15, 2018 5:57 PM

    Hi All,
    I am looking at the default reports in SQL 2016 the Index Usage/Operational Statistics and trying to understand what the different columns mean whether the numbers are good or bad. I have googled for a explanation does anyone have any blogs or reference material that explains these reports?

    Thanks

    Check the definitions of the columns in the documentation of the views for index usage and index operational stats:
    sys.dm_db_index_operational_stats
    sys.dm_db_index_usage_stats

    Sue

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply