[Script of Nov. 28] Find inefficient query plans
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.
You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery