question

DeepakUppund-8412 avatar image
0 Votes"
DeepakUppund-8412 asked AlexZhu-MSFT answered

Monitoring SQL Versions 2012, 2014, 2016, 2019

Hello,

We have newly installed SCOM 2019.

We would like to monitor SQL Versions 2012, 2014, 2016, 2019. We see two different MP versions available 7.0.15 and 7.0.24. Can someone please suggest, which MP we can use to monitor above SQL servers. Please let us know if there are any other steps to be followed post importing the SQL MP.

We also need "Run as Addendum Management Pack" to monitor SQL servers. Will this MP goes with 7.0.15 / 7.0.24 MP Version?

Regards,

msc-operations-manager
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.

1 Answer

AlexZhu-MSFT avatar image
1 Vote"
AlexZhu-MSFT answered

Hi,

7.0.24 is the new one and we may use this.

Microsoft System Center Management Pack for SQL Server
https://www.microsoft.com/en-us/download/details.aspx?id=56203

For "Run as Addendum Management Pack", we may refer to KEVIN HOLMAN's great blog. It should work with 7.0.24, if you have any concern, you can leave a message at the bottom of the blog and waiting for KEVIN HOLMAN's reply.

SQL MP Run As Accounts - NO LONGER REQUIRED
https://kevinholman.com/2016/08/25/sql-mp-run-as-accounts-no-longer-required/
Note: this is NOT from MS, just for your reference.

Regards,

Alex
If the response is helpful, please click "Accept Answer" and upvote it.

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.