Capacity Manager for SQL Server

Database Trending & Forecasting Made Easy

Toad for SQL Server bridges the functionality gaps that exist in both Microsoft’s SQL Server Management Studio and Visual Studio and it does it all within a single toolset. Do you need to compare and synchronize schema and table data? Execute SQL scripts against multiple SQL Server instances? Rollback transactions from SQL Server transaction logs? Manage SQL Server agent jobs? Recall SQL scripts run at any point in time? Toad for SQL Server performs all of these actions and more in a single toolset, meeting the needs of both SQL Server DBA’s or developers.

Quest Password Manager

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.

Contact Us for more information

logos

LeadThem Consulting
20418 SE Hwy 212
Damascus, OR 97089