Slow response of SQL Query  
Author Message
Andylees





PostPosted: Mon Sep 12 21:30:13 CDT 2005 Top

SQL Server >> Slow response of SQL Query

We are using SQL Server for Storeing and maintaining large amount of data. We
use ASP Pages as a front end. The size of the database is too big i.e in
GB's. Nearly 100 transaction is performed at a time. Because of that
sometimes ASP pages is hanged and not display any data. Even sometime not the
correct data has been shown by the asp pages.
Hardware Configuration of Server: Processor pentium xeon (DEL power X 6500),
1 GB RAM , 7 GB free Space.
Slowness of executing SQL quary is our main problem. kindly give us proper
solution for the above problem and what will we do to minimize the slowness
of asp page execution.

SQL Server94  
 
 
Andrew





PostPosted: Mon Sep 12 21:30:13 CDT 2005 Top

SQL Server >> Slow response of SQL Query That is not much to go on. Have a look at these to get started:


http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring


--
Andrew J. Kelly SQL MVP




> We are using SQL Server for Storeing and maintaining large amount of data.
> We
> use ASP Pages as a front end. The size of the database is too big i.e in
> GB's. Nearly 100 transaction is performed at a time. Because of that
> sometimes ASP pages is hanged and not display any data. Even sometime not
> the
> correct data has been shown by the asp pages.
> Hardware Configuration of Server: Processor pentium xeon (DEL power X
> 6500),
> 1 GB RAM , 7 GB free Space.
> Slowness of executing SQL quary is our main problem. kindly give us proper
> solution for the above problem and what will we do to minimize the
> slowness
> of asp page execution.