Last post May 06, 2005 11:13 PM by sivilian
May 06, 2005 04:45 PM|rspivack|LINK
We're getting a timeout on a query that uses a standard webpart but does a lot of formatting of the results.
I adjusted the timeout setting in web.config from 7 seconds to 70 seconds and now the query will complete but it takes a long time.
I would like to analyze where the page/query is slow (i.e. determine whether the web server or the back-end database server is the limiting factor so I can consider upgrading the right resource to improve the performance).
How can I determine where the performance bottleneck is?
May 06, 2005 11:13 PM|sivilian|LINK
You can do some simple test in order to determine the bottleneck in such a situation. Try the following:
Run the query through Query Analyzer and see how long it takes to return that data. If it takes five minutes, you know that's the problem; if it comes back instantly you know its not.
The problem can also be bandwith which deals with the size of the data going across the network. If you are sending your page megs of data, it will take time to download.
Another thing to check is the CPU Usage on the web server. If it goes up alot when you load the web part, then there is a pretty good chance it is the formating of the results.
hope this helps,