SQL Server Data Collection

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/

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.