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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2013-03-12 : 15:37:24
|
| Hi,We have linked server in sql server from AS400. From last couple of days it shows connection between sql server and As400 through this linked server is slow. Sometimes application timeout. How to resolve this issue? How to find out if issue is at sql server side or as400? or how to improve query response time through this linked server.thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-13 : 00:27:35
|
| you need to increase the timeout setting value in app config file. Also try if you could optimize the query from AS400 so that it becomes faster------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Application timeout