Last modified on 11th September 2018

Performance Data Collection

Performance collector is executed via SQL Agent Scheduled job


Scheduled to run every 1 minute starting 12 seconds past minute to avoid adding load at the full minute. 99% of the time jobs are scheduled to start at a full minute which means there is an increased load in msdb and the Agent subsystem which we are trying not to contribute to.

The job executes a stored procedure which captures the performance data: