• Success
    Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
    Success
    Success Accelerators
    Accelerate your Purchase to Value engaging with Informatica Architects for Customer Success
    My Engagements
    All your Engagements at one place
  • Communities
    A collaborative platform to connect and grow with like-minded Informaticans across the globe
    Communities
    Product Communities
    Connect and collaborate with Informatica experts and champions
    Discussions
    Have a question? Start a Discussion and get immediate answers you are looking for
    User Groups
    Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
    Get Started
    Community Guidelines
  • Knowledge Center
    Troubleshooting documents, product guides, how to videos, best practices, and more
    Knowledge Center
    Knowledge Base
    One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
    Support TV
    Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
    Documentation
    Information library of the latest product documents
    Velocity (Best Practices)
    Best practices and use cases from the Implementation team
  • Learn
    Rich resources to help you leverage full capabilities of our products
    Learn
    Trainings
    Role-based training programs for the best ROI
    Certifications
    Get certified on Informatica products. Free, Foundation, or Professional
    Product Learning Paths
    Free and unlimited modules based on your expertise level and journey
    Experience Lounge
    Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
  • Resources
    Library of content to help you leverage the best of Informatica products
    Resources
    Tech Tuesdays Webinars
    Most popular webinars on product architecture, best practices, and more
    Product Availability Matrix
    Product Availability Matrix statements of Informatica products
    SupportFlash
    Monthly support newsletter
    Support Documents
    Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
    Product Lifecycle
    End of Life statements of Informatica products
    Ideas
    Events
    Change Request Tracking
    Marketplace
Login | Sign up

Cloud Data Warehouse & Data Lake

Last Updated Date Mar 14, 2022 |
Stages Cloud Data Warehouse & Data Lake Sample Accelerator

Overview

The purpose of capacity planning is to determine the amount of disk space needed for a production data warehouse (DW). Informatica recommends taking the size of known data feeds expected in the near future and adding a 20% buffer to accommodate secondary and join indexes. Database parameters and vendor specific architecture best practices have not been considered for this article.

Database capacity planning is an ongoing activity that should be flexible to changing data-centric business scenarios. Effective database capacity planning is directly proportional to the availability and scalability of any OLAP application consuming data from the DW. Insufficient capacity planning can increase unplanned DW outages, adversely impacting the decision support systems and decision-making capabilities of the organization.

Current Resource Utilization

The following matrix depicts a sample current state resource utilization report from a production Teradata database. The grid should be updated to represent the specific database technology that hosts the data warehouse.

Database/Instance Name

Resource Name

Peak Utilization/Month

Threshold

Threshold breach in a month (No of days)

PROD_DB

AMP CPU

 <Peak AMP CPU utilization>

 < Threshold assigned for AMP CPU>

 10

PROD_DB

PERM SPACE

 <Peak PERM space Usage in TB>

 < Threshold assigned for PERM Space>

 16

PROD_DB

SPOOL SPACE

 <Peak SPOOL Space usage in TB>

 < Threshold assigned for SPOOL Space>

 16

 

 

Approach

An historic approach for capacity planning is used. The planning relies heavily on past system performance metrics to predict forthcoming workloads. The data growth for the next 60 months has been calculated based on historical consumption.

The flowchart bellows illustrates a sequential flow of preceding events culminating in the planning phase.

Capacity Calculation

Capacity Sizing Model

The attached sizing model provides a template for capturing the estimated data growth over a five-year period for Teradata, Oracle, and DB2. The template can be altered to include other database technologies.

{fa-file-excel-o fa-2x color=rgb(0,169,187)}  Database Sizing Model

Refer to specific database vendor documentation for estimating bytes assigned to data types.

Capacity Sizing Summary

The following matrix depicts space requirements over a period of 5 years. The summary is based on the capacity sizing model.

 

Current Year

12 Months

24 Months

36 Months

48 Months

60 Months

Total Disk Space (In GB)

22.93

24.93

25.83

27.73

29.63

31.43

Cumulative Total

22.93

47.86

73.69

101.42

131.05

162.48

 
Previous
Next

Table of Contents

Success

Link Copied to Clipboard