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 to another server in the same datacenter
My global.asa file uses TCP/IP to access the 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.
I tried to adjust the max thread setting on my windows 2003 , but i cant seems to find it in the registry , any idea how to edit the metabase and how to solve my MS SQL 80004005 error ?
Does anyone know why and how i can solve theses issue??
Please advise and thanks in advance