[Script Of July 15] How to find inneficient query plans

  • Article
image image
July
15
 image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com/How-to-find-inneficient-7242d286.  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 T-SQL script will check the plan cache for the top 25 inefficient query plans. It will list total CPU time, CPU time per execution, total read IOs, average read IOs per execution, total recompiles and average recompiles per execution.

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