Questions tagged [capacity-planning]

Capacity planning is the science and art of estimating the space, computer hardware, software and connection infrastructure resources that will be needed over some future period of time.

As per techtarget definition:

Capacity planning is the science and art of estimating the space, computer hardware, software and connection infrastructure resources that will be needed over some future period of time.

A typical capacity concern of many enterprises is whether resources will be in place to handle an increasing number of requests as the number of users or interactions increase.

The aim of the capacity planner is to plan so well that new capacity is added just in time to meet the anticipated need but not so early that resources go unused for a long period. The successful capacity planner is one that makes the trade-offs between the present and the future that overall prove to be the most cost-efficient.

Basic steps of capacity planning:

  1. Determine Service Level Requirements
    The first step in the capacity planning process is to categorize the work done by systems and to quantify users’ expectations for how that work gets done.
  2. Analyze Current Capacity
    Next, the current capacity of the system must be analyzed to determine how it is meeting the needs of the users.
  3. Planning for the future
    Finally, using forecasts of future business activity, future system requirements are determined. Implementing the required changes in system configuration will ensure that sufficient capacity will be available to maintain service levels, even as circumstances change in the future.

Capacity planning activities:

  • capacity analysis and prediction for storage, database, and application servers;
  • designing architectures to easily add and measure capacity.
  • handling sudden spikes.
  • predicting exponential and explosive growth.

Do not confuse performance with capacity: performance is based more on human work, and capacity is based more on computer resources.

75 questions
3
votes
1 answer

Maria DB storage capacity and pricing

Currently starting plan for Maria DB is only 1 GB. I would rather expect to have next plans: S - 5 GB, M - 35 GB and L - 100 GB. Is there any plan to extend Maria DB storage plans? We are expecting to release one App hosted in Swisscom Cloud that…
Eugene Gy
  • 107
  • 8
3
votes
1 answer

SQL Server row length calculator

I am looking for an up to date tool to accurately calculate the total row size and page-density of any SQL table definition for SQL Server 2005+. Please note that there are plenty of resources concerning calculating sizes of rows in existing…
3
votes
2 answers

How to find the need of materials from nested estimates in Postgres

Product estimates contain sub-products. Sub-products can contain also sub-products etc. Finally tree leafs contians materials. Maximum nesting level is 10. Orders contain also products, sub-products and materials with ordered quantities. How to…
Andrus
  • 26,339
  • 60
  • 204
  • 378
2
votes
2 answers

Capacity planning and estimating costs with Amazon Web Services for 1M users

I'm in the planning stages of estimating server costs for my web application. How can I determine how many Amazon EC2 instances will I need to handle a database backed web application with 1M active users? How should I go about filling out this…
2
votes
0 answers

How to gather web site usage statistics without degrade the performance?

In order to be able of understand how the users are using a web application, which are the parts of the application with more stress and all that, I need to keep data about how the site is being used in a queryable way. I would like to keep general…
vtortola
  • 34,709
  • 29
  • 161
  • 263
2
votes
1 answer

Can we perform capacity planning in Azure Devops board based on Story points entered on User Stories instead on hours entered in Task?

I want to know whether I can perform capacity planning based on story points entered in User Stories and not based on hours entered in Task. This way I don't have to define hours in task. I will just enter task under each User Story and leave the…
2
votes
0 answers

Managing cluster and yarn utilization

In our cluster, we have minimum container size as 8 GB most of the hive queries use 1 container. ( but surely may not use all the memory allocated ) some of the spark jobs just use 2GB or 4GB we don't use that much memory for all our queries as per…
Kumar
  • 119
  • 10
2
votes
2 answers

TFS 2015 "Capacity" tab missing

I have an "Advanced" license in our TFS 2015. However, the "Capacity" tab is missing when I view the backlog. What else am I missing?
AngieM
  • 735
  • 6
  • 27
2
votes
2 answers

capacity planning determine whether the system could handle load

Lets say a Java EE based e-commerce web site is performing well giving expected response time and throughput. The web site is undergoing major ui changes and it is expected to bring 3 times more traffic. How do I find out whether the projected web…
coolguy
  • 229
  • 4
  • 9
2
votes
1 answer

Projecting simultaneous database queries

I’m after some thoughts on how people go about calculating database load for the purposes of capacity planning. I haven’t put this on Server Fault because the question is related to measuring just the application rather than defining the…
Troy Hunt
  • 20,345
  • 13
  • 96
  • 151
2
votes
1 answer

teradata data block size and table size calculations

Been using this formula as a std for TB size calculation , as part of Cap. Planning effort . We are on TD 14 ( rc * ( rsz / ( blocksize -38) ) * blocksize ) + ( SQL (sel Hashamp()+1 ; ) * 1024 ) rsz : row size , rc : count ( * )…
2
votes
1 answer

Concurrent User Calculation

I am trying to calculate the average concurrent user using the below formula Average Concurrent Users = Visits per hour / (60 min/hour / average visit) Visit Per Hour is 750 Average Visit is 1.6 Min (The amount of time user will spend to access…
Senz79
  • 21
  • 3
2
votes
0 answers

How do I do Capacity Planning for HBase?

I am planning to use HBase for a social application. The starting user base would be around 5k and monthly it would keep increasing on around some 3k per month. Which approach would increase the efficiency of my application: Dynamically adding…
HSIRIG
  • 21
  • 2
1
vote
1 answer

Nodal/Label assignment according to the load at a terminal in pandas data frame python

Input data frame with requirement for boarding in a transport allocation setting. import pandas as pd data1 = { 'N_Id': [0,1,2,2,2,2,4,5,5,5,10,10,11,11,13,13,13,13], 'N_Name':…
1
vote
0 answers

Capacity Planning for Task/Message Queue

There is a celery task in Django setup which uses Redis as a backend. I want to improve throughput, responsiveness, and predict task completion time for capacity planning. The task takes the data from the internal system and syncs it to an external…
Kracekumar
  • 19,457
  • 10
  • 47
  • 56