OneScript Team Blog

A world of automation script samples based on IT Pros' real-world tasks

[Script Of July 9] How to get index usage information in SQL Server databases

[Script Of July 9] How to get index usage information in SQL Server databases

  • Comments 1
  • Likes
image image
July
9
image

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-get-index-usage-0c34ba21.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

This PowerShell 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.

Some people ask how to find indexes usage from the last time SQL Server starts. This script will demo how to find all the indexes usage numbers and last time of usage.

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

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment