Load balace issue

Hi everyone, I am running into an issue that the SQL server CPUs are all the
time busy serving request [between 80-100%] , and users are now complaining
of slow performance of the application even the server is a dual xeon 2.8
processors and 6GB of ram and set as high priority, I run SQL 2000
Enterprise.
some have suggested to use a load balancing, where I can add more servers
and they all will act as one server.
This sounds very interesting if the load can be distributed among several
servers.
can anyone give me a suggestion or guides me to where I get more info and
how to do it.
I got some info on the failover which look close but does not solve the
problem of high CPU usage.
I greatly appreciate any feed back
Thanks in advance.Hi
Unless you have an intricate application design that supports load balancing
(with replication behind the scenes etc), you can't do it.
SQL Server does not support load balancing.
You should not run SQL Server in high priority as you may starve the OS of
CPU cycles, resulting in an actual system slowdown.
Have you looked at what is causing your CPU's to run so high? Bad indexing
jumps to my mind. Are you sure that SQL Server is using the 4.7GB of the 6Gb
it could? Run profiler and see which queries are the problematic ones and
tune those. Check with Performance monitor what the SQL Server Target Memory
setting is.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"aherzallah" <ah@.herz.dk> wrote in message
news:uITvd1OAGHA.3296@.TK2MSFTNGP12.phx.gbl...
> Hi everyone, I am running into an issue that the SQL server CPUs are all
> the time busy serving request [between 80-100%] , and users are now
> complaining of slow performance of the application even the server is a
> dual xeon 2.8 processors and 6GB of ram and set as high priority, I run
> SQL 2000 Enterprise.
> some have suggested to use a load balancing, where I can add more servers
> and they all will act as one server.
> This sounds very interesting if the load can be distributed among several
> servers.
> can anyone give me a suggestion or guides me to where I get more info and
> how to do it.
> I got some info on the failover which look close but does not solve the
> problem of high CPU usage.
> I greatly appreciate any feed back
> Thanks in advance.
>|||Have you run a profile to see what queries are actually running? Ok, it
could well be that you are running at capcity, but don't overlook the fact
that your application could have design flaws, or in need of some
maintenance. How about your database design, indexes etc...Just broad
suggestions, certainly worth checking out before you spend your bosses money
on a server farm! :)
HTH.
"aherzallah" <ah@.herz.dk> wrote in message
news:uITvd1OAGHA.3296@.TK2MSFTNGP12.phx.gbl...
> Hi everyone, I am running into an issue that the SQL server CPUs are all
> the time busy serving request [between 80-100%] , and users are now
> complaining of slow performance of the application even the server is a
> dual xeon 2.8 processors and 6GB of ram and set as high priority, I run
> SQL 2000 Enterprise.
> some have suggested to use a load balancing, where I can add more servers
> and they all will act as one server.
> This sounds very interesting if the load can be distributed among several
> servers.
> can anyone give me a suggestion or guides me to where I get more info and
> how to do it.
> I got some info on the failover which look close but does not solve the
> problem of high CPU usage.
> I greatly appreciate any feed back
> Thanks in advance.
>