Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Capacity Planning Expand / Collapse
Author
Message
Posted Monday, June 1, 2009 4:58 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 229, Visits: 166
Dear All,

I am trying to create a Server configuration for one of the fortcoming Projects where A SQL server Instances will have 70 - 100 Database Running and for each database there could be 50-60 Users connected Concurrently and each db could be between 3 to 4 GB of Size (Maximum). Is there formula for calculate the Processors, RAM and HDD Requriements ? Any help would be greatly appreciated.

Thanks in Advance.

Jeswanth


--------------------------------
Post #726529
Posted Monday, June 1, 2009 5:30 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:44 AM
Points: 770, Visits: 1,597
Hmm nice one, I can roughly calculate the Configuration, but i would look into various other factors as well , It will be interested to know if there are formulas for this, if i am not wrong i read something like this on MS website long age, i will let you know if i can find this
Post #726541
Posted Tuesday, June 2, 2009 3:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:38 AM
Points: 2,880, Visits: 3,237
Ther are some specialist forums dealing with Capacity Planning and Capacity Management topics. Google should help you find these.

The main thing you need to focus on at the start is your methodology, not on the maths. The above forums should help with the methodology.

From what I know about CP, you need to model what resources an actual instance will take and extrapolate from there. If you have anything running at present that is a useable model then use it, otherwise you will have to build a model. Anything else is guesswork.

When you have your model, look at how much CPU, I/O per second, disk space, etc is being used for a single instance. Then multiply that out to give what you need for the whole application.

You then need to slice that up by what your equipment can handle. If you need 1m I/O per second, do you need multiple HBAs into your SAN to achieve this, or do you even need multiple SANS. Can yuor favourite server handle the CPU and I/O load, or do you need multiple servers. Do the same with every part of the infrastructure. Eventually you will get a shopping list of what to buy.

One of the top CP experts in the UK told me some time ago that the best you will get with this planning is +/- 25% of reality. For a newcomer to this work, +/- 50% would be a good result. Make sure your management have the right expectations about the result of this exercise. If they do not like your figures, suggest they either pay for experienced consultants or accept the best you can offer.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #727246
Posted Tuesday, June 2, 2009 11:45 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 229, Visits: 166
Hi Edvassie/Crazy Man,

Thanks for the replies, as i am from a developmet background dont have much knowledge in Implementation aspect of the SQL Server, So googling for all teh methodologies and documents and learning the basics of CP, looks like this is much more tougher and interesting than what i thought :)

Thank You
Jeswanth


--------------------------------
Post #727879
Posted Monday, June 4, 2012 11:19 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 6:03 AM
Points: 6, Visits: 103
Hi,

Check out this blog, it may help you asses the current capacity limits of your 'model' and further be able to determine what resources you need to build the new server. May not be a complete solution but hope it would get you started.

http://sqlactions.com/2012/05/15/collection-and-reporting-of-perfmon-data-for-sql-server-capacity-planning-and-trend-analysis


Prashant
Check out my blog at http://sqlactions.com
Post #1310951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse