1. Installation and Configuration Guide
  2. Preparing Your Environment
  3. Preparing a Database
  4. Using a Microsoft SQL Server Database
  5. Microsoft SQL Server Sizing Guidelines

Microsoft SQL Server Sizing Guidelines

The following table describes the Microsoft SQL Server sizing guidelines.

Product Sizing Guideline
Oracle Hyperion Shared Services Start with 100 MB, and add more as the number of migrations with Lifecycle Management and the number of audit records increases.
Oracle Hyperion Enterprise Performance Management Workspace The space needed depends on the aggregate size of the objects that you plan to store in the repository. Oracle recommends starting with at least 250 MB, which provides space to expand the EPM Workspace repository without having to increase the data file or tablespace. A shared pool size of 60 MB is used during configuration with EPM System Configurator.
Oracle Essbase Administration Services

The space needed depends on the metadata created; Oracle recommends starting with at least 32 MB.
Oracle Hyperion Planning and Oracle Hyperion Calculation Manager

  • 100 MB for applications with 5,000 or fewer total members

  • 200 MB for applications with 15,000 or fewer total members

    Note: You can adjust the size of the system table database to match the size of the application.

Oracle Hyperion Financial Management and Calculation Manager

  • 100 MB for applications with 5,000 or fewer total members

  • 200 MB for applications with 15,000 or fewer total members

    Note: You can adjust the size of the system table database to match the size of the application.

Oracle Hyperion Financial Close Management

See the Oracle Hyperion Financial Close Management Performance Tuning Guide, which can be found on Oracle Support by searching for document ID 1575381.1

Oracle Hyperion Tax Governance

See the Oracle Hyperion Financial Close Management Performance Tuning Guide, which can be found on Oracle Support by searching for document ID 1575381.1

Oracle Hyperion Tax Provision

  • 100 MB for applications with 5,000 or fewer total members

  • 200 MB for applications with 15,000 or fewer total members

    Note: You can adjust the size of the system table database to match the size of the application.

Oracle Hyperion Profitability and Cost Management Oracle recommends starting with at least 250 MB.
Oracle Data Relationship Management

  • Set the initial file size to 1 GB

  • Turn on Auto Growth and set to 10%