Load Balancing

How much traffic/load can a database server running MS SQL server take
before it can't handle it anymore? And when that time comes, what are the
recourses? Am I able to load balance it between separate servers?Jibba Jabba wrote:
> How much traffic/load can a database server running MS SQL server take
> before it can't handle it anymore? And when that time comes, what are the
> recourses? Am I able to load balance it between separate servers?

Depends on the server hardware. And based on Microsoft's federated
architecture ... while you can offload to multiple servers ... you must
do a lot of duplication and mean time between failures goes down ...
not up.

If you get to the point that SQL Server can no longer handle the load
... you are most likely looking at Sybase, Informix, Oracle, DB2 or
waiting hopefully for some future version.

--
Daniel Morgan
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)|||"Jibba Jabba" <dontemailme@.dontemailme.com> wrote in message news:<UsEWb.893$tL3.845@.newsread1.news.pas.earthlink.net >...
> How much traffic/load can a database server running MS SQL server take
> before it can't handle it anymore? And when that time comes, what are the
> recourses? Am I able to load balance it between separate servers?

As with most performance-related questions, there's no simple answer.
If you have a well-designed application, and well-written code, then
the answer is 'a lot'. If you don't, then the answer is 'not a lot'.
The only way to get a real, quantifiable answer is for you to do some
load testing using your own code and data. In many cases, scaling up
the database server is pointless, because the application code is the
real bottleneck, but again, this is something that only you can
investigate properly.

Simon|||"Jibba Jabba" <dontemailme@.dontemailme.com> wrote in message
news:UsEWb.893$tL3.845@.newsread1.news.pas.earthlin k.net...
> How much traffic/load can a database server running MS SQL server take
> before it can't handle it anymore? And when that time comes, what are the
> recourses? Am I able to load balance it between separate servers?

"It depends"

What type of load. How fast are your disks, your CPU, etc.

You can't do load-balancing per-se, but you can do various things that can
help.

We publish data to Box A and then push that to Boxes B and C and uses those
for reading. Works well.