Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 102 of 212

90 C H A P T E R 5 | Broader data access Figure 5-9: PolyBase scale-out groups. After you install PolyBase on each SQL Server instance, the PolyBase instance is a head node by default. You must have one head node in the scale-out group and then use sp_polybase_join_group to transform the other instances to compute nodes, as shown in Example 5-28. The first parameter of this stored procedure is the computer name of the head node, the second parameter is the control channel port for the head node's data movement service, and the third parameter is the name of the SQL Server instance for the head node. The default port for the data movement service is 16450. After executing the stored procedure, restart the PolyBase engine and data movement services. Example 5-28: Adding a compute node to a PolyBase scale-out group -- Provide head node computer name, DMS port, and SQL Server instance as parameters EXEC sp_polybase_join_group 'MySQLServer', 16450, 'MSSQLSERVER'; Note To remove a compute node from a scale-out group, use sp_polybase_leave_group. It does not take any arguments. You must restart the PolyBase engine and data movement services afterward. You can confirm the configuration and status of compute nodes by using the following dynamic management views:

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016