次の方法で共有


Released: System Center Management Pack for SQL Server and Replication (6.6.4.0)

We are happy to announce that a new version of SQL Server and Replication Management Packs has been released! Only the English version is available at this time. Localized management packs for this version will be made available at a later time.

Downloads available:

Please see below for the new features and improvements in the dashboards, SQL Server MPs, and Replication MPs. More detailed information can be found in guides that can be downloaded from the links above.

Two Issues Fixed

There were two issues uncovered in 6.6.3.0 that is fixed in this release (6.6.4.0).

  • If the SCOM installation uses SQL Server 2008 or SQL Server 2008 R2, users will see an error during installation:

    'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: Script, Id: '4173391e-ce71-1369-c358-17030bb09b41', Management Pack Version-dependent Id: 'a2bce88f-fcf8-ddcb-7b0f-4d343e766e78'; Target: Database, Server name: 'XXXXXXX', Database name: 'OperationsManagerDW'. Batch ordinal: 42; Exception: Operand data type uniqueidentifier is invalid for max operator.

    The user will not be able to use the SQL Dashboards. The user will see errors in the dashboards and the error log.

  • If the dashboards user has limited access rights to DW (granted only the OpsMgrReader role), he cannot access and/or modify the LastAlertValues table and he will get an error:

    The INSERT permission was denied on the object 'Microsoft_SQLServer_Visualization_Library_LastAlertValues', database 'OperationsManagerDW'

    The limited rights user will not be able to use the SQL Dashboards.

We are looking forward to hearing your feedback.

Comments

  • Anonymous
    December 13, 2015
    After running the SQL scripts from the 6.6.4 management packs and installing the 6.6.4 management packs, I'm getting this error.  It worked for about 3 days and now it shows this: 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=6.6.4.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : 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.<ExecuteScalarAsync>b__2[TResult](<>f__AnonymousType0`1 data)

  • Anonymous
    December 15, 2015
    I'm running into the same issue Bill is with the SQL Dashboards in 6.6.4.0

  • Anonymous
    December 15, 2015
    Same Issue with MP 6.6.4.0  as Reported from David and Bill! SCOM 2012R2 with newest UR

  • Anonymous
    December 15, 2015
    My existing dashboards have now broken with the same error message: New dashboards can be created but they cannot be edited. I have no options to add groups or anything of the sort.

  • Anonymous
    December 17, 2015
    same issue here... CU7

  • Anonymous
    December 22, 2015
    After deploying SQL MP 6.6.4.0 i'm getting several "The Operations Manager agent processes are using too much processor time" alerts. Platform : SCOM 2007 R2 Any idea to deep analysis on this issue ?

  • Anonymous
    December 27, 2015
    Glad I'm not the only one having issues with the SQL management pack version 6.6.4. Does anyone know of a workaround?

  • Anonymous
    December 27, 2015
    Oh, I just ran the Operations Console with the clearcache flag, and it seems to work now...

  • Anonymous
    January 03, 2016
    We saw this issue too, raised a case via PSS and were sent an updated MP, the updated MP all dashboards seem to function. We are now on version 6.6.5.1 for Microsoft SQL Server Generic Dashboards, Presentation and visualization Library.

  • Anonymous
    January 10, 2016
    The comment has been removed

  • Anonymous
    January 11, 2016
    We are not able to save monitor/performance views -- is this expected?

  • Anonymous
    January 13, 2016
    Same thing here....6.6.4.0 worked fine since Nov 2015 but suddenly yesterday dashboard issue started again :(

  • Anonymous
    January 20, 2016
    I've searched the internet for this version, and cannot find it.  Can someone provide a link? Thanks, Bill

  • Anonymous
    January 29, 2016
    Dashboards have not worked for me since going to 6.6.4.0. When will this be fixed?

    • Anonymous
      February 04, 2016
      It took them 9 months to fix the 2015 CRM management pack for SCOM which was broken straight out the door, I wouldn't hold my breath.
  • Anonymous
    February 25, 2016
    Do we have news for this problem ? Any solution ?My MP visualization is failing the same way...

  • Anonymous
    February 29, 2016
    The reconnect issue some of you have hit will be fixed in the next release. You should see a dashboard release within a month with this fix. When ready it will be announced in this blog.

  • Anonymous
    March 15, 2016
    The comment has been removed

  • Anonymous
    April 19, 2016
    Any date for the new release ?

    • Anonymous
      April 19, 2016
      We have released Community Technology Preview (CTP) bits. Please see blog post for more info. RTM for all versions will be within 30 days of SQL Server 2016 RTM.