Detailed information
& download links:
Deployment Summary dashboard
Deployment Summary dashboard has
five widgets:
1. SSRS
Deployments – shows the list of discovered SQL Server 2014 Reporting
Services Deployments with their overall states.
2. Details
– shows properties for the selected Deployment.
3.
Active Alerts – shows the list of active
alerts triggered for the selected Deployment or related (contained) objects.
4.
SSRS Instances – shows the list of SSRS
Instances contained in the selected Deployment and their overall states. Note:
you may double click the name of an Instance in the “SSRS Instances” widget to
drill down to “Instance Summary” dashboard.
5. Monitoring
– shows state and performance tiles for following rules and monitors
Instance Summary dashboard
Instance Summary dashboard has
four widgets:
1.
Instances – shows the list of discovered
SQL Server 2014 Reporting Services Instances with their overall states.
2.
Details – shows properties for the
selected SSRS Instance.
3.
Active Alerts – shows the list of active
alerts triggered for the selected SSRS Instance.
4.
Monitoring – shows state and performance
tiles for following rules and monitors:
Discovery of SQL Server 2014
Reporting Services Instance
The Monitoring Pack for Microsoft
SQL Server 2014 Reporting Services automatically discovers instances of SSRS
2014.
Discovery
of SQL Server Reporting Services Deployment
The Monitoring Pack for Microsoft
SQL Server 2014 Reporting Services automatically discovers Deployments of SQL
Server 2014 Reporting Services. Deployment includes following components:
o One
or more instances of SQL Server 2014 Reporting Services.
o SSRS
Catalog SQL Server Databases
o
SSRS Temporary SQL Server Database.
Availability of components of
SQL Server Reporting Services
This monitoring pack introduces
following monitors a set of monitors which enable the monitoring of both SSRS
Deployments and SSRS Instances. Monitors verify the availability of these
components from following perspectives:
·
SSRS Deployment:
o SSRS
catalog database is accessible;
o SSRS
temporary database is accessible;
o There
are no broken references to shared data sources;
o Number
of failed report executions (expressed as percentage of total report
executions) is below the threshold;
o All
instances within deployment are discovered.
·
SSRS Instance:
o SSRS
catalog database is accessible;
o SSRS
temporary database is accessible;
o SSRS
windows service is started;
o SSRS
web service is accessible;
o SSRS
report manager is accessible;
o SSRS
Instance is not using too much CPU resources;
o SSRS
Instance is not using too much memory resources;
o There
is no memory configuration conflict between SSRS Instance and SQL Server
Database Engine (if both components are running on the same server);
o Other
processes allow enough memory resources for the SSRS Instance;
o Number
of failed report executions per minute is below the threshold for the given
SSRS Instance;
·
SSRS Deployment:
o Failed
report executions per minute
o Report
executions per minute
o Number
of reports
o Number
of shared data sources
o Number
of subscriptions
o On-demand
execution failures per minute
o On-demand
executions per minute
o Scheduled
execution failures per minute
o Scheduled
executions per minute
·
SSRS Instance:
o CPU
utilization (%)
o WorkingSetMaximum (GB)
o WorkingSetMinimum (GB
o Memory
consumed by other processes (%)
o Memory
consumed by SSRS (GB)
o Total
memory on the Server (GB)
o Total
memory consumed on the server (GB)
o Failed
report executions per minute
o Report
executions per minute
New
Features:
·
New dashboards (instance level and database level) for both SQL 2008 and
SQL 2012.
·
Integration with Microsoft SQL Server Presentation Management Pack, the
folder and views structure has been updated.
·
Support of localized performance counters (CPU and Disk metrics) has been
added.
·
Monitors have been updated to use consecutive samples instead of average
sample value.
·
Removed SQL Default Action Run AS from Write Actions.
·
None-Default port is now supported
·
New property - Server Role Type
·
Performance collection rules have been updated to use none-optimized
performance collection to improve the accuracy of daily and hourly-aggregated
data.
·
AllwaysOn Read-Intent error fixed, Read-Intent Monitoring is not supported.
·
Performance counter object name changed for a number of rules.
·
Discoveries have been disabled for Analysis Services and Reporting
Services.
· Icons updated for a number of classes.
· Icons updated for a number of classes.
·
DB discovery issue on Standard Edition
