Can I shift the stress of SQL processing using a linked server?

I often need to run intensive queries against our live database but
this affects the performance of the system while the queries are
executing so I'm looking for a way to shift the processing to another
server. I have tried creating a linked server on my local PC pointing
at the live DB but it seems to stress both servers. Does anybody have
any suggestions how I can achieve this?
Thanks,
LiamCan you create a refreshable replica of your Live DB. Quite often reporting
requirements cause this kind of impact. We replicate our live databases to
reporting servers for just this purpose.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Liam Weston" <liam_weston@.hotmail.com> wrote in message
news:5f9a8c3b.0308200334.7a43ef56@.posting.google.com...
> I often need to run intensive queries against our live database but
> this affects the performance of the system while the queries are
> executing so I'm looking for a way to shift the processing to another
> server. I have tried creating a linked server on my local PC pointing
> at the live DB but it seems to stress both servers. Does anybody have
> any suggestions how I can achieve this?
> Thanks,
> Liam|||Linked servers are not of use in your scenario since the server where the
data lives still has to do a substantial, if not majority, of the work. The
solution you want is to take a copy of the data to another machine to do
your reporting. There are numerous strategies for doing this depending on
your exact scenario. Replication, Log Shipping, or simply backing up and
restoring the database on another server are all potential solutions.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Liam Weston" <liam_weston@.hotmail.com> wrote in message
news:5f9a8c3b.0308200334.7a43ef56@.posting.google.com...
> I often need to run intensive queries against our live database but
> this affects the performance of the system while the queries are
> executing so I'm looking for a way to shift the processing to another
> server. I have tried creating a linked server on my local PC pointing
> at the live DB but it seems to stress both servers. Does anybody have
> any suggestions how I can achieve this?
> Thanks,
> Liam|||Allan,
I plan to implement replication in the coming months and this would
certainly solve the problem. In the short term I can extract data to a
different server 'out of hours' but I was looking for a way of running
queries during peak times at short notice.
Thanks,
Liam