Features and Benefits

Quest Performance Analysis for SQL Server

• Provides an “in-house SQL Server expert," yielding targeted, insightful advice rivaling that of an expensive SQL Server consultant
• Many performance problems are caused by changes to your database.  Performance Analysis automatically tracks changes and correlates the performance impacts.
• Offers a comprehensive, easy-to-understand view of your environment by presenting dozens of performance metrics in a concise, business-friendly report
• Creates an action plan based on your application requirements
• Analyzes any database in your environment and provides explicit tuning advice
• Offers customized advice for tuning your environment based on workload, configuration and applications
• Security exposure checks
• Provides historical reports, both online and in HTML, showing instance activity, memory usage, configuration, file IO, latching, reorganization need and more
• Continues the workflow from diagnosis to resolution with embedded integration to other Quest components, including SQL Tuning, Database Administration and Capacity Management
• Identifies and anticipates performance issues and eases time to resolution
• Increases DBA efficiency by automating reports Provides a central repository for retrieving all performance related statistics
• Captures performance data without impacting database performance
• Performs root cause analysis: Rapidly identify bottlenecks, anomalies, peak activities, and application performance trends
• Contains a visually-oriented GUI, zooming feature, and drilldown to allow DBAs to quickly focus on top resource consumers by various dimensions, such as SQL statements, users, programs, machines and many more
• Allows users to monitor current SQL Server database instance and session activity and performance consumption at a glance
• Offers full diagnostic support for database locking in both recent and historical collections.
• Captures all SQL statements and performance metrics non-intrusively at sub-second intervals, with no overhead to SQL Server
• Identifies the root of most performance problems by detecting offensive SQL statements
• Provides immediate troubleshooting in real-time, even when SQL Server is overloaded or not responding