Hi guys,

I use to run my ASP script on the same server as my MS SQL , but due to CPU 
resources problem i had no choice but to relocate my ASP scripts to another 
server in the same datacenter

My global.asa file uses TCP/IP  to connect to MS SQL database , when there a
re only a few users everything works fine and fast , but as more and more us
ers comes in , the site becomes very very slow ( but CPU load on script serv
er is only less than 20% ) and i will get this SERVER ERROR 80004005 TIMEOUT
 ERROR , or internal 500 error intermittently .

the problem is if i host the script on the same server as MS SQL , i can get
 up to 50 users concurrently without much problem ( althoug CPU usage would 
probably jump to 90% ) , but once i host the script remotely on the APP serv
er , anything more than 5 users makes everything goes slow and loading time 
long or else i will get the above mention error messages

I have tried everything - IIS setting , metabase setting 

Does anyone know why and how i can solve theses issue??

my script server is only hosting 1 site for this testing , and my MS SQL onl
y have 2 db on it

my DB server is on a dual xeon 3 gig ram , my script server is P4 2.8 with 1
 gig ram

Please advise and thanks in advance

regards

[ Post a follow-up to this message ]