Hi,
Create a "queue" service between the app servers and the db. This
service needs to (asynchronously) queue requests from the nlbs and feed
them to the db in fifo order. Since the queue will be asynchronous,
there will be no "blocking" of the nlb processes.

Regards,
Ken

-----Original Message-----
From: Mandeep Bhutani [mailto:[Email Address Removed]
Sent: Friday, January 16, 2004 9:02 PM
To: LazyDBA.com Discussion
Subject: CPU Usage

HI,

I have a scenario,
Cliens --> App Server on NLB --> DB Server(SQL 2000)
While testing load, from Client to APp Server, the
load is evenly divided into the 4 APP servers on NLB
but when the request goes from NLB to DB Server, the
CPU shoots to 100% and the performance degrades. I
checked all the possible ways to tune the CPU. The m/c
is dual processor with 2.4 GHz speed. I tried on stand
alone DB Server and one on Cluster but no performance
hike.


Can anybody give any suggestion??

Regards
Mandeep




__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page