Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rupesh02kumar
Starting Member
4 Posts |
 Posted - 2011-08-30 : 03:20:36
|
| hi i did the indexing but still my query execution time is high 2 minute .... the same query with differnt constant value runing in 11 sec....what i have to do and my web page get expired in 30 second so the query runing in 30 sec it will disply on the web and other query who is taking more than 30 sec the error page is appearing how to come out with this error i alredy set the execution time 0 sec and connection time all the possible stuff with web config i didlog file consisting this error message :----Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.plese help me....thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-30 : 09:47:39
|
| have you analysed the execution plan and checked if index is getting used?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
timeout period elapsed prior to completion of the