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.
|
