Monitoring of special variations in SQL Agent, SSIS job execution durations

Alex Thomas 1 Reputation point
2020-07-16T04:16:54.177+00:00

We have built custom AzMon collectors for IaaS-hosted instances of SQLServer 2014/2016 SQL Agent, SSIS and SSRS. We now have statistical run charting of job, project/package and report execution durations. We want to have these durations ‘learnt’ and trigger alerts when they vary.

Maybe the Anomaly Detection API?

Any thoughts?

SQL Server on Azure Virtual Machines
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,830 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. bharathn-msft 5,086 Reputation points Microsoft Employee
    2020-07-28T23:48:40.643+00:00

    @AlexThomasDHHS-0019 Provided you are sending data to Log Analytics workspace, please review the Smart Analytics with in Log Analytics workspace and see if that fits your scenario.

    You can create an automated detector for service disruptions based exclusively on an application's trace logs. The detector seeks abnormal sudden increases in the relative amount of error and warning traces in the application.

    Two techniques are used to evaluate the service status based on trace logs data:

    • Use make-series to convert semi-structured textual trace logs into a metric that represents the ratio between positive and negative trace lines.
    • Use series_fit_2lines and series_fit_line to perform advanced step-jump detection using time-series analysis with a 2-line linear regression.

    Hope the above information helps, please revert back if you have further queries

    0 comments