Database Capacity Management Solutions

Capacity Manager for SQL Server

Database Trending and Forecasting Made Easy

How do you plan for the usage of storage, CPU, memory and I/O consumption of your data?

Quest Software makes SQL database forecasting easy with Capacity Manager for SQL Server. Get the maximum efficiency and performance from complex SQL Server environments while minimizing outages and downtime.

Capacity Manager for SQL Server provides a complete, detailed portrait of resource consumption and storage requirements with easily interpreted reports, charts and graphs. A consolidated view permits you to manage and control all databases and datafiles from a single interface.

Over time, the rate of growth of instances, databases, and objects, and the rate of utilization of CPU, memory and I/O can be plotted, enabling you to evaluate the most storage resource-intensive portions of an architecture and those objects which are growing most rapidly.

Over-allocated space can be reclaimed from databases. Databases in need of extra storage can be augmented, and server resources can be managed more effectively. Finally, table partitioning is fully supported, including rolling partitions and switching partitions in/out, making Capacity Manager an ideal solution to help manage your transition to SQL Server 2005.

Capacity Manager for SQL Server Includes:

• Track and Forecast Data Growth: Capacity Manager collects disk utilization stats that will help you identify past, current and future space requirements at the instance, database and object level.
• Performance Capacity Tracking and Forecasting: Use past CPU, I/O and memory data collection as the basis for identifying current usage and forecasting future usage.
• Consolidation: Use disk and performance data collections to build accurate consolidation projects using either an existing machine or a ‘virtual’ hardware profile as a target machine.
• Fragmentation Management: Identify and defrag indexes that exceed acceptable fragmentation levels.
• Partition Management: Maximize and simplify SQL Servers ability to partition tables.
• SharePoint Module: Track the growth of SharePoint databases. Gain visibility into site, sub-site and document growth and understand the demands that your SharePoint team is putting on your SQL Server environment.