question

alexthomas avatar image
0 Votes"
alexthomas asked bharathn-msft answered

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

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?

azure-monitorazure-sql-virtual-machines
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AlexThomasDHHS-0019 - Apologies for delayed response, if you are sending data to Log Analytics workspace, can you please review the Smart Analytics with in Log Analytics workspace and see if that fits your scenario.

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

0 Votes 0 ·

1 Answer

bharathn-msft avatar image
0 Votes"
bharathn-msft answered

@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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.