Database Reference
In-Depth Information
NOTE
The DMS is not part of SQL Server; it is an entirely separate process.
When data needs to move across the appliance, DMS moves it. The
DMS exists on both the control and the compute nodes and is managed
by its own DMS Manager that resides on the control node.
The compute and control nodes are connected together by two networks:
Ethernet and Infiniband. The Ethernet network manages basic
communication between the nodes: heartbeat, status, acknowledgments,
that sort of thing. The Infiniband network is used for moving data.
Infiniband is an ultra-low-latency network, which is ideally suited for
moving large volumes of data at speed. PDW uses FDR Infiniband, which is
capable of sustaining 56Gbps.
When you connect your application, including SQL Server Data Tools
(SSDT), you will connect to the control node. The control node accepts
the request, generates the DSQL plan and orchestrates a series of highly
parallelized operations across the compute nodes, thus achieving scale out.
However, the real secret to how PDW works is down to how it creates
databases and tables.
Distributed Databases
Think about a piece of toast. That piece of toast is your PDW appliance. Now
what do you want to put on that toast? Butter and Marmite, of course!
I LOVE Marmite
For the international audience who might not understand the reference
Marmite is a vegetarian savoury spread made from yeast extract that is
itself a by-product of brewing beer. Please head over to
https://www.facebook.com/Marmite
for more details. Better still go
and try it! Unless you are in Denmark, of course, where it is
banned—only the Danes really understand why. Too bad; I know many
of them love it there, too.
