# SQL Version Agnostic MP

**URL:** <https://community.squaredup.com/t/sql-version-agnostic-mp/980>\
**Category:** Dashboard Server\
**Tags:** sql, management-pack, dashboards, scom\
**Created:** [June 18, 2019, 1:04am UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980 "2019-06-18T01:04:55Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![rtbywalski](https://community.squaredup.com/letter_avatar_proxy/v4/letter/r/b487fb/32.png) [@rtbywalski](https://community.squaredup.com/u/rtbywalski)\
**Post date:** [June 18, 2019, 1:04am UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/1 "2019-06-18T01:04:55Z")

</div>

I am about to upgrade my SQL management pack to the version. Has anyone tried this yet I am curious what will happen to the SQL perspectives when I do this will I need too update them in anyway?

---

<div class="post-metadata">

**Author:** ![matthewcreighton](https://community.squaredup.com/letter_avatar_proxy/v4/letter/m/d07c76/32.png) [@matthewcreighton](https://community.squaredup.com/u/matthewcreighton)\
**Post date:** [June 18, 2019, 8:31am UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/2 "2019-06-18T08:31:02Z")

</div>

If you have any experience of the bonkers new classes in the 2017 MP it is essentially the same as that.

• SQL Server 2016 DB Engine  
• SQL Server 2012 DB Engine  
• SQL Server 2008 DB Engine

• SQL Server 2016 DB  
• SQL Server 2012 DB  
• SQL Server 2008 DB

Becomes:

• MSSQL on Windows: Local DB Engine  
• MSSQL on Windows: DB Engine  
• MSSQL on Windows: Local DB

&nbsp;

&nbsp;

So while I have not tried it in v4 you can imagine it will all stop things working with perspectives

---

<div class="post-metadata">

**Author:** ![rtbywalski](https://community.squaredup.com/letter_avatar_proxy/v4/letter/r/b487fb/32.png) [@rtbywalski](https://community.squaredup.com/u/rtbywalski)\
**Post date:** [June 18, 2019, 11:40am UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/3 "2019-06-18T11:40:28Z")

</div>

I opened a ticket with support and their advice was not to install the new MP at this time. It will break dashboards as well as VADA. The reason being that this is a brand new MP and not an upgrade so it changes everything on the SCOM side from object type to counters so Squared UP is not referencing the correct objects. That was the answer I was expecting as I read the manual for the MP. Now that said this is the only SQL MP that MS is supporting going forward and it was released end of April so I am hoping we see an update from Squared UP soon that addresses the issues and then we can move forward with the new install. I have a new SCOM install going on and would love to convert over to it but we are using VADA so converting at this time is not a good idea for us.

---

<div class="post-metadata">

**Author:** ![shawn149](https://community.squaredup.com/user_avatar/community.squaredup.com/shawn149/32/822_2.png) [@shawn149](https://community.squaredup.com/u/shawn149)\
**Post date:** [June 18, 2019, 7:44pm UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/4 "2019-06-18T19:44:09Z")

</div>

Maybe this is old news, but Kevin Holman posted a blog on how to transition from old SQL MP to the new SQL MP…

How to transition to the SQL Version Agnostic MP

[https://kevinholman.com/2019/06/12/how-to-transition-to-the-sql-version-agnostic-mp/](https://kevinholman.com/2019/06/12/how-to-transition-to-the-sql-version-agnostic-mp/)

---

<div class="post-metadata">

**Author:** ![nicole-gyde](https://community.squaredup.com/letter_avatar_proxy/v4/letter/n/ebca7d/32.png) [@nicole-gyde](https://community.squaredup.com/u/nicole-gyde)\
**Post date:** [June 18, 2019, 1:49am UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/5 "2019-06-18T01:49:20Z")

</div>

I haven’t tried it yet but from what I read there is a new class for all the current versions so anything scoped by class would be affected i’m guessing but i’ll be interested to hear more from someone actually hands on with it 🙂

---

<div class="post-metadata">

**Author:** ![matthewcreighton](https://community.squaredup.com/letter_avatar_proxy/v4/letter/m/d07c76/32.png) [@matthewcreighton](https://community.squaredup.com/u/matthewcreighton)\
**Post date:** [June 18, 2019, 8:33am UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/6 "2019-06-18T08:33:11Z")

</div>

I should probably add - if you put it in and remove all the old MPs it will have an effect on everything that is scoped or overridden using the old classes - so you want to plan that

They do offer updated versions of the old MPs I think that essentially mark things as ‘old’ so they can work side by side but not tried these

However, moving forward it will make things vastly simpler - a single monitor for Buffer hit cache ratio to override - instead of one per version and views per version - it had got a bit messy

---

<div class="post-metadata">

**Author:** ![Jelly](https://community.squaredup.com/user_avatar/community.squaredup.com/jelly/32/812_2.png) [@Jelly](https://community.squaredup.com/u/Jelly)\
**Post date:** [June 18, 2019, 9:04am UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/7 "2019-06-18T09:04:59Z")

</div>

I haven’t seen a dashboard pack for the 2017+ MPs unfortunately. We’re a little behind the curve with our SQL estate and haven’t upgraded anything yet ☹ It’s likely that you’ll need to find the 2016 dashboards and perspectives, clone them, and update the scoping for the new classes for the perspective and tile scopes.

---

<div class="post-metadata">

**Author:** ![matthewcreighton](https://community.squaredup.com/letter_avatar_proxy/v4/letter/m/d07c76/32.png) [@matthewcreighton](https://community.squaredup.com/u/matthewcreighton)\
**Post date:** [June 18, 2019, 9:24am UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/8 "2019-06-18T09:24:11Z")

</div>

Can we make them? how do we do that?

---

<div class="post-metadata">

**Author:** ![matthewcreighton](https://community.squaredup.com/letter_avatar_proxy/v4/letter/m/d07c76/32.png) [@matthewcreighton](https://community.squaredup.com/u/matthewcreighton)\
**Post date:** [June 18, 2019, 1:31pm UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/9 "2019-06-18T13:31:29Z")

</div>

It will only ‘break’ dashboards if you remove the old ones totally - there is ‘new old’ ones that can sit along side the ‘new new’ one while you migrate over

It is not that hard with the info I have provided to re-point dashboards to the correct objects in any case

I have just made new version agnostic perspectives for SQL server, SQL DB, SQL Engine in the last couple of hours - which I can share

We have a new environment being built - what is the impact on VADA?

---

<div class="post-metadata">

**Author:** ![matthewcreighton](https://community.squaredup.com/letter_avatar_proxy/v4/letter/m/d07c76/32.png) [@matthewcreighton](https://community.squaredup.com/u/matthewcreighton)\
**Post date:** [June 18, 2019, 1:52pm UTC](https://community.squaredup.com/t/sql-version-agnostic-mp/980/10 "2019-06-18T13:52:58Z")

</div>

@jelly the new SQL MP is version agnostic - so you don’t need a new version of SQL to use it / test it / try it
