New SCOM dashboard gems available with SQL MP

This is just a short post to point everybody to the new SQL MP released last week. This MP comes with completely new and revamped dashboards:

Overview (Datacenter) Dashboard

You can create overview dashboards for SCOM groups and include State and Alert data for the group as well as aggregated performance and monitoring data:


Individual (Instance) Dashboards

The datacenter dashboards allows you to drill into your data and create additional tiles with monitoring and performance data:

And the best thing is:
You can use these dashboards for all other (custom) SCOM classes, counters and monitors!

So you are not limited to SQL data. This is just a quick demo dashboard for one of my test Management Groups:

You can find all necessary details and steps to set these dashboards up and running in the attached SQLServerDashboards.docx document which is also included in the new SQL MP.

Call to action

Download and install the new SQL MP as soon as possible in your favorite test environment. Read the documentation and quickly create powerful, great looking Dashboards!


Comments (16)
  1. Watts says:

    I’ve installed the 6.6 SQL MP and found that it works fine for anyone in the Operations Manager Administrators role, however if the user is a member of any other role, such as the Advanced Operators role, the SQL Server 2008 and SQL Server 2012 summary
    screens do not show data. They show 0 "No States" and 0 "No Alerts". Is anyone else having this issue?

  2. Scott B says:

    The dashboards were working for me at first now do not.

  3. Diane K says:

    We have scoped operator user roles as well. The high level SQL 2008 and 2012 Summary screens work. Drilling into one of the areas, such as SQL Server 2008 Instances, fails to return data – no list of instances returned.

  4. johnredd says:

    These also worked for me for about a week and now all sql dashboards are blank or chow 0 states, 0 alerts

  5. Travis says:

    Same Problem as others are reporting. Dashboards show 0 "No States", 0 "No Alerts"

  6. Fa says:

    Same Problem as others are reporting. Dashboards works fine for OM Administrators but display "No State" and "No Alerts" for all other User Roles.
    As temporar (i hope) workarround, i’ve added some DB User to OM Admin.

  7. Warren says:

    I’m having the same problem it worked and now i’m getting the timeout error.
    Has anyone tried removing the visualization management packs and re-importing them?

  8. Andres P says:

    Dirk – please can You help out people with this error ( Including me)?

  9. Strohsx says:

    I’m having the same issue as everyone else, everything is showing no data, has anyone found a solution to this?

  10. Davy says:

    Re-indexing the DW DB should fix the issues with the tiles not populating. Speak to your DBA’s!

    @Dirk, I think the tiles, once they’re working, are, in many instances, reporting incorrect volumes of ‘not monitored’ objects. Particularly with large groups. I’ve spent pretty much all of today trying to work out how the logic gets such a high level of ‘not
    monitored’ yet when you drill down there are none in this state listed….any ideas? The subtotals on the top tiles correctly add up to the overall number of objects in the group but the incorrectly labeled ‘not monitored’ figures undermine the veracity of
    the views.

  11. @All: Please check the new SQL MP 6.6.2 it should fix several of the mentioned issues.

  12. Erling B K says:

    The Summary Dashboard in – is timing out – somehow.. I get this error – after waiting for something like 1-3 minutes…

    An error occurred executing the command: [Microsoft.SQLServer.Visualization.Library.DataProviders!DatacenterDashboardDataProvider/GetDatacenterDashboardData] in provider: [Microsoft.SQLServer.Visualization.Library.DataProviders.DatacenterDashboardDataProvider,
    Microsoft.SQLServer.Visualization.Library.DataProviders, Version=, Culture=neutral, PublicKeyToken=XXXXXXXXXXXX]. : The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.
    at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)
    at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.ExecuteScalarInternal[TResult](DataCommand command)
    at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.b__2[TResult](<>f__AnonymousType0`1 data)

    Note the key-token i have replaced with XXXXXX

    Any good reason why it dosen’t Work at all ?

    Yours Erling B. Kjeldsen

  13. Jeff C says:

    I am having the same problem as Erling above

  14. I have the same problem also with the new Dashboards. Anyone know what this means and how to actually do it?
    The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

  15. Allmora says:

    I have the same problem

Comments are closed.

Skip to main content