April 6, 2016 at 9:39 pm
Hi ,
I just exploring how to do distributed query enabled in RDS SQl Server version. I know we can do it just AWS EC2 install SQL server. can any one give me reference or documents for that. Simple I need to execute single query with multiple instances through link server.
April 6, 2016 at 10:29 pm
I expected single SQL going through multiple instances execute through link server
April 7, 2016 at 7:04 am
A single query across multiple instances can be done many different ways (AWS or not).
You can look to Multi-Server Management utilities. You can do linked servers, but you're just going to have to call each one individually. You can use Powershell to run the query against a list of servers (or, with threading, all the servers at the same time). It's all about how you connect up and automate the running of the procs.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply