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 |
|
ksachinsoni
Starting Member
4 Posts |
 Posted - 2009-09-01 : 07:11:36
|
| hello friends,i have an application which was connected on database on sqlserver 2005, it used to work gud.wen i used to fetch data more it used to come after taking some time. but when migrated our database on sqlserver 2008, it works gud but when i fetch more data it shows timeout error exactly after 30 seconds.i m not getting exact problem and its solution. please anybody help me thanks in advance |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-09-01 : 07:27:51
|
| 1. Tell us about the approach you are using to retrieve data i.e. SSIS, Stored Proc, dynamic sql, front-end application code etc.2. Seems to me like there needs some kind of performance tuning to the queries you are using to fetch the data3. If it is timing out exactly after 30 seconds, check whether you have set query timeout either in SQL server or in the connection string if you are connecting from front-end.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
time out + sqlserver 2008 + windows server 2008