[Script of Jun. 12] How to get index usage information in SQL Server databases

  • Article

Script Download:   
The script is available for download in Microsoft Script Browser for Windows PowerShell ISE.You need to install the Script Browser application first, and search for the script sample title.

This T-SQL script will demo how to find all the user_seek, user_scans, user_lookups, user_updates information in the user tables from the last time SQL Server starts.

There are some people asking how to find index usage from the last time SQL Server starts. This script will demo how to find all the index usage numbers and the last time of usage.

image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery