Blog Post

SQL Server Blog
1 MIN READ

Released: SCOM Management Packs for SQL Server, RS, AS, Azure SQL Managed Instance (7.0.34.0)

EbruErsan's avatar
EbruErsan
Icon for Microsoft rankMicrosoft
Dec 21, 2021

Updates to SQL Server, Reporting Services, Analysis Services, and Azure SQL Managed Instance Management Packs are available (7.0.34.0). You can download the MPs from the links below. Majority of the changes are based on your direct feedback. Thank you.

 

Download Microsoft System Center Management Pack for SQL Server from Official Microsoft Download Center

Download Microsoft System Center Management Pack for SQL Server Analysis Services from Official Microsoft Download Center

Download Microsoft System Center Management Pack for SQL Server Reporting Services from Official Microsoft Download Center

Download Microsoft System Center Management Pack for Azure SQL Managed Instance from Official Microsoft Download Center

 

Another change we've done recently is to move operations guides for all SQL Server family of management packs from download center to docs.microsoft.com. This unifies the content viewing experience for the user as the rest of the SCOM and SQL Server documentation is already there. Further more, it allows us to present you with the most up to date and accurate content online. The link to the operation guide for each MP can be found on the MP download page. Here are the links that show what's new in these MPs:

Features and Enhancements in Management Pack for SQL Server

Features and Enhancements in Management Pack for SQL Server Analysis Services

Features and Enhancements in Management Pack for SQL Server Reporting Services

Features and Enhancements in Management Pack for Azure SQL Managed Instance

 

Published Dec 21, 2021
Version 1.0
sqlreleases

2 Comments

  • Jan Pettersson's avatar
    Jan Pettersson
    Copper Contributor
    Jan 14, 2022

    Hi!

    After installing the latest version i get these errors in the scom console.

    Publisher = SQLMonitoringWindows
    HealthCalcMode = 1
    StateType = ThreeState
    Threshold11 = 10
    Threshold12 = 20
    Threshold21 = 5000
    Threshold22 = 10000
    TimeoutSeconds = 300
    Value1Name = FdFreeSpacePercentMon
    Value1StateDirection = BadLessT1
    Value2Name = FdFreeSpaceMBMon
    Value2StateDirection = BadLessT1

    Error(s):

    ---------- Exception: ----------
    Exception Type: Microsoft.EnterpriseManagement.HealthService.MalformedDataItemException
    Message: Exception has been thrown by the target of an invocation.
    Source: Microsoft.Mom.Modules.DataTypes
    Stack Trace:
    at Microsoft.EnterpriseManagement.Mom.Modules.DataItems.PropertyBagDataItem..ctor(XmlReader reader)
    at Microsoft.SQLServer.Core.Module.Helper.ScomModules.Monitoring.MultiValueSpaceHealthCalculator.GetPropertyBag(DataItemBase[] inputDataItems, CancellationToken token)
    at System.Threading.Tasks.Task`1.InnerInvoke()
    at System.Threading.Tasks.Task.Execute()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.SQLServer.Module.Helper.Helpers.AsyncHelper.<ExecuteAsync>d__0`1.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.SQLServer.Module.Helper.Base.DataItemHelper.<>c__DisplayClass4_0`1.<<GetModuleDataWithTimeout>b__0>d.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.SQLServer.Module.Helper.Base.DataItemHelper.<GetPropertyBagDataAsyncStatic>d__5`1.MoveNext()

    ---------- Inner Exception: ----------
    Exception Type: System.Reflection.TargetInvocationException
    Message: Exception has been thrown by the target of an invocation.
    Source: mscorlib
    Stack Trace:
    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
    at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at Microsoft.EnterpriseManagement.Mom.Modules.DataItems.PropertyBagDataItem.StructureFactory`1.CreateFromString(String stringValue)
    at Microsoft.EnterpriseManagement.Mom.Modules.DataItems.PropertyBagDataItem.ConvertObjectToVariantType(String input, UInt16 vt)
    at Microsoft.EnterpriseManagement.Mom.Modules.DataItems.PropertyBagDataItem.ReadCollectionFromXml(XmlReader reader)
    at Microsoft.EnterpriseManagement.Mom.Modules.DataItems.PropertyBagDataItem.InitializeExtendedDataFromXml(XmlReader reader)
    at Microsoft.EnterpriseManagement.Mom.Modules.DataItems.PropertyBagDataItem..ctor(XmlReader reader)

    ---------- Inner Exception: ----------
    Exception Type: System.FormatException
    Message: Input string was not in a correct format.
    Source: mscorlib
    Stack Trace:
    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
    at System.Double.Parse(String s)