Contact us:

 

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