Idera SQL Diagnostic Manager — Real-time Performance Monitoring and Diagnostics for SQL Server | 20,9 Mb
Idera's SQL diagnostic manager (SQLdm) provides increased availability and faster time-to-recovery for database problems. With real-time status displays that organize SQL Server information into easy-to-understand, logical groupings, SQLdm eases problem diagnosis and correction. These displays help you quickly access crucial database information and, if necessary, take preemptive action. The extensive wealth of database health knowledge in SQLdm helps both experienced and novice DBAs increase productivity.
|“||Why SQL diagnostic manager? |
In many organizations today, SQL Server supports business-critical applications and DBAs are required to ensure performance and availability, supporting growing SQL deployments often with constrained resources.
To ensure optimum performance, administrators need reliable SQL Server information. SQLdm enables a quick and accurate response when users complain or automated monitoring tools indicate trouble. Whether you need to see real-time events or want data for long-term planning, this product helps you diagnose problems, identify unusual behavior and obtain the information to resolve issues.
Increases SQL Server availability — Enables DBAs and other administrators to quickly investigate, diagnose and correct performance and availability problems. On-screen recovery tasks make it easy to solve a problem once diagnosed. Convenient tasks include starting or stopping a SQL Agent job, stopping a blocking process, terminating a user connection, rebuilding indexes on a table and updating statistics.
Improves the productivity of both skilled and novice DBAs — Delivers organized data views with built-in data collection. These views eliminate the need to look up and understand how to apply complex system commands, while built-in features detail exactly what the interface displays.
Provides a comprehensive view of current performance — Collects and displays real-time activity and performance information for processes, caches, alerts, memory, transactions, logs, locks, replication, reorganization status and trace data. Extensive details are available from easily accessible, drill-down detailed charts.
Gathers data across multiple servers simultaneously — Collects and sorts data, enabling you to view information for one server or for the entire environment. You can easily identify the worstperforming stored procedures across all your servers or learn whether a SQL Agent maintenance job has failed on one server or all simultaneously.
Supplies continuous unattended monitoring — Allows you to log off of your computer, while SQLdm continues monitoring your mission-critical SQL applications. Its service-driven collection and alerting mechanism keeps you informed even while you are away.
Offers easy installation and use — Installs quickly and supports a mixed environment of Windows integrated security and SQL Server native security. An interactive tour walks new users through the product, eliminating specialized training.
Part of Idera’s SQL Management Suite — Idera’s SQL Management Suite (SQLsuite) is the industry’s most comprehensive toolset dedicated to managing SQL Server production operations. Built on leading technologies, the SQLsuite increases availability and improves productivity. Offering real-time performance monitoring, in-depth diagnostics, Web-based administration, configuration management and automated job management, this complete solution addresses critical problems SQL Server administrators face.
— Works with up to 200 SQL Server database machines
— Offers simple, no-agent installation with continuous, secure data collection from a background service
— Provides more than 15 screens, organizing current status and performance information into easy-to-use diagnostic data
— Identifies the worst-performing stored procedures, SQL statements and SQL batches during a specified period
— Integrates with Quest Software’s Quest Central for SQL Server – SQL Tuning (QST) for quick optimization of poorly performing SQL statements
— Provides a flexible and customizable grid view that displays all monitoring data for both the server and database that can be customized and saved, shared across multiple SQLdm instances, and exported into CSV formatted files for easy reporting and analysis
— Provides server categorization capabilities used to selectively view specific servers via grid views – server group, application group, department, location
— Displays current process list, including which process is using the most resources. SQLdm also provides drill-down to a live trace of any process and permits either the process or the user connection to the server to be terminated
— Monitors selected processes to ensure that no single one consumes more than a pre-defined percentage of hardware resources during a designated period on the SQL Server instances being monitored
— Enhanced management of alerts and settings with the ability to apply a single alert or setting entry to any number of monitored servers – eliminates tedious setup time, makes applying changes easier and reduces the chance of error
— Identifies the process at the head of the blocking chain for easy resolution
— Supplies extensive views of current SQL Server status and performance, including SQL Agent jobs, SQL error log, full-text catalogs, memory utilization, open transactions, performance, problem locks, procedure cache, processes, reorganization status and replication details
— Provides recovery tasks including stopping processes, disconnecting user connections, starting/stopping SQL Agent jobs, rebuilding indexes and updating statistics
— Delivers in-depth analysis of activities for a specific process – including cursor sizes, options set and open transactions – plus a breakdown of commands issued and stored procedures entered
— Analyzes performance trends using real-time and historical data to identify abnormal operating states
— Gives you extensive functional support for locks, performance-tuning, memory, SQL Agent and performance history
— Allows you to select one or multiple tables for on-demand reorganization
— Displays objects dependent on tables – and vice-versa – to help you avoid errors in object modification
— Permits two or more people to review data from either a central system or any individual installation
Intel Pentium 900-MHz processor or equivalent
36MB drive space plus 34MB for each monitored server
Internet Explorer 5.5 or later
Windows 2000, Windows XP or Windows Server 2003
Monitor capable of displaying 16-bit color or greater and a resolution of 800x600
SQL Server v7.0 or SQL Server 2000, including 64-bit SQL Server on the operating systems they support.
See more on developers site.