[Script of Mar. 11] How to check SQL Server stale statistics (T-SQL)

Script Download: CheckStaleStatics.zip
https://gallery.technet.microsoft.com/How-to-check-SQL-Server-4fefea34

This T-SQL script will check SQL Server stale statistics that may cause performance issues.

Some people asked how to find stale statistics for these statistics may cause performance issues. This T-SQL script will demo how to check stale statistics which have been updated for more than 1000 times in SQL Server 2008 R2 starting with Service Package 2 or SQL Server 2012 starting with Service Package 1.

image image
 image

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