Share via

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

  • Article

UPDATE (11/12/2015): Version 6.6.3.0 which includes a fix for the issue mentioned below has been released. Please see Released: System Center Management Pack for SQL Server and Replication (6.6.3.0) for more information.

UPDATE (10/22/2015): We have removed this release from Download Center for the time being. Large number of customers reported seeing an issue with tempdb and DW log growing above normal levels. We are working on a fix and will release an update as soon as we have it ready. If you have already installed 6.6.2.0 and seeing this issue in your environment, please run the script below to mitigate the problem. You should still update your environment when we have the new release available even if you run the workaround. We apologize for the trouble this has caused you.

alter procedure sdk.Microsoft_SQLServer_Visualization_Library_UpdateHierarchy as RETURN 0;

GO

alter procedure sdk.Microsoft_SQLServer_Visualization_Library_UpdateLastValues as RETURN 0;

GO

update sdk.Microsoft_SQLServer_Visualization_Library_Tables set LastProcessedId = 9223372036854775807;

-----------------------------------------------------------------------------------------------------------------------------------------------------------

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.

SQL Server Visualization Library (dashboards) features and changes in v.6.6.2.0

  • Improved performance!

  • Dashboard displays behave in line with user permissions:

    • The user can see the groups according to his/her access level only.
    • Read-Only mode for non-authors provides basic functions only: navigation, changing of the personalization settings.

  • Dark, Light, and Contrast themes have been added.

  • Synchronization errors for the personalization settings have been fixed.

  • Upgraded interface enables displaying Dashboard errors.

  • Objects with selected monitors are now displayed on the top of the tiles list while editing.

  • If there are no child elements, Related Objects tile is not displayed in Instance View.

  • A new Dashboard feature allows displaying data from any nesting level within the widgets.

  • UI design has been upgraded and various UI errors fixed.

 

SQL Server 2005/2008/2012/2014 MP features and changes in v.6.6.2.0

  • Improved performance!
  • Added support for disabled TCP/IP protocol.
  • Fixed performance metrics error that may occur on some localized versions of Windows.
  • Fixed incorrect performance of Transaction log free space monitor.
  • Added new type of events from failed discoveries; added a new reporting rule that collects such events.
  • Added timeout overrides to prevent various scripts timeout failures.
  • Filestream filegroups are excluded from discovery until this feature is fully supported in a later version.
  • Added KB for Microsoft.SQLServer.2014.Mirroring.MirroringCommonGroupDiscovery.
  • Summary Dashboard:
    • Added monitor/performance tiles to class "SQL Server 2014 Mirroring Groups".
    • Various bug fixes in monitor tiles.
    • Reorganized 2008/2012 tiles.
    • Removed some 1X1 tiles.

 

SQL Server Replication 2008/2012/2014 MP features and changes in v.6.6.2.0

  • Updated Preset dashboards.

 

We are looking forward to hearing your feedback about this newest release!

Comments

  • Anonymous
    October 16, 2015
    The new management packs are failing the verification step during import.  For example here's one of the errors: SQL Server 2008 (Discovery) did not pass the security verification. The management pack cannot be downloaded and the temporary file has been deleted. Could not load management pack [ID=Microsoft.SQLServer.2008.Discovery, Keytoken=31bf3856ad364e35, Version=6.6.0.0].

  • Anonymous
    October 18, 2015
    Installed this release last week, was working great afterwards, however today dashboard views spin the wheel for a minute or two and when the tiles finally appear they are not populated as expected. I can't find any evidence as to why. The servers that host Ops and DW DB's aren't logging errors, neither is my local console or the MS. Anyone else experiencing this? Same result whether running the console locally on the MS or on my laptop. Running 2012 R2 CU4. >> Update: Looks like the tempDB or SCOM DB size on the DW side is blowing out rapidly, upshot is the disk runs out of space, restarted server and freed up 12 Gb which was absorbed within a couple of minutes. Total capacity 300gb drive. Is this known/expected behavior after importing these MP's? Thanks!

  • Anonymous
    October 18, 2015
    @Ron, @Davy We will investigate and reply back here. Thanks for reporting these issues.

  • Anonymous
    October 18, 2015
    We updated to the new version of the MP last week also (15th), and I was alerted on the 16th that the log file on the DW was filling up. We expanded the drive from 75GB to 150GB to 250GB and it just takes longer to fill up the log. Did some digging and looks like it sits on insert statements in the new [sdk].[Microsoft_SQLServer_Visualization_Library_UpdateHierarchy] stored proc, specifically on the insert near the end around lines 192 to 205.

  • Anonymous
    October 19, 2015
    I have the same issue as Greg. I added the SQL 2014 MP 6.6.0.0 and updated to 6.6.2.0 this morning and filled the logs and still have errors in on the Management Servers... Any suggestions. Should i remove the MP and re import it? Thanks, Mike

  • Anonymous
    October 19, 2015
    The comment has been removed

  • Anonymous
    October 19, 2015
    Transaction log for tempdb also devours the space, have had to expand the disk capacity multiple times. Growth has since stopped but dashboards are still devoid of data.... Ironic that I'd got the previous version working fine! Should have waited a few days for the dust to settle with this latest release, one to remember moving forward. Any recommended workarounds?

  • Anonymous
    October 19, 2015
    Just got this error on one of the custom views I set up last week: Stored procedure '[sdk].[Microsoft_SQLServer_Visualization_Library_GetDataCenterDashboardData]' wasn't found in Data Warehouse. It usually takes few minutes after importing the Management Pack to populate changes required for Visualization to the Data Warehouse. If this error occurs more then after 24 hours since Management Pack import then contact Operations Manager Administrator. 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.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : StoredProcedureNotAvailable System.Data.SqlClient.SqlError: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.   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
    October 19, 2015
    Davy, I have done the same and extended the Log volume to hopefully allow the process to complete. I opened a post on Technet to see if someone else has a solution but nothing. social.technet.microsoft.com/.../sql-2014-6620-filling-sql-dw-logs Hoping someone gets a fix soon as its going to suckballs to remove the SQL  2014 MP due to dependencies on the Run as profile MP and also I created some overrides to a group of servers and that Groups MP is now also a dependency on the SQL 2014 monitoring MP. Thanks, Mike

  • Anonymous
    October 19, 2015
    When can we expect a fix for the (known) visualization bug mentioned earlier? Thanks, Patrick

  • Anonymous
    October 20, 2015
    Hello everybody, We are investigating this issue and we will prepare a hotfix in a nearest days. If you are willing to participate in hotfix testing or you want to help us to determine what’s wrong with our expectations on DW contents: Could you please create a private bug on Connect platform here: connect.microsoft.com/.../SC_Public This will help us to communicate with you personally and provide you hotfix bits so we can be sure that the issue is gone before rolling out the new release. Appreciate your help.

  • Anonymous
    October 20, 2015
    Hi Aleksandr, Tried the link, got.... "Page Not Found The content that you requested cannot be found or you do not have permission to view it. If you believe you have reached this page in error, click the Help link at the top of the page to report the issue and include this ID in your e-mail: 653a2313-6022-44bc-8102-13bc94d52a8b Microsoft Connect welcome page. "

  • Anonymous
    October 20, 2015
    Getting the same errors a @Davy. I would love to participate in hotfix testing but link gave a "Page Not Found" error.

  • Anonymous
    October 20, 2015
    good grief, this MP update is horrific. I have the following problem since updating:

  • OperationsManagerDW transaction log neverending query      - fixed by removing the visualizations MP and dependencies.

  • SQL Discoveries all failing     - no idea yet, investigating.

  • Anonymous
    October 21, 2015
    Please try to open https://connect.microsoft.com, search for system center and open link with system center 2012 in a search results. Not sure why link doesn't work for you - I'm able to open it. robuea could you please submit issue with details about discoveries?

  • Anonymous
    October 21, 2015
    The updated visualization MP broke the dashboards on 20082012 SQL MP's System.ArgumentOutOfRangeException: No class with name Microsoft.SQLServer.2012.Presentation!Microsoft.SQLServer.2012.Presentation.DBEngineDashboard Parameter name: TypeName   at Microsoft.EnterpriseManagement.CompositionEngine.CompositeComponentProcessor.ResolveRootComponentReference(ComponentImplementation componentImplementation, CompositeComponentImplementation compositeComponentImplementation)   at Microsoft.EnterpriseManagement.CompositionEngine.CompositeComponentProcessor.Process(ComponentImplementation componentImplementation, CompositeComponentImplementation compositeComponentImplementation, ComponentProcessRequest request)

  • Anonymous
    October 21, 2015
    I've lodged the issue with MS, please give it a vote to raise its profile! connect.microsoft.com/.../issues-with-v6-6-2-0-mps-for-sql-server-2005-2012 Cheers

  • Anonymous
    October 23, 2015
    You can now get the previous version from the download center, or from here: www.mrchiyo.com/sql-mp-version-6-6-2-0-retracted-due-to-issues

  • Anonymous
    October 26, 2015
    The comment has been removed

  • Anonymous
    October 29, 2015
    Hi, I have updated my SQL MP 6.6.0.0 to SQL 6.6.2.0 and I found lot of "MSSQL Discovery Failed alert", So as per the statement I have try to download the new latest version SQL Server MP. But noticed, during the import the latest version is 6.6.0.0, but my current SQL server MP version 6.6.2.0 . so do you want to remove/delete the existing MP and import the 6.6.0.0 version ?

  • Anonymous
    November 02, 2015
    I have noticed that Always On database space collection isn't working anymore for SQL 2012 since 6.5.4.0. Not being able to see when a database files or log files are running full really is a big issue. I am still running 6.5.1.0 for this specific reason, since it still works in this release, it also seems to be using a different script. Can this please be looked into as well?

  • Anonymous
    November 10, 2015
    Nearly 1 month now and still no fix??

  • Anonymous
    November 11, 2015
    Is anyone experiencing weird behaviour when you use the new DataCenter Dashboard? For example, some group tiles incorrectly display the objects in the groups as 'Unavailable' or 'Not Monitored' even though the groups are properly populated and when you display the members via the traditional method they all are listed as healthy. One example I have is a group I've populated with 15 Windows Service monitors I created, the Windows Service Monitors are working as expected and appear in the Windows Computer's Health Explorer view as healthy, however when I add the group to the dashboard view they are all listed as unmonitored! Very frustrating!! I have a similar issue with groups containing logical drives. Anyone else come across this?  

  • Anonymous
    November 11, 2015
    New version 6.6.3.0 was released.

  • Anonymous
    November 11, 2015
    Installed 6..6.3 into our test environment and the failed discovery issue remains. Dashboards seem to work fine but still monitoring DW for any problems.

  • Anonymous
    November 12, 2015
    Brian Salter, could you please open a connect issue connect.microsoft.com/.../SC_Public with that issue so you can be contacted. In 6.6.2 there was an improvement in the error handling. There were situations when the script was failing but keep silence, so not problem was reported to SCOM. With the new error handling it reports about a problem in such case. The recommendation is to check the Run AS configuration for failing workflows.

  • Anonymous
    November 12, 2015
    Davy, please submit your feedback on connect.microsoft.com/.../SC_Public. Also, the recommendation is to upgrade to 6.6.3.0

  • Anonymous
    November 12, 2015
    Jasper, please submit your issue on the connect.microsoft.com/.../SC_Public

  • Anonymous
    January 31, 2016
    How to monitor SQL Server 2016 with SCOM?