October 5, 2003 at 11:16 pm
Hi - I need to gain some better understanding about what SQL server 2000 does with Bulk queries and updates across a view that is partitioned and distributed across different servers.
In essence I need to know if it sends the same query to each server, lets them process in parallel, and then combines any any results as required. If so, then can I expect to double my performance of large bulk updates (and aggregation queries) if I partition a table across two servers?
For example If I have a Distributed view called CLIENT, that is parittioned on ClientID across two servers and I fire off:
SELECT ClientStatus,count(*)
FROM Client
GROUP BY ClientStatus
Will sql server send off this same query to both servers, so they process it on their slice of client data, then handle the merging of the two partial aggregations to give the overall aggregatations, in half the time it would take on a single server (less some small overhead)
Cheers,
Brendon.
Edited by - brendonsmith on 10/05/2003 11:20:13 PM
October 6, 2003 at 7:07 pm
SQL Server MVP Vyas Kondreddi has a couple of articles on federated databases on his website. Here's a link to one of them:
http://vyaskn.tripod.com/what_are_federated_databases.htm
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply