Sunday, February 12, 2012

check whats needed if load doubled over the next few months

If we anticipate our load to double i.e twice the number of customers,etc..,
how do we go about planning if the db system today is adequate to meet that
demand ? What areas should we look at and what to consider to provide that
scale ?
ThanksOn Jan 31, 8:14=A0am, "Hassan" <has...@.test.com> wrote:
> If we anticipate our load to double i.e twice the number of customers,etc.=.,
> how do we go about planning if the db system today is adequate to meet tha=t
> demand ? What areas should we look at and what to consider to provide that=
> scale ?
> Thanks
You will need to start analyzing towards the capacity planning and
the elements you will have to think for
Disk Space
CPU (32 bit or 64 bit as per your need)
Memory :- based on CPU selection again you can think for Memory.
Thanks
Ajay|||Before you can answer that question, you need to determine where your
bottleneck will be on your database server when your number of customers
doubles.
Linchi
"Hassan" wrote:
> If we anticipate our load to double i.e twice the number of customers,etc..,
> how do we go about planning if the db system today is adequate to meet that
> demand ? What areas should we look at and what to consider to provide that
> scale ?
> Thanks
>|||Unfortunately most things don't scale linearly either, in addition to the
other comments on this thread. Once you hit saturation points for various
resources, performance starts to degrade dramatically, sometimes at at
exponentially decreasing rate. You cannot specifically know WHERE the
limits are either, although a good analysis can get you pretty close
usually.
I will once again take this opportunity to recommend you hire a seasoned DBA
sooner rather than later. :)
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Hassan" <hassan@.test.com> wrote in message
news:%23B9Rbd7YIHA.4448@.TK2MSFTNGP03.phx.gbl...
> If we anticipate our load to double i.e twice the number of
> customers,etc.., how do we go about planning if the db system today is
> adequate to meet that demand ? What areas should we look at and what to
> consider to provide that scale ?
> Thanks

No comments:

Post a Comment