24X7 SQL SERVER PERFORMANCE MONITORING,
ALERTING AND DIAGNOSTICS
SQL Diagnostic Manager is a powerful performance monitoring, alerting and diagnostics solution that proactively notifies administrators to health, performance or availability problems within their SQL Server environment via a central console, web-based dashboard or mobile device. It minimizes costly server downtime by providing agentless, real-time monitoring and customizable alerting for fast diagnosis and remediation
✔ Performance monitoring for physical and virtual environments
✔ Query plan monitoring to see auses of blocks and deadlocks
✔ Easy integration with microsoft SCOM
✔ Predictive alerting with setting to avoid false alerts
✔ Database growth forecasting to minimize server sprawl
✔ Web-based dashboard with at-a-glance views of top issues and allerts
PERFORMANCE MONITORING
Continuous Monitoring and Analysis of SQL Server and OS health and
performance metrics across hundreds of SQL Servers enterprise-wide,
including clustered configurations.
Physical and Virtual Database Monitoring to view the performance of
both physical and virtual server environments to get a complete view of
your SQL Server databases.
Tempdb Monitoring to quickly identify and resolve tempdb contention
and performance related issues with the tempdb monitoring and
corresponding diagnostic views.
Availability Group Monitoring to monitor the performance of Always-On
availability groups in SQL Server 2012.
Server and Query Wait Stat Monitoring to view overall waits on servers
and queries. Users can easily monitor the resources the SQL server and
the queries are waiting on and can also drill down to look at the wait they
are experiencing.
Custom Counters provide an unlimited amount of custom counters in the
monitoring process. These include any perfmon counters or SQL queries
that can be added to the list of existing, pre-defined counters.
Job Management and Monitoring to monitor and alert on job success,
failure, canceled or retry events. The Jobs view displays all jobs, their last
known status, complete job history and allows start/stop of jobs.
Monitor Replication and Mirrored Environments to easily monitor
performance problems with your mirrored or replication environments.
OS Monitoring using WMI or OLE automation to collect OS performance
collect OS performance metrics.
Powerful User Analysis
Analyze membership to powerful server roles and groups such as
administrators, system administrators, and security administrators so
you can ensure this level of access is warranted.
ALERTING
Adaptive and Automated Alerting offers over 100 predefined and
Configurable alert settings. They are based on industry best practices and
have advanced configuration settings allowing for greater flexibility.
Alert Threshold Recommendations capture the baselines of past
performance of a monitored instance to determine if any alert thresholds
are set in such a way that they may be excessively noisy or cause false
positives. If it is determined that a metric is constantly alerting, it will
provide recommendations for new thresholds.
Alert Smoothing and Snoozing to easily “snooze” any alert or group
of alerts for a specified number of minutes which prevents alerts from
recurring while a problem is being worked on.
Settings for Maintenance Mode disables data collection and alerting
during maintenance periods to avoid false positives. Maintenance Mode
can be on-demand, one-time or weekly scheduled maintenance periods.
Per-database and Per-disk alerts defined. For instance, users can be
alerted when disk E is 90% full, plus get alerts on items like OS Disk Full,
OS Database Full, and more.
DIAGNOSTICS AND ANALYTICS
Pinpoint Locks, Blocks & Deadlocks to identify real-time and historical
session locks, blocks and deadlocks and look at the complete blocking
chain for easy identification and resolution.
History Browser to diagnose a problem that happened minutes, days
or weeks ago. Simply select a past point-in-time and the console quickly
changes all screens to display the SQL Server and the OS performance
metrics at that point in time.
Server Activity Timeline displays server performance events as a
timeline calendar instead of just a list. Events are color-coded for easy
differentiation, and sliding scale provides the ability to zoom in to a
specific time-frame to correlate events happening at the same time for
quicker remediation.
Performance Baselines compare a server’s baseline values and baseline
Over time ranges, as well as across different servers. Generated reports
show the baseline in the given performance metric’s graph or chart,
allowing for better capacity planning for new servers.
Fragmentation Statistics are displayed to help you identify indexes that
may need attention.
PowerShell Snap-In to quickly and easily script a number of management tasks.
Go to IDERA SQL Diagnostic Manager | Datasheet | The Word on the Streets
Request for pricing quotation email us at idera@ensbn.com