What kind of monitoring does Mom\Scom can do for sqlserver

  • Hello,

    I'm very new to SCOM. I would like to know how SCOM can be used to Monitor SQL Server. What kind of details\Reports we can extract from SCOM.

    Thanks in Advance for your reply

    SK.

  • In short, it can do almost anything you want. There are lots of videos and webcasts on their website so go check them out. It's really good stuff.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • A good starting point is reading through this link:

    Microsoft SQL Server Management Pack:

    http://technet.microsoft.com/en-us/library/cc511079(TechNet.10).aspx

    Out of the box SCOM monitors a limited subset of things, such as service and database availability and blocking. But SCOM is infinitely customizable, and therein lies its power.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply