This week Microsoft released an update to SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) Management Packs (MPs) for System Center Operations Manager (SCOM).
In addition, Dashboards MP was released as a separate download with new features and fixes.
The localized versions for SSAS and SSRS were published to be compatible with this version (existing localized MPs will not work with this release due to some internal changes).
New SQL Server Analysis Services Management Pack Features and Fixes
- Updated references and removed deprecated elements to support 6.6.4.0+ visualization library
- Fixed bug when SSAS Monitoring Pack could not collect OS performance counters with localized names
- Updated discoveries to throw errors in case of some problems detected during the discovery
- Fixed module error collection on cluster instances to reduce the noise
- Changed defaults for CPU Usage monitor, added sampling to Memory Usage on the server monitor
- Reduced inner complexity of modules
- Fixed the discoveries; now the last items can be undiscovered
- Simplified the dashboard to make it quicker and more informative
- Reviewed and updated the Knowledge Bases
- Added timeout support for every non-native workflow
- Fixed Blocking Session Monitor – in some situations it could calculate blocking sessions incorrectly
- Win10 support: fixed OS version detection issue
- Fixed CPU usage alert description
New SQL Server Reporting Services Management Pack Features and Fixes
- Fixed issue: Microsoft System Center Management Pack for SQL Server Reporting Services doesn’t discover SSRS instance when the instance name starts from some certain symbols (0-9, A-F)
- Instance configuration monitor is introduced
- Implemented a better logging system
- Improved the Report Manager availability monitor: now it parses human readable message to get the real status of the Report Manager
- Improved the Report Manager and Web Service availability monitors: now the user can treat some status codes as healthy via the override.
- Fixed the discoveries, now the last items can be undiscovered
- Added timeout support for every non-native workflow
- Simplified the dashboard to make it quicker and more informative
- Reviewed and updated the Knowledge Base articles
- Improved Run As mappings
- Updated the discoveries to throw errors in case of some problems detected during the discovery
- Updated the references and removed deprecated elements to support 6.6.4.0+ visualization library
- Changed the performance rules write actions accounts to “Default Action account”
- Fixed “Memory consumed by other processes (%)” rule having no Run As profile for DS; added SQL MP default Run As to the data source
- Fixed “Failing replacement: $Data/Context/Property[@Name='<MonitorName>’]$” issue in OM log
New Dashboard Management Pack Features and Fixes
- Fixed “The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection” exception
- Replaced 999+ presentation with a new one (tile shows rolled up number with tooltip displaying the exact number)
- Added configurable rule to pre-aggregate data in the DW
- Added second row in the instance view to show Path of the object, and allow searching by Path. This makes it easier to distinguish between instances with the same name
- Fixed tooltip presentation on the Instance view
Stay tuned for VIAcode posts on performance optimizations, dashboard improvements and review of other new features.
Like us on Facebook and follow us on Twitter!
Download links:
- Management Pack for SQL Server Analysis Services enables the monitoring of Instances, Databases and Partitions
Microsoft System Center Management Pack for SQL Server 2008 Analysis Services
Microsoft System Center Management Pack for SQL Server 2012 Analysis Services
Microsoft System Center Management Pack for SQL Server 2014 Analysis Services - Management Pack for SQL Server Reporting Services (Native Mode) enables the monitoring of Instances and Deployments
Microsoft System Center Management Pack for SQL Server 2008 Reporting Services (Native Mode)
Microsoft System Center Management Pack for SQL Server 2012 Reporting Services (Native Mode)
Microsoft System Center Management Pack for SQL Server 2014 Reporting Services (Native Mode) - Management Pack for SQL Server Dashboards
Microsoft System Center Management Pack for SQL Server Dashboards