Top query plans Analysis
Pssdiag captures top CPU consuming query plans. This report analyzes the query plans. Currently it only produces tables used by these plans. This is very helpful if you don’t have time windows to update statistics on
all the tables. You can focus on these tables because they were used by the top CPU consuming query plans.