Remote dedicated MS SQL connection problem
From: weeee (weeee.1awdl3_at_mail.webservertalk.com)
Date: 08/12/04
- Next message: Lisa Pearlson: "Why does this crash SQL7 ?"
- Previous message: Sam Bendayan: "Linked servers and UDLs"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 12 Aug 2004 13:09:32 -0500
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 are only a few users everything works fine and fast , but as more
and more users comes in , the site becomes very very slow ( but CPU
load on script server 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 server , 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 only 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
-- weeee ------------------------------------------------------------------------ Posted via http://www.webservertalk.com ------------------------------------------------------------------------ View this thread: http://www.webservertalk.com/message347650.html
- Next message: Lisa Pearlson: "Why does this crash SQL7 ?"
- Previous message: Sam Bendayan: "Linked servers and UDLs"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
