Features and Benefits

Quest Central® for SQL Server v6.5

Capacity Manager for SQL Server

• Provides trending and forecasting based on current rate of growth at all levels — including the instance, database, and object.
• Helps identify the right size for Transaction Logs and the TempDB.
• Assists DBAs in reclaiming space that is not going to be used for the foreseeable future and provides the ability to augment database storage where needed.
• Offers a single consolidated interface for managing all filegroups and datafiles.
• Reporting capabilities enable the creation of many charts, graphs, and if desired, the raw data related to an environment, all in a format that can be easily printed or e-mailed.
• Identifies and corrects fragmented objects, either in real-time or at a scheduled time.
• Allows movement of objects into a different filegroup.
• Provides the ability to create, alter, and delete partitions in a table through an easy to use interface, assisting in the management of partitioned tables in SQL Server 2005.

Spotlight on SQL Server

• Enables you to see everything important in one place – view the most active SQL Server sessions, SQL statements, replication information, blocks, deadlocks, waits and disk activity to pinpoint and alleviate problems as they occur before they seriously impact end users
• Improves responsiveness to components forming bottlenecks with real-time alerts
• Increases management efficiency with views of database space and the internal structure of SQL Server log files
• Provides a comprehensive, context-sensitive help text covering thousands of topics by integrating with KnowledgeXpert™ for SQL Server

Performance Analysis

• Captures performance data without impacting database performance
• Identifies and anticipates performance issues, reducing time to resolution
• Tracks changes and automatically correlates changes to performance
• Provides a central repository for retrieving all performance related statistics
• Offers intelligent and customizable performance and activity highlights for alarming and drill down to related problems
• Establishes performance baselines and trends for your most important programs and SQL statements
• Predicts when system performance will degrade and impact end-user response time

SQL Tuning

• Automatically rewrites SQL into every possible permutation to guarantee the most efficient SQL statement
• Minimizes user interaction - lets the PC perform the SQL optimization work rather than the user
• Integrates with Benchmark Factory® to test optimized SQL for scalability , ensuring SQL in a test environment meets production requirements