SQL Diagnostic Manager

24/7 SQL overvåkning

boxshot sqldiagnosticmanager

KJØP VIDEO

SQL Diagnostic Manager er en systemløsning for databaser (DBMS) som er eksklusivt laget for å diagnostisere og optimalisere ytelsen på Microsoft SQL Server. Med SQL Diagnostic Manager kan du oppdage eksisterende og potensielle problemer, analysere status på din SQL Server Enterprise og generere rapporter.

-Ytelsesovervåkning for fysiske og virtuelle SQL servere
-Dyptgående analyser for å identifisere lange ventetider og ressursbruk
-Søk i historikken for å finne og feilsøke tidligere problemer
-Adaptiv & automatisert varslingssystem med over 100 forhåndsdefinerte og konfigurerbare varslinger
-Kapasitetsplanlegging for å forutse database trender og minimere server sprawl

 

Generelt

screenshot sqldiagnosticmanager

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.

Integrated SQL Doctor Expert Recommendations
Expert recommendations from IDERA 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. Read more...

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.

Detaljer

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.

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.

Learn more

 

 

Tekniske Spesifikasjoner

System Requirements

General
•    Microsoft Windows: Server 2008 SP1, 7, Server 2008 R2, Server 2012, 8, Server 2012 R2, 10, Server 2016, Server 2019;
•    Client browser: Microsoft Internet Explorer 7.0+

Console
•    Microsoft .NET Framework: 4.0+ (4.6.2 recommended)
•    Monitor resolution: 1280 x 1024 with small text

Services
•    Linux (for monitoring SQL Server 2017): Red Hat Enterprise 7.3+, SUSE Enterprise v12 SP2 +, Ubuntu 16.04LTS and 16.10 +
•    Microsoft .NET Framework: 4.0 SP2 + (4.6.2 recommended)
•    Microsoft Data Access Components: 2.8

Repository
•    Microsoft SQL Server: 2005, 2008+, 2008 R2, 2012, 2014, 2016, 2017, 2019 on Windows and Linux; Standard and Enterprise Edition

Monitored SQL Server Instances
•    Microsoft SQL Server: 2000 SP4+, 2005 SP1+, 2008 SP1+, 2008 R2, 2012, 2014, 2016, 2017, 2019 on Windows and Linux; Standard and Enterprise Edition
•    Microsoft SQL Server Express: 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019
•    Microsoft Azure SQL Database
•    AWS RDS SQL Server

SQL Diagnostic Manager does not install any components, DLLs, scripts, stored procedures, and tables on the monitored SQL Server instances.

Mobile Requirements
•    Service and web server: Microsoft Windows: Server 2003 SP2, Vista SP1+, Server 2008, 7, Server 2008 R2, Server 2012, 8, 8.1, Server 2012 R2, 10, Server 2016
•    Microsoft .NET Framework: 4.0+ (4.6.2 recommended)
•    Repository: Microsoft SQL Server: 2005 SP1+, 2008, 2008 R2, 2012 , 2014, 2016, 2017, 2019 on Windows and Linux; Standard and Enterprise Edition
•    Web server: Microsoft Internet Information Services: 7.2+

Mobile and Desktop Devices
•    Mobile device: Google Android v2.1+, Apple iOS v3.2+, BlackBerry RIM v6.0+, Microsoft Windows Phone 7+
•    Desktop web browsers: Microsoft Internet Explorer 9.x+, Google Chrome, Mozilla Firefox, Microsoft Edge

Cloud
SQL Diagnostic Manager runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports Microsoft SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2). It supports cloud databases (that is, Microsoft Azure SQL Database and AWS RDS SQL Server).

 

Sammenlikning

Compare the Best SQL Monitoring Tools

Idera relentlessly delivers the industry's most complete solution for 24x7 SQL server performance monitoring, alerting, and diagnostics and tirelessly supports the SQL community with 100% free tools and expert advice.

Compare, side by side, the features and functionalities of the best SQL server monitoring tools the market has to offer. Download a free trial today!

idera sqldiagnosticmanager competitivematris


Lisensiering

SQL Diagnostic Manager is offered per instance. A license is needed for each (per) SQL Server instance that is being monitored.  First year of maintenance is included in price.

Alfasoft offer a price guarantee for the IDERA products. If you find an IDERA product at a lower price before your purchase somewhere else we will match it.