Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nimesh69
Starting Member
30 Posts |
 Posted - 2001-08-02 : 03:39:46
|
| Greetings.We've developed an app using asp/vb-com/sql7 running on WinNT4/IIS4/MTS. Once user logs on to the app they are displayed list of activities that they're supposed to work on. The list is paged and only 10 recs are displayed at a time. To get this list a stored proc is being used at the backend where selection of records is done and since the data is coming from about 15odd tables they're being put into a temp table. Temp table is updated for only 10recs and these record set is then sent to com which inturn sends it to ASP as disconnected. ASP after doing a beautification throws it to the browser.We're facing a typical problem where if a single user sees this list from browser then it takes about 1.5sec (the site is hosted on our external server with dedicated 1mbps link and being accessed thru 1mbps proxy line). When we do a stress testing with Rational ROBO or MS Web app stress tool with 25 users the AVERAGE response time shoots up to 17secs with min 3sec and max 42sec. With 100users the average is 36secs.We've placed IIS/MTS on one box with 700mhz/512RAM single CPU server and SQL on another 700Mhz/512/single cpu server with 3physical disk controller. Both the servers are physically connected with a 100mbps NIC (Not thru hub).I could have given more info but then msg would be too long and might consume your time to read.Would anyone have any idea as to how to tune any of these server to cater concurrent users faster?Thanks for your time to read thru the msg.Good day.- Nimesh |
|
|
|
|
|
Performance Issue