How to Improve SQL Server performance with web application

Hi all,
I am facing some difficulties with web application performance. I have
web application in front end and SQL server 2000 Enterprise Edition in
Backend. Now , some web pages in application takes very long time
while getting data from SQL server. I want to improve the speed with
which the some web pages load.
Do anyone has idea of any third-party tools that can help me with
this situation. So, that I can constantly monitor performance of
Database with Web application.
Any help will be appriated.
Thanks in Advance.
alpsHi
"alps" wrote:
> Hi all,
> I am facing some difficulties with web application performance. I have
> web application in front end and SQL server 2000 Enterprise Edition in
> Backend. Now , some web pages in application takes very long time
> while getting data from SQL server. I want to improve the speed with
> which the some web pages load.
> Do anyone has idea of any third-party tools that can help me with
> this situation. So, that I can constantly monitor performance of
> Database with Web application.
>
> Any help will be appriated.
> Thanks in Advance.
> alps
>
SQL Server profile will be able to monitor your database, but you may want
to control when it is running. From the profile you can analyse what queries
are running slowly. This analysis can be done by hand or using a tool such as
cleartrace http://www.cleardata.biz/cleartrace/default.aspx You should also
check for queries that return large amounts of data as this can take time to
render. Techniques such as paging may help to improve performance and only
return a manageable amount of data. You can analyses your web logs to find
pages that take a long time to load, you should be able to find free tools on
the internet that help you to do this.
Perfmon will also help you monitor system resources.
John