[Script of Nov. 28] Find inefficient query plans

  • Article

Script Download: 21998.zip
https://gallery.technet.microsoft.com/scriptcenter/Find-inefficient-query-88f4611f

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.his PowerShell script will demo how to back up a SSAS database.

The script will check the plan cache for the top 25 inefficient query plans.

image image
image

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