Welcome to Community Answers

Question

SQL 2017+ Server list and Performance View

0

jf 3 Rep. 11 Apr, 2018

Some ideas for how to make list and performance view for SQL2017+, as there is no SQL2017+ computer group.

Or have to make a SQL 2017+ computer group i scom

sql

Jelly answered 6 days ago

To reply or comment, use the 'Comment' link on the relevant answer or question.

score 0 · Answer 1 · 2018-04-11T12:54:27+00:00

Have you installed the management pack for 2017+ in scom?

You should get the groups for 2017 then. I think it is called MSSQL on windows?

https://www.microsoft.com/en-us/download/details.aspx?id=56203

score 0 · Answer 2 · 2018-04-11T13:01:50+00:00

0

jf 3 Rep. 11 Apr, 2018

Yes, but the management pack for 2017+ dos not contain a MSSQL On Windows Computer Group.

SQL 2016 Computer Group

SQL 2017+ Groups, No Computer group

jannep commented 11 Apr, 2018

jannep - 11 Apr, 2018

Ah.. that makes it harder. I dont have any 2017 machines yet so I cant see if there is another way to find them.

score 0 · Answer 3 · 2018-04-16T13:16:45+00:00

0

Jelly 3.13K Rep. 6 days ago

The MP does not contain a group for this, however, you can use classes:

Currently, there is not a dashboard pack for SQL 2017+ – perhaps you can request a pack from support?

Jelly commented 6 days ago

jf - 6 days ago

My problem is to get a view like "SQL 2016 Performance" where I can se the performance of the Windows server (DB - Disk Space Free %, Server - CPU Used % and Server - Memory Used %), where SQL2017+ is installed ("SQL2017+ computer group") I can't see a way to get that from any of this classes
Jelly - 5 days ago

The perspectives won't exist out of the box as the existing SQL ones are contained in packs already created by the Squared Up community (https://community.squaredup.com/dashboards/) - You will need to recreate them manually (you can duplicate dashboards/perspectives to save time) and simply amend the scoping to the class structure, rather than using the groups. This will require looking at the rules (SCOM console > Authoring > Rules) for the metrics to check the targets are correct.