I have ASP.NET Application. It gets data (report) from SQL Server 2008.
The database is configured to get data updates from other DB servers.
So my problem is:
my application drops error 404 page because SQL query takes 30-60 seconds.
I set Connection Timeout=120.
What else should I do ?