We have SharePoint installation on 2 WFEs + 1 index + Clustered SQL Server 2005. All physical servers. We are load testing with about 250 users. Out of the box SharePoint application work fine with about 4 seconds home page load time. But when it gets to the custom application, the home page load time is 14+ seconds in the beginning of the load. At around 225 users, the w3wp process corresponding to the application takes about 1.2 GB memory. At this point, the home page load time may be as high as 100 seconds and the application becomes unresponsive. The WFEs have 8 GB and the SQL Servers have 32 GB RAM. Is there a limit that if process takes 1 GB +, IIS becomes unresponsive? The SharePoint custom application has some not to heavy web parts. We have done some perfmon logging and monitoring but could not conclude anything. I want to first check whether all traffics between WFE and SQL Server is flowing as per expectation. Then I want to check whether SQL Server is responding in timely fashion. How do you suggest I check these specific things? Thanks

for your SQL traffic check this link: http://technet.microsoft.com/en-us/magazine/2005.05.systemtables.aspx and you can always check the bandwidth which is being used by all users that will give you an idea about how much the data is flowing in and out between ur WFE and SQL server

for your SQL traffic check this link: http://technet.microsoft.com/en-us/magazine/2005.05.systemtables.aspx and you can always check the bandwidth which is being used by all users that will give you an idea about how much the data is flowing in and out between ur WFE and SQL server

Thanks talhak. Eventually it was found that the NIC card was not set to 1 GB full duplex and it was serving at 100 MB when it had the throughput capacity of 1 GB. As soon as the NIC card settings swere fixed, the load test was passed.

Yes, we also had similar issue, but in our case when the europe clients accessed our site, the site was very slow or not working. We were having network contentions, so the network bandwidth was increased in our case from 9 mb to 22 mb. Although, 21 mb is not enough but to improve the performance and reduce the network traffic implement the following: http://celerity12.blogspot.com/2010/04/httpcompression-and-browser-caching.html Thanks celerity12