Multiple Server Query Execution in SQL Server 2008

re: Multiple Server Query Execution in SQL Server 2008

Andrew Lockwood — Thu, 07 Feb 2008 19:06:24 GMT

I just wanted to say thanks for this! I've been playing around with the November CTP and I found this feature by mistake. It's AWESOME for planning upgrades to servers when you need to include steps for checking db online/offline status, build levels, etc.

The only thing I'd request is that give us an option to manually select one or more target servers from the registered server list with a ctrl-click / shift-click style (like a multi-select drop down list...)

Cheers!

re: Multiple Server Query Execution in SQL Server 2008

Srinivasan Balram — Wed, 13 Feb 2008 12:38:46 GMT

this is a fantastic feature from a scalability perspective --- a sample showing how to connect from a C# app would be quite helpful -- also some details on how it would fit within overall MARS framework

re: Multiple Server Query Execution in SQL Server 2008

Prasanna Prabhu — Thu, 14 Aug 2008 19:57:10 GMT

1. Will it be smart enough to alert us if one of the server is already overloaded so NOT TO run the query

2. What if one of the server in DOWN (for some reason) will it execute the Query on rest of the queries?

3. In this blog, if you could POST an image of what the result looks like (for a simple SELECT Query) if executed on multiple servers, that would be great. I wanted to see if the result displays the server name

re: Multiple Server Query Execution in SQL Server 2008

Prasanna Prabhu — Thu, 14 Aug 2008 19:58:40 GMT

Is there an COMMAND like option for this feature, such that we execute it & result can be emailed

re: Multiple Server Query Execution in SQL Server 2008

Prasanna Prabhu — Thu, 14 Aug 2008 20:00:58 GMT

Blogs like these are really great.

If you could provide some SAMPLE Code (or pointer to it) that is most commonly used within Microsoft Team for your testing the applications, that can be helpful too, whereby this page can become the START POINT (for all of us) who is looking for this feature of SQL Server :)

re: Multiple Server Query Execution in SQL Server 2008

sacker — Wed, 12 Nov 2008 20:08:43 GMT

I'm gathering that multiple server queries can only be run on common databases across servers (master, msdb, etc.), correct? We have the need to run the same query on differently named databases across servers. If we could have a way of selecting the databases on each server to run against, that would save our team week (possibly months) of time per year.

Top 10 SQL Server 2008 Features for the Database Administrator (DBA)

Top 10 Lists — Sat, 31 Jan 2009 03:18:00 GMT

Author: Mike Weiner Contributor: Burzin Patel Reviewers: Lubor Kollar, Kevin Cox, Bill Emmert, Greg Husemeier