DBArtisan - Capacity Analyst

Advanced Planning Analysis

Embarcadero Capacity Analyst collects historical database metadata and performance metrics at user-defined intervals. It provides historical trend analysis along with smart forecasting abilities that allow you to plan for the future needs of your critical databases. Running inside Embarcadero DBArtisan, Capacity Analyst presents a complete solution for day-to-day administration and historical analysis. It allows you to easily build complex trend analyses and forecasts through its intuitive interface so you know exactly where your databases are today and where they are headed in the future.

Track Database Usage

Embarcadero Capacity Analyst helps you get a handle on database usage and performance trends by recording key database metadata and performance statistics so you can understand current trends as well as plan for the future. Wizard-driven facilities make creating statistical collections a breeze and built-in scheduling abilities allow you to run collections in off hours as often you desire.

  • Create collections of database metadata and performance metrics that can be analyzed later with Embarcadero Capacity Analyst's Collection Wizard.
  • Collect all pertinent information for your database's storage structures including total, used, and free space, along with other key storage metrics.
  • Track key database object metrics including total and used object space, fragmentation information, and other key object-related statistics.
  • Gather important wait event occurrences and times, which allow you to tell exactly what waits the database experienced, the duration of each wait, and when each occurred.
  • Trace and analyze critical performance metrics like database I/O, session load, sort activity, and more.
  • Schedule collections to run on an ongoing, automatic basis or collect them in an ad-hoc style.

Analyze Trends

Embarcadero Capacity Analyst contains easy-to-use visual analysis facilities that help you instantly spot trends in database usage and activity.

  • Review summarized metric information such as high, low, and average readings for the specified period.
  • Add or remove metrics through the intuitive metric editor. Specify analysis period date ranges down to the minute and second level.
  • Roll up key data by hours, days, months, or years using the granular rollup capabilities.

Forecast the Future

Using historical Analysis, Embarcadero Capacity Analyst helps predict how much storage a database will require in six months and how it will impact performance.

  • Create forecasts using the Visual Analysis facility or HTML reports.
  • Specify a forecast in the Visual Analysis facility by simply selecting the option to view a forecast and typing in a date in the future.
  • Step through the process of creating informative database forecast reports using the wizard-driven report utility.
  • Forecast the growth of storage structures, predict fragmentation and growth trends for objects, and much more through the different storage and object-level reports.
  • Upload HTML forecast reports to internal web sites for collaboration with management or operations personnel.

Intelligent and Integrated Feature Set

Embarcadero Capacity Analyst is fully integrated into Embarcadero DBArtisan so you can perform all your storage management duties, as well as other cross-platform database work, in one place.

  • Track and analyze all the key metrics for multiple databases all from within one console while continuing to perform other tasks within DBArtisan.
  • Pinpoint upcoming space outages and then implement corrective actions using DBArtisan.
  • Proactively forecast upcoming database needs and then implement the necessary database changes with DBArtisan.

DBMS Support

  • IBM DB2 for LUW 8.x and 9x
  • Microsoft SQL Server 2000, 2005 and 2008
  • Oracle 8i, 9i, 10g and 11g
  • Sybase ASE 12.5 - 15.x

System Requirements

  • Windows® 2000, Windows 2003 (All editions), Windows 2003 R2 (All editions) and Windows XP (SP1 and SP2) and Windows Vista (Ultimate and Business) - 32-bit architecture only
  • 512 MB memory
  • 512 MB disk space
  • DBMS Client connectivity utilities
  • Internet Explorer 5.5 or later
  • Power User or Administrator privilege required to run software