Performance issue become worse upon split out Web Applications into web server and DB server

hi,

currenly i'm faced web applications (in web server, 2gb ram) performance issues upon seperated database(4gb ram) and web application 2 machines. before spliting, have performance issue iis need reset when "server un-available" or hanging occur. in case i proposed split out better performance , hope resolve issue. now, after spliting, users complaint responce time worst before. 1 have problem before? suggestions help?

* db server sql server 2005 , sql server 2000 installed used sql server 2000 , both web servers window server 2003 installed crystal report 10.

thank you..

 

 

obviously problem not on memory, since have lot. there can several issue involved.

one may problem not in usage of resources sql server 2005 on server, in actual application. , think may problem. don;t know of application, let's see scenario:

another thing happening (and doubt it) have network problems , communication between application , sql server 2005 taking long.

let's have big queries constructed , sent database, database executes queries , returns information gathered. here there maybe bottlenecks in : 1) query construction, 2) query communication, 3) query execution or 4) query results communication. use have in same machine if case describe fits in yours, there no communication problem between sending query , receiving results because on same machine. if split them, have communication problem, because takes longer send , receive information.

but not source of problem, problem query building.

of course assuming much, trying rationalize problem. useful if provide more information.

the first thing need identify problem is, either if in application, in database or in communication between them.

to check bottlenecks in application recommend using profiler application, use ants , helps lot. in case of database , communications can use tools sql server 2005 has, profiler.

i hope helps.

Architecture  >  Architecture General