Continuous Monitoring and Analysis
Continuously monitor with real-time 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
Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server environments to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.
Availability Group Monitoring
Manage the topology of high availability (HA) groups. SQL Diagnostic Manager monitors the performance of AlwaysOn Availability Groups that are set up and will send alerts as needed to ensure SQL Server is running on the designated node in the event of failover to a secondary replica. It can also run on an Availability Group as well.
Quickly identify and resolve tempdb contention and performance related issues with the tempdb monitoring and corresponding diagnostic views. Monitor and display Tempdb space and performance related information including:
- Tempdb file space monitoring
- Tempdb version store monitoring
- Monitoring of session space usage of tempdb
- Monitoring of waits related to tempdb
Add an unlimited amount of custom counters in the monitoring process. These include any perfmon counters or any SQL queries (which can enable advanced application specific monitoring) that can be added to the list of already existing industry specified counters that SQL Diagnostic Manager will monitor. This information is also stored in the repository so a custom report can be created and stored to capture this data.
Job Management & Monitoring
Monitor and alert on job success, failure, cancelled or retry events. The Jobs view displays all jobs, their last known status, complete job history and allows users to start/stop jobs.
Monitor Replication & Mirrored Environments
Easily monitor performance problems with your mirrored or replication environments. The system also provides alerts and real-time diagnostic views to help with troubleshooting in these environments.
Monitor OS Metrics
Collect OS performance metrics using WMI or OLE automation.
Adaptive and Automated Alerting
Choose from over 100 pre-defined and configurable alert settings based on industry best practices with advanced configuration settings allowing for greater flexibility. Adding or modifying metrics to multiple servers is also simplified with the default alert configuration and the 'copy to' operation which allows for multi-server configuration. Advanced notifications allow alerts to be sent to different groups of people based on metric, time-of-day, instance, and more.
Alert Thresholds 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 positive. If it is determined that a metric is constantly alerting, it will provide flags to indicate that changes may be needed and will provide recommendations for the new thresholds.
Alert Smoothing & Snoozing
Easily "snooze" any alert or group of alerts for a specified number of minutes which prevents alerts from recurring while the problem is being worked on. For problem metrics which occasionally spike for very short durations, users can easily specify the length of time that an issue must be occurring before the first alert will be sent. This cuts back on noise and allows the database administrators to focus on issues which are representing a continuing problem worth further investigation. The changes to the settings can be done at an individual server level or in bulk for a group of servers.
Per-database & Per-disk Alerts
Users can define per-database and per-disk alerts differently. For instance, users can be alerted when disk E: is 90% full or disk F: is 80% full. Users can also now get alerts on such items as OS Disk Full, OS Database Full, and OS Log Full shown for specific sizes in GBs or MBs as well as a percentage of the total size of the database. Alerting can also be done for filegroup space use.
Error & Agent Logs
View and receive alerts on specific conditions within the SQL Server Error Log.
Settings for Maintenance Mode
Disable data collection and alerting during maintenance periods to avoid false positives. Maintenance Mode can be on-demand, one-time or weekly scheduled maintenance periods, and can be enabled via PowerShell to allow integration with outside job scheduling. This mode can also be enabled in bulk for all servers in one shot.
Pinpoint Locks, Blocks & Deadlocks
Identify real-time and historical session locks, blocks and deadlocks and look at the complete blocking chain for easy identification and resolution. Session traces can also be run for additional diagnostics or sessions can be killed.
Blocking data includes the ability to chart blocking events, investigate lead-blockers, view the last-command run by the session, etc. Deadlocking monitoring allows the users to drill-down to view the deadlock victim and the code responsible for the deadlock.
View historical information on sessions, locks, blocks, and performance counters. Easily diagnosis problems that happened minutes, days or weeks ago by simply selecting a past point-in-time. The console quickly changes all screens to display the SQL Server and the OS performance metrics at that point in time.
Configure Multiple Performance Baselines
Define and schedule any number of baseline periods to differentiate various situations. View server baseline performance and compare a server's baseline values and compare a server's baseline over time ranges as well as across different servers. Configure baseline alerts that automatically calibrate to changes. Generate reports that show the baseline in the given performance metric's graph or chart, allowing for better capacity planning for new servers.
Server Activity Timeline
Visualize server performance events as a timeline calendar instead of only as a list of events. Events are color-coded for easy differentiation, and a sliding scale provides the ability to zoom in to a specific timeframe. This helps correlate events happening at the same time in an easy to read format for quicker trend analysis and remediation.
Statistics on fragmentation are displayed to help you identify indexes that may need attention and remedy one of the most common causes of performance degradation in SQL Server.
Quickly and easily script many of the SQL Diagnostic Manager management tasks using the PowerShell Snap-in.
Continuous Wait State and Transaction Monitoring
Monitor wait state and capture transactions of applications. Get a real-time view of the entire database with continuous sampling and high granularity as fast as 1 second.
Quick Drill-down for Actionable Advice
Easily drill-down to quickly isolate problems. View details of the captured transactions – such as top CPU activity, waits, databases, and statements versus top logins, machines, and applications – to pinpoint problems. Display and tune execution plans with expert recommendations, illuminate demanding transactions, and resolve locks and latches.
Historical Query Plan Trends
SQL Workload Analysis delivers valuable real-time and historical data to help tune queries. Investigate historical query plan trends in SQL Server 2005 and newer systems.
Integration with SQL Diagnostic Manager
SQL Workload Analysis integrates with SQL Diagnostic Manager to provide wait state and transaction monitoring. Further isolate the transaction causes of SQL Diagnostic Manager alerts for quick resolution.
Simple Web-based Dashboard
SQL Workload Analysis provides a single web-based interface that can be accessed via a browser from any machine that can access the framework machine. The dashboard displays a high-level overview of statistical analysis and SQL activity trends, and top database activity. Quickly isolate slow SQL statements and analyze execution plans in a sorted, easy to use table.
Customizable & Scalable Desktop Console
Maintain 'single pane of glass' monitoring via an intuitive, easy to use Windows-based console. Some of the key areas highlighted in the console include:
- Server Dashboard displays eight key areas. Color-coding highlights the area triggering alerts to your specific thresholds.
- Overview, Session, Queries, Wait Stats, Disk Counters, Databases, Services, Logs.
- Federated overview views allow you to monitor multiple deployments of SQL Diagnostic Manager from a single screen.
- Newsfeed Collaboration
Hundreds of servers can be monitored from this single console; multiple consoles can support thousands of databases providing an unprecedented level of visibility and control of your entire SQL Server environment.
Easy to Deploy Web-based Dashboard
Easily deploy SQL Diagnostic Manager via a web-based dashboard. View at-a-glance summaries of monitored servers, top problem occurrences, and active alerts so they can see what is going on quickly. It uses customizable widgets, filters, and groupings to organize information, and thumbnail and heat map views to identify problem areas for additional drill down and diagnosis. Users gain added flexibility in how they deploy SQL Diagnostic Manager enabling them to easily extend use to more SQL Server support staff over the web.
Share Counters, Reports, and Alerts
Users can export and import configuration files to share custom counters, reports, and alert template with other users.
Central Data Repository
Store all historical performance data in a central repository enabling analysis of long-term trends, supporting capacity planning and allowing for a variety of strategic analyses.
Flexible customization of server access and security permissions allow DBAs to have full access to one or more servers while other users such as Help Desk Operators are provided read-only access.
Agentless & Low Impact
SQL Diagnostic Manager is agentless and does not install additional services, databases, tables, extended stored procedures or anything else on the production systems. This simple architecture greatly reduces server footprint, simplifies the installation and upgrade process and eliminates risk agents on the performance of the monitored SQL servers.
Audit Transaction Logs
Audit a configuration change (e.g. kill a session) that shows up in the change log as an event. Administrators can keep track of what these users are doing and the changes are captured in a new report on configuration changes to provide an audit trail if needed.
Powerful & Comprehensive Reporting
View comprehensive reporting and trend analysis highlighting key performance trends via the easy to use reporting interface. The reports and charts cover areas such as:
- CPU to I/O Activity
- Physical Disk Activity
- Worst Performing by Application or User
- Logins (including unsuccessful logins)
- Procedure Cache Hit ratio
The system also provides a series of forecasting reports that allow users to forecast database, drive and table growth based on past performance.
In addition to the over 25 reports that are provided out of the box, users have the ability to create/store a custom report based on any collected metric to identify recurring problems and prevent future occurrences. All reports can also be deployed to SQL Server Reporting Services and emails scheduled easily through the management console.
Custom dashboards through which users can add columns/rows, select different metrics from the panel gallery, and share the dashboard among users to see the performance metrics most relevant for that user for any given database.
Users can also specify different default dashboard per instances. For instance, SQL Servers that are virtualized can be defined to have a dashboard that displays VM and Host data in the dashboard.
Follow critical issues and share updates on SQL Server problems with other technical staff using the Idera Newsfeed social-networking paradigm.
Add custom environment-specific details as a reference point to reduce problem resolution time, increase availability, and increase internal awareness with the knowledge sharing tool provided in the UI.
Drill down to the precise point-in-time an error occurred to view historical SQL Server and OS metrics and better understand the multiple factors which could have contributed to an error.