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 |
|
LacOniC
Starting Member
29 Posts |
 Posted - 2007-10-05 : 04:25:27
|
| I have a Stored Procedure that execute some queries on link server. It takes so long to complete so my application get timeout error. There was no problem until last week. I suspect, remote queries that qorks on link server takes long. How can i trace the time of queries. Any idea about link server timeout problems?Thanks in advance. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-05 : 08:21:23
|
| Some ideas might be missing indices and statistics not being updated.It is possible without proper maintenace that performance decreases after a period time.Are you actually connecting to the remote server? Can you verify you can ?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Tracing Query Time