Workload Assumptions and Design Capacities

The current workload is has the following characteristics:

Storage

Current state

• 6.0 TB of base uncompressed total data volume (about 2TB/year)
• 3.0 TB of index space (1TB.Year)
• 4.0 TB of Active base uncompressed data (about 66%)

Design Capacity

• 15 TB of base uncompressed data for 5 year history @ 3.0TB/Year based on 2000 stores
• 5.0 TB Added for Transaction Detail and other new functionality 5.0 TB
• 9.0 TB of index space
• 10.0 TB of Active base uncompressed data including new MQTs.
• After compression - active data 5.0 TB, raw data 10.0 TB - Index 9.0 TB
• Design capacity: Total 48 TB (Data nodes)

Usage Levels

Current state

• 200 on-line users
• 15 concurrent streams
• 12-15K queries per hour

Design Capacity

• 200 on-line users
• 20-25 concurrent streams
• 25-30K queries per hour

Workload Mix and concurrent average response

Current state

• 88.42% Trivial subsecond queries (subsecond)
• 10.08% Simple queries(15 sec)
• 1.32% Medium Queries (150 sec)
• 0.18% Large Queries (15 minutes)

Design Capacity

• 80% Trivial subsecond queries (subsecond)
• 15% Simple queries(5 sec)
• 4% Medium Queries (20 sec)
• 1% Large Queries (2 minutes)