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.
> 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.