Using DMVs with Database Tuning Advisor

by user3756096   Last Updated July 13, 2016 08:02 AM

DMVs / DMFs are supposed to be used now instead of SQL Server Profiler because of resource hogging of Profiler, right?

In that case, could someone point me in the direction of a good article / training on how to use DMVs in checking before and after major changes or a new server. Ie at the moment one would create a trace file via Profiler and run it under different scenarios on a test server via Database Engine Tuning Advisor. How would I do this now using DMVs instead of Profiler (with or without Tuning Advisor - whichever you advise)?

Tags : performance dmv


Related Questions


Lower performance on newest servers

Updated August 29, 2017 14:06 PM


poor and/or unreliable InnoDB performance

Updated June 21, 2017 04:06 AM


SQL Server Actual Plan. Incorrect row estimates

Updated September 28, 2017 14:06 PM