Spreadsheet: 15acff35-e1ba-49dd-9631-d012145cb323
Sheet: Reference Data

 |  | VM Type | Physical Memory (MB) | Cache Working Set (MB) | Cache Data Size on VM (MB) |  |  |  |  |  | VM Network |  | Static Overhead (MB) |  | Partitions Count per Cache
 |  |  |  |  | No HA (Default 2KB) | With HA (Default 2KB) | No HA (1KB) | With HA (1KB) | No HA (128 byte) | With HA (128 byte) | [NAME] | MBps | Without HA | With HA (MB)
 |  | XS | 766 | 237 | 115 | 71 | 101 | 63 | 42 | 26 | 5 |  | 110 | 150 | 30
 |  | S | 1790 | 1020 | 791 | 711 | 696 | 626 | 288 | 259 | 100 |  | 148 | 228
 |  | M | 3583 | 2831 | 2372 | 2227 | 2088 | 1960 | 866 | 813 | 200 |  | 216 | 376
 |  | L | 7230 | 6145 | 5243 | 4956 | 4615 | 4363 | 1914 | 1810 | 400 |  | 365 | 685
 |  | XL | 14398 | 13031 | 11236 | 10681 | 9891 | 9402 | 4103 | 3900 | 800 |  | 644 | 1284
 |  |  |  |  |  |  |  |  | Unused | Unused
 |  | Co-located planner INTERNAL CALCULATIONS BEYOND THIS POINT
 |  | Input: Internal Variables
 |  | Nodes per UD | 1 | VM
 |  | Minimum Cache Size | 2 | MB
 |  | Computed: Requirement Calculations
 |  | Physical Memory on VM |  | MB
 |  | [NAME] available to Cache |  | MB
 |  | Number of VMs to consider for storage |  | VMs
 |  | User Data to be stored per VM (including copies) |  | MB
 |  | Static Cache Overheads (depends on HA ON/OFF) |  | MB
 |  | Physical Memory for Cache per VM |  | MB
 |  | Feasibility of hosting Cache (1 or 0) |  | Flag
 |  | Is it feasible to host Cache in this cluster
 |  | Physical Memory % required for Cache |  | % per VM |  |  | % per VM (without resiliency)
 |  | Physical Memory % available for primary role |  | % per VM
 |  | Message (if any)
 |  | Strings Used
 |  | Please consider a different configuration (VM size, VM count) or move to Dedicated Cache
 |  | Please make sure there is enough network & CPU available to sustain load on cache
 |  | Such a small cache is not supported
 |  | Dedicated planner INTERNAL CALCULATIONS BEYOND THIS POINT
 |  | Input: Maximum Memory Requirements | Value | Unit
 |  | Maximum memory to use per VM | 95 | %
 |  | Maximum network to use per VM | 80 | %
 |  | Time for data transfer during graceful shtudown | 210 | seconds
 |  | Maximum Supported Upgraded Domains | 16 | UDs
 |  | HA: Storage Overheads | 2 | times
 |  | HA: Throughput Overheads(Network/CPU) | 6 | times
 |  | [NAME] |  | times
 |  | Default Object Size (bytes) | 2048 | bytes
 |  | [NAME] (bytes | 1024 | bytes
 |  | Computed: Data Requirements | Value | Unit | Value | Unit | Value | Unit | Value | Unit | Value | Unit | Value | Unit | Value | Unit | Value | Unit | Value | Unit | Value | Unit
 |  | Raw Memory Required (bytes) |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes |  | Bytes
 |  | Total Object Count (in cluster) |  | Objects
 |  | Weighted Average Object Size (bytes) |  | Bytes
 |  | Use Default COGS (> 2 KB objects) |  | Yes/No
 |  | [NAME] (bytes) |  | Bytes
 |  | Adjusted Object [NAME] to Nearest KB:
 |  | Cache Memory Required (MB) |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB |  | MB
 |  | Read Bandwidth Required |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps
 |  | Write Bandwidth Requited |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps |  | MBps
 |  | HA State (0 - Off 1 - On)
 |  | Consider HA for this data type
 |  | Computed: Cluster Requirements | Value | Unit
 |  | Total Required capacity (MB) |  | MB
 |  | Total Read Bandwidth required |  | MBps
 |  | Total Write Bandwidth required |  | MBps
 |  | Total Bandwidth Requirements |  | MBps
 |  | HA On (for any cache) |  | Flag
 |  | Computed: VMs Requirements | Raw Resource With Buffers
 |  |  | Memory Available per node (MB) | Memory Available per node (MB) | Network Available per node (MBps) | Partitions per Cache
 |  | XS
 |  | S
 |  | M
 |  | L
 |  | XL
 |  | Computed: VMs Requirements | Capacity Calculations without data resiliency support
 |  |  | Data that can be stored per partition (MB) | Partitions per node (maximum) | VMs needed based on memory  requirements (accurate) | VMs needed based on memory  requirements (rounded) | VMs needed based on network requirements (accurate) | VMs needed based on network requirements (rounded) | Number of VMs required to host Cache (no data resiliency) | Recommended VMs to host Cache (no data resiliency) | Recommended Upgrade Domain Count
 |  | XS
 |  | S
 |  | M
 |  | L
 |  | XL
 |  | Capacity Calculations with data resiliency support
 |  | VM Size | Calculations for resiliency of user data
 |  |  | UDs in deployment based on VM count for memory requirements | [NAME] per UD (worst case) | VMs needed based on memory  requirements  with data resiliency (rounded)
 |  | XS
 |  | S
 |  | M
 |  | L
 |  | XL
 |  | VM Size | Calculations for bandwidth required for graceful shutdown (CPU requirements implicit)
 |  |  | VMs to consider for bandwidth resiliency calculations | UDs in deployment based on VM count for resliency calculations | [NAME] per UD (worst case) | Data stored per node (MB) | Data to be sent (MB) when 1 UD goes down (worst case) | Data to be received / remaining live box (MB) (worst case) | Network required (MBps) for incoming data | Network required (MBps) for outgoing data
 |  | XS
 |  | S
 |  | M
 |  | L
 |  | XL
 |  | VM Size | Calculations for resiliency of throughput (client load and graceful shutdown) |  |  |  |  | Capacity recommendations with data resiliency
 |  |  | Additional Network required ([NAME]) for graceful shutdown | Network Available (MBps) Buffered VM Capacity - Additional Requirements | VMs needed based on network requirements with data resiliency (accurate) | VMs needed based on network requirements with data resiliency (rounded) |  | Number of VMs required to host Cache (with data resiliency) | Recommended VMs to host Cache (with data resiliency) | Recommended Upgrade Domain Count
 |  | XS
 |  | S
 |  | M
 |  | L
 |  | XL
 |  | VM Size | Feasibility & Recommendation Analysis
 |  |  | Winning VM Count | Winning Upgrade Domain Count | Feasibility | Recommended
 |  | XS |  |  | 0 | 0
 |  | S
 |  | M
 |  | L
 |  | XL
 |  | VM Size | Final Proposal |  |  | Custom Output
 |  |  | VM Count | [NAME] | Option |  | Message
 |  | [NAME] in next cell -->
 |  | Strings Used
 |  | Infeasible
 |  | Feasible
 |  | Recommended
 |  | Not Recommended
 |  | Cannot host cache on this VM. Please consider moving to a larger VM.
 |  | [NAME] greater than 32 Not Supported. Consider splitting into multiple clusters.
 |  | Set by planner
 |  | *Please change the cacheDataSizePerNode config in CacheSettings.XML to the value shown in the CacheDataSize column above. For instructions, see Capacity Planning Considerations at http://go.microsoft.com/fwlink/?LinkId=245716