I was approached by some developers that wanted to benchmark performance on a development server. Good for them thinking ahead before it’s in production potentially ruining performance.
Instead of using an Idera Diagnostic Manager licence, which means taking one away from a production server to monitor a dev server, I investigated other options, and discovered – Data Collection!
https://www.sqlshack.com/sql-server-performance-monitoring-data-collector/
https://sqlespresso.com/2018/10/03/sql-server-data-collection-and-management-data-warehouse/
