Plan cache option is now available as a option in Database Engine Tuning Advisor (DTA) workload. We don't need trace files/tables or manual workload, just we can use query plan cache which will select top 1,000 events for the analysis and it can be changable by DTA utility.
Published under: SQL Server Tips · · · ·