diagn

SQL DIAGNOSTIC MANAGER

  • Performance monitoring for physical and virtual environments
  • Query plan monitoring to see the causes of blocks and deadlocks
  • Integrated SQL Doctor expert recommendations
  • Easy integration with Microsoft SCOM
  • Predictive alerting with settings to avoid false alerts
  • Web-based dashboard with at-a-glance views of top issues and alerts

Physical and Virtual Performance 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.
Query Performance Monitoring
Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O. Thresholds can be configured on each individual server allowing for greater flexibility, and the interface makes it very easy to see the most costly queries by looking at individual query executions or query signatures.
*New* Integrated SQL Doctor Expert Recommendations
Expert recommendations from DATAAPPS SQL Doctor are now integrated into SQL Diagnostic Manager. Enhance performance and speed up problem resolutions with built-in tuning advice and best practices developed by SQL Server MVPs. These updated recommendations are integrated into analysis workflows and provide specific guidance to address problem issues including automatic corrective scripts and links to related online content to supercharge your SQL Server performance.
Query Plan Diagnostics
Dig deep into problematic queries with new query plan diagnostic capabilities. View high level query performance information across applications, databases and users with enhanced drill down capabilities into individual queries to view detailed SQL text, execution plan XML, and graphical views of execution plans.
Predictive Alerting
Avoid false alarms with adaptive alerting functionality and set alert thresholds based on built-in historical statistical analysis of your server performance data.
The system has embedded heuristic analysis of event trends and behaviors and presents a percentage of likelihood that various events could happen later in the day based on past behavior trends. This helps DBAs to be better prepared to diagnose, drill down, and resolve an issue quickly and effectively.

Capacity Planning
Understand trends and view forecasts of your SQL Server environment to better plan for future needs and get a handle on SQL Server sprawl with database growth reporting.
Mobile Access
Access SQL Diagnostic Manager from anywhere. Use any mobile device, such as iPhone, Android, Blackberry or Tablet to view real-time and historical SQL Server performance data. Plus, view or kill sessions, start/stop jobs and run queries to resolve or diagnose issues remotely while on-the-go.
View a demo of SQL Diagnostic Manager mobile.
Web Dashboard
Log in from anywhere and quickly check the status of monitored server instances to identify and diagnose issues. View the current status of monitored instances, drill down into single instance details, view the top occurrences of performance issues, and see a rollup of all active alerts. Customize your display with eighteen new widgets, enhanced heat map view, and query wait state visualizations. Create any number of individually configured dashboards to address the needs of the entire organization.
Integration with SCOM
The SQL Diagnostic Manager Management Pack provides easy integration with Microsoft’s System Center Operations Manager (SCOM). The Management Pack propagates the current status, health and events of all monitored instances up to Operations Manager, allowing the DBA and IT Operations staff to share data at a higher level across their enterprise. The management pack is easy to install and does not incur any additional monitoring overhead. Read the FAQ and watch a quick 5 minute video to learn more.

Performance Monitoring

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.
Tempdb Monitoring
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

Custom Counters
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.
Wait Stat Monitoring
View overall waits on servers and queries and easily monitor the resources the SQL server and the queries are waiting on. Drill down to look at the detailed information on the wait they are experiencing, including which database, application, user, session, etc. is having the highest waits.
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.

Alerting

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.

Diagnostics & Analytics

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.
History Browser
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.
Fragmentation Statistics
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.
PowerShell Snap-in
Quickly and easily script many of the SQL Diagnostic Manager management tasks using the PowerShell Snap-in.

Enterprise Management

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.

History Browser
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.
Fragmentation Statistics
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.
PowerShell Snap-in
Quickly and easily script many of the SQL Diagnostic Manager management tasks using the PowerShell Snap-in.

....................

dataapps