Real-time Diagnostics and Resolution Tool
From the tools' user-defined interface, DBAs can identify bottlenecks using flows, graphs, and visual icons, allowing users to quickly identify congested areas in a database and take corrective action. In addition, the tool will alert DBAs with an audio or visual alarm if any SQL Server component is forming a bottleneck.
From an overview screen, users can view the most active user sessions and SQL statements, locks and deadlocks, disk I/O, and server activity to pinpoint and alleviate problem areas as they occur. If users need more detailed information, they can drill down from any of these views to receive in-depth charts of underlying statistics.
Features of this tool also include:
- The ability to monitor multiple SQL Server databases simultaneously.
- An online tuner that guides users through database repair.
- Customizable user interface with color options and window resizing.
- Integration with the manufacturer's Foglight tool that provides monitoring of systems, databases, and applications.
Quest Software Inc, 8001 Irvine Center Drive, Irvine, CA 92618. Tel: 949-754-8000. Fax: 949-754-8999.