Changes in This Update
SQL Server Management Pack version 18.104.22.168 includes the following changes:
· New Dashboard for SQL Server 2012 DB
· New Monitors and Rules – only for SQL 2008 and SQL 2012
o Collect DB Active Connections count
o Collect DB Active Requests count
o Collect DB Active Sessions count
o Collect DB Active Transactions count
o Collect DB Engine Thread count
o Thread Count monitor
o Transaction Log Free Space (%) monitor
o Transaction Log Free Space (%) collection
o Collect DB Engine CPU Utilization (%)
o CPU Utilization (%) monitor for DB engine
o Buffer Cache Hit Ratio monitor
o Collect DB Engine Page Life Expectancy (s)
o Page Life Expectancy monitor
o Collect DB Disk Read Latency (ms)
o Collect DB Disk Write Latency (ms)
o Disk Read Latency monitor
o Disk Write Latency monitor
o Collect DB Transactions per second count
o Collect DB Engine Average Wait Time (ms)
o Average Wait Time monitor
o Collect DB Engine Stolen Server Memory (MB)
o Stolen Server Memory monitor
o Collect DB Allocated Free Space (MB)
o Collect DB Used Space (MB)
o Collect DB Disk Free Space (MB)
o SQL Re-Compilation monitor
· SPN monitor improved
· Support for special symbols in DB names.
· Improved AlwaysOn seed discovery
· Run As configuration changes to support Low privilege for SQL Server 2012 Cluster
· Improved performance of AlwaysOn discovery
· Custom User Policy Discovery and Monitoring performance optimization
· Hided AG health object from Diagram view
· Minor changes
we tried importing this MP in our SCOM 2012 RTM environment. However the SQL Presentation contains references to SCOM Core MP’s version 7.0.9538.0, which are part of the SCOM 2012 SP1 installation. Therefor I assume that the Microsoft Documentation on this MP is actually incorrect and the required SCOM version (at least for the Presentation MP, which contains these fancy dashboards) is actually at least SCOM 2012 SP1.
Thanks for the feedback. A bug has been filed with the product team.
Did anyone install this MP´s sucessfully?
In my Environment SCOM2012 SP1 UR2 only SQL Server Core Library and Visulaization Comonent Extensions Library in version 6.4 is imported.
The other MP´s all show the following Massage:
Found error in 1|Microsoft.SQLServer.2005.Discovery/31bf3856ad364e35|22.214.171.124|Microsoft.SQLServer.2005.ReportingServices|| with message:
Could not load management pack [ID=Microsoft.SQLServer.Library, KeyToken=31bf3856ad364e35, Version=126.96.36.199]. The management pack was not found in the store.
: Version mismatch. The management pack ([Microsoft.SQLServer.Library, 31bf3856ad364e35, 188.8.131.52]) requested from the database was version 184.108.40.206 but the actual version available is 220.127.116.11.
After importing this MP, got the below alerts for many SQL servers. Is it bug in the SCOM MP?
Operations Manager Failed to convert performance data
Module was unable to convert parameter to a double value
Original parameter: ‘$Data/Property[@Name=’CPUUsage’]$’
Parameter after $Data replacement: ‘1.#INF’
Details: Type mismatch.
One or more workflows were affected by this.
Workflow name: Microsoft.SQLServer.2008.DBEngine.CPUUsagePercentMonitor
Seeing these errors on SQL 2012 since updating to 6.4
Managegement Group:* . Script: Main :
Method invocation failed because [System.Object] doesn’t contain a method named ‘op_Division’.Error occured during CPU Usage for SQL Instances data source executing.
Reason: Method invocation failed because [System.Object] doesn’t contain a method named ‘op_Division’.
I’m seeing the same thing that Dan described. Very annoying because it’s filling up the log.
I am seeing same as David in SCOM 2012 RTM for both Microsoft.SQLServer.2008.DBLogFile.FileAllocatedSpaceLeftPercent.Collection rule and Microsoft.SQLServer.2008.DBEngine.CPUUsagePercentMonitor monitor. I have disabled both MP objects until a fix found.
Same problem, this solution works for me. Hope this Help:
You should disable the following rules:
Disable the following rules:
MSSQL 2012: Collect DB Engine CPU Utilization (%)
MSSQL 2008: Collect DB Engine CPU Utilization (%)
The following monitors:
CPU Utilization (%) for 2008
CPU Utilization (%) for 2012