locked
SCOM 1801 - Missing (Azure) SQL monitors RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We are running multiple SQL databases under both Azure SQL and Azure Virtual Machines. The related SQL management packs don't seem to have an option to monitor the following requirements for any of these:

    - Monitoring SQL serious errors (Report errors with severity >= 20)
    - Monitoring Transaction Log backup status (Has a transaction log backup been made in the last X hours)

    Any bright ideas on how to achieve these via SCOM 1801?


    Wednesday, August 29, 2018 11:57 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Sorry this is not comes under MP, what you can do create a monitor and target them to SQL.

    Here is good example for achieving this :-

    https://social.technet.microsoft.com/Forums/en-US/39b86d27-b45a-46da-8445-311cc604a3c1/scom-2012-and-ms-sql-server-2012-log-backup-status-monitor?forum=operationsmanagermgmtpacks

    Cheers, Gourav Please remember to mark the replies as answers if it helped.

    • Marked as answer by Gijs Kerstens Monday, September 10, 2018 6:41 AM
    Friday, August 31, 2018 3:27 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Sorry this is not comes under MP, what you can do create a monitor and target them to SQL.

    Here is good example for achieving this :-

    https://social.technet.microsoft.com/Forums/en-US/39b86d27-b45a-46da-8445-311cc604a3c1/scom-2012-and-ms-sql-server-2012-log-backup-status-monitor?forum=operationsmanagermgmtpacks

    Cheers, Gourav Please remember to mark the replies as answers if it helped.

    • Marked as answer by Gijs Kerstens Monday, September 10, 2018 6:41 AM
    Friday, August 31, 2018 3:27 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you, we'll start giving it a try. Should work for SQL serious errors as well it seems.
    Monday, September 10, 2018 6:41 AM