Spreadsheet: 0fd92aba-2efa-4cb8-95d7-32ce6ce25dd3
Sheet: Cache Cluster 1

 | This spreadsheet provides a tool for estimating the Azure Cache Offering required by an Azure application. Please note that the recommendations are based on
 | estimates, so the actual requirements could be different. Please test and monitor your Azure applications to verify that the offering you select is appropriate.
 | To use the sheet, fill out the blue items and the sheet performs common capacity planning calculations. For more information, see the whitepaper.
 | Cache Size (MB) | Transactions Per Hour | Transactions Per Sec | [NAME] Per Hour | [NAME] Per Sec | Concurrent Connections
 | 128 | 400000 |  | 1400 |  | 10
 | 256 | 800000 |  | 2800 |  | 10
 | 512 | 1600000 |  | 5600 |  | 20
 | 1024 | 3200000 |  | 11200 |  | 40
 |  | 6400000 |  | 22400 |  | 80
 |  | 12800000 |  | 44800 |  | 160
Memory Requirements:
 |  | Activity Data (Example) |  | Reference Data (Example) |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other
 | *Average Object Size (Post-Serialization): |  | Bytes |  | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes | 0 | Bytes
 | Per Object Overhead (1 %): |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes
 | Adjusted Object [NAME] to Nearest KB: |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes
 | *Max Number of Active Objects: | 1000 | Objects | 1200 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects | 0 | Objects
 | Total Cache Memory Required (MB): |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB
 | Total Cache Memory Required (GB): |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB |  | GB
Network Requirements:
 | Average Object Size: |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes
 | *Average Transactions per Second (Peak Load): | 5 | Trns/sec | 8 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec | 0 | Trns/sec
 | Total Transactions per Hour: |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour |  | Trns/hour
 | Total Bandwidth per Hour: |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour |  | MB/hour
Connections Requirements:
 | *Maximum Active DataCacheFactory Instances: | 4
 | *MaxConnectionsToServer setting: | 1
 | *Number of Azure role instances: | 3
 | *Connection Pooling Enabled? | Yes
 | Total Connections Required:
Azure Cache Offering: |  |  |  | Offering:
 | Total Memory Requirement: |  | MB
 | Total Transactions per Hour: |  | Trns/hour
 | Total Bandwidth per Hour: |  | MB/hour
 | Connections Required? |  | Connections
 | Cache Offering Required: |  | MB Offering