capacity-planning

Best way to determine the number of servers needed

How much traffic can one web server handle? What's the best way to see if we're beyond that? I have an ASP.Net application that has a couple hundred users. Aspects of it are fairly processor intensive, but thus far we have done fine with only one server to run both SqlServer and the site. It's running Windows Server 2003, 3.4 GHz with 3...

How do I estimate SQL Server index sizes

While estimating straight row and table sizes are fairly simple math, we find it challenging to guess just how much space each index will occupy (for a given table size). What areas can we learn to calculate a better estimate and growth rate for indexes? ...

Apache capacity planning tool?

Is there any tool specially designed to analyze Apache traffic logs and give some advices on future load (bandwidth & requests per second)? I am searching for some tools to help me understand better how the server is used and where the performance bottleneck will appear. ...

Web server capacity planning: more cores versus more memory

We have an ASP.NET project (40 or so Web forms, 50 tables, pretty standard IO stuff with care taken to minimize when possible) that will soon need to be deployed. There will be about 100 concurrent users on the system, but only about 20 at any one time will be pounding on it it. We'll be deploying it on Windows Server 2008, 32-bit initia...

Work out sprint capacity when carrying over story points in scrum

Let’s say story A is worth 10 story points. Development starts in sprint 100, but is not completed by they end of the sprint. I am then assuming that you do not claim any points. A story is done or not done. And tets say your average velocity is 25pts and your team stays the same for the next iteration. So when working out your capacity ...

How many megabytes per day are two nibbles per nanosecond?

One of my tables in my SQL database has a growth rate of two nibbles per nanosecond. I was wondering how many megabytes per day that is and should I be worried? My hard disk is 150 GB. ...

Displaying access log analysis

I'm doing some work to analyse the access logs from a Catalyst web application. The data is from the load balancers in front of the web farm and totals about 35Gb per day. It's stored in a Hadoop HDFS filesystem and I use MapReduce (via Dumbo, which is great) to crunch the numbers. The purpose of the analysis is try to establish a usage...

capacity of ec2 amis

How can I evaluate the capacity of Amazon EC2 Amis for my different templates; A) Webserver (Apache/PHP) - pages/sec. B) Database (MySql) - connections/sec. C) App Server (Tomcat) - pages/sec. I was hoping there was some kind of baseline tool that I can use to evaluate the many choices available on EC2 without using my System Under Deve...

Caveats of select/poll vs. epoll reactors in Twisted

Everything I've read and experienced ( Tornado based apps ) leads me to believe that ePoll is a natural replacement for Select and Poll based networking, especially with Twisted. Which makes me paranoid, its pretty rare for a better technique or methodology not to come with a price. Reading a couple dozen comparisons between epoll and ...

Sizing and Capacity Planning Tips and How-to

I am often asked to perform sizing and capacity planning for our clients. When our clients buy our products (basically J2EE web applications), they often ask what hardware they will need to run those products. Our recommendations often result in high-cost hardware acquisitions. So far, the best heuristics I developed is to compare the u...

How do I enable FFMPEG logging and where can I find the FFMPEG log file?

I want to be able to log FFMPEG processes because I am trying to work out how long a minute of video takes to convert to help with capacity planning of my video encoding server. How do I enable logging and where is the log file saved. I have FFMPEG installed on a CentOS LAMP machine. ...

Estimation of commodity hardware for an application

Suppose, I wanted to develop stack overflow website. How do I estimate the amount of commodity hardware required to support this website assuming 1 million requests per day. Are there any case studies that explains the performance improvements possible in this situation? I know I/O bottleneck is the major bottleneck in most systems. Wha...

Theoretical minimum round-trip-time for a packet to travel over/under the North Atlantic Sea?

I'm doing some performance tuning and capacity planning for a low-latency application and have the following question: What is the theoretical minimum round-trip time for a packet sent between a host in London and one in New York connected via optical fiber? ...

Developer Capacity Planning

What product or tool do you use to do Resource Capacity planning for your development team? Currently managing a large group and trying to provide visibility into my resource availability. I am creating this in MS project, but was curious if there was a better tool/solution based off your experience. ...

Windows 2008 server -hardware planning help

Hello all, I am setting up a website on win2008/sql2008 (64 bit) on a dedicated server, which may get 50K to 100K users/visitors. Concurrent users at any time may be 1000 (max). Users will log in 4 to 6 times a month and spend 10 minutes (maximum) on the site for minimal data entry. There will be some reporting run at night. The site h...

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 infrastructure. In this case, it’s someone else’s job to worry about that bit! I’m aware there are a...

capacity planning determine whether the system could handle load

Lets say a jee 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 traffic could be handled by the existing environment? Is there a way to find it out using som...

What are the crucial key items in recording technical debt?

I'm setting up a technical debt register at The Office and want to make it a fairly comprehensive tool. What are the key pieces of information that we should be recording? ...