|
Home > Archive > MS SQL Server > February 2006 > Cached data from linked server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cached data from linked server
|
|
| John Mark Howell 2006-01-30, 1:23 pm |
| I've been able to verify that my SQL Server 2000 instance is caching data
from a linked Sybase server. The only way I've been able to flush the cache
is to drop and recreate the link. Does anyone else know how to get SQL
Server to either not cache the data or to periodically flush the cache.
As for the evidence, I have TLU fields that are updated and in Sybase the
latest TLU is from just moments ago, while the TLU when queried from SQL
Server via link is back from 1/24/06.
| |
| harvinder 2006-01-30, 8:23 pm |
| To flush the data, you can setup a job that will issue checkpoint every second.
"John Mark Howell" wrote:
> I've been able to verify that my SQL Server 2000 instance is caching data
> from a linked Sybase server. The only way I've been able to flush the cache
> is to drop and recreate the link. Does anyone else know how to get SQL
> Server to either not cache the data or to periodically flush the cache.
>
> As for the evidence, I have TLU fields that are updated and in Sybase the
> latest TLU is from just moments ago, while the TLU when queried from SQL
> Server via link is back from 1/24/06.
>
>
>
| |
| mark-howell@charter.net 2006-02-06, 8:23 pm |
| Sorry but that did not work. I opened a Query session to the SQL
Server containing the links and executed CHECKPOINT. But running a
query on one of the linked servers returned the old results. (I double
checked that the data existed by running the same query in DBArtisian).
Was there something else I was supposed to do?
harvinder wrote:
> To flush the data, you can setup a job that will issue checkpoint every second.
|
|
|
|
|