Solved

How can we do the capacity planning for SQL OLTP database?

Posted on 2009-04-14
2
382 Views
Last Modified: 2012-05-06
How can we do the capacity planning for SQL OLTP database?
0
Comment
Question by:asqldba
2 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 500 total points
ID: 24141007
There isn't an easy answer to your question.. You will have to gather information relating to the areas indicated below -

A) Normal and Peak level of concurrent users
B) Initial Data volume (MB/GB) and expected annual growth
C) Normal and Peak transactions per minute
D) Availability in terms of database backend being online and available to users
E) Disaster Recovery

Here's a few links that may be of help once you have the initial stats to work with -

http://www.gre-sqlserver-solutions.com/Capacity.html
http://blogs.msdn.com/weix/archive/2005/04/17/408942.aspx
http://www.mssqltips.com/tip.asp?tip=1267
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question