четверг, 3 июля 2014 г.

5 SQL Server Management Packs 6.5.1.0 were released on 30 of June!

Detailed information & download links:

Features:

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;

Performance metrics:
·         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.




·         DB discovery issue on Standard Edition

Комментариев нет:

Отправить комментарий