servers..

We have linked database servers using linked server feature. Is it a
resource intensive setting? Any one has any comments and their experiences
on this setup?
SQL 2K.
JoeHere's a WebCast that focuses on Linked Server configuration, usage, and
troubleshooting
(http://support.microsoft.com/defaul...kb;en-us;326839). It should
give you a good overview. The link itself isn't resource intensive however
at run time, depending how data is used across the link, it will have some
impact on the individual query involved as some JOINS may need to be staged
in TempDB before being resolved against local tables. You also need to
carefully consider the security implications of your Linked Server
definition. Not that there's any pure security issues per-se however like
any other tool, when not properly configured and then exposed for public
consumption it could leave you data wide open.
--Brian
(Please reply to the newsgroups only.)
"JoeMathew" <Joe_Mathew@.hotmail.com> wrote in message
news:ueGbMGZtFHA.2076@.TK2MSFTNGP14.phx.gbl...
> We have linked database servers using linked server feature. Is it a
> resource intensive setting? Any one has any comments and their experiences
> on this setup?
> SQL 2K.
> Joe
>