I need to generate a baseline before initiating corrective action on some querys on the database. I need some reference to compare and see how we've improved.
I need to consider the following aspects:
Measure the current consumption of resources by SQL Server.
Measuring how various workload of SQL Server in time.
Monitor peak consumption to avoid rework.
It is possible to generate the baseline, running SQL dynamic view "sys.dm_"