Released: Public Preview for SSRS and SSAS 2008-2016 Management Packs (7.0.16.0)

We are getting ready to release an update for SCOM Management Packs for SQL Server Reporting Services and Analysis Services 2008-2016. We appreciate the time and effort you spend on these previews which make the final product so much better.

Please download at:

Microsoft System Center Management Packs (Community Technology Preview) for SQL Server 2008-2016 Reporting Services (Native Mode)

Microsoft System Center Management Packs (Community Technology Preview) for SQL Server 2008-2016 Analysis Services

SSAS  2008-2016 MP

• Added performance collections for MDX Query performance counters
• Added retry logic to some workflows in order to reduce “Category does not exist” errors thrown when WMI fail to respond
• Improved error handling in workflows that watch for memory consumption
• Improved descriptions of events thrown by management pack to make it easier to figure out error reason
• Fixed Start/Stop tasks
• Fixed issue when “SQLServerInstalled” property was set to “False” if SQL Server DB Engine was of higher version than SSAS instance
• Updated Dashboards configuration to show tiles for new MDX performance collections
• Updated display strings

SSRS  2008-2016 MP

• SSRS 2016: Updated monitoring of Memory Consumption and CPU Usage in order to collect performance data for all subprocesses in addition to the main SSRS service process.
• SSRS 2016: Updated monitors “Report manager accessible” and “Web service accessible” to consider specifics in how appropriate SSRS 2016 web services work
• Added support for cases when connection string to SSRS Database is set up the way different from “MachineName\InstanceName” (e.g., <IPAddress,Port>) and SSRS Database is in Availability Group or hosted either by named instance or SQL Cluster instance
• Improved descriptions of events thrown by management pack to make it easier to figure out error reason
• Improved error handling and error descriptions for cases when workflows can’t get responses from WMI
• Improved error handling in workflows that watch for memory consumption
• Fixed Start/Stop tasks
• Fixed issue that caused some workflows to throw error events when SQL Server instance hosting SSRS Databases happened to stop operating or refuse connections
• Fixed issue which caused Reporting Service instance to get undiscovered when WMI didn't respond to calls
• Updated display strings

For more details, please refer to the user guide at the location above.
We are looking forward to hearing your feedback at sqlmpsfeedback@microsoft.com.