Skip to content

Commit fe158ff

Browse files
barbkessbarbkess
authored
Merge pull request MicrosoftDocs#346 from JimVance/sql-aps-20170110
Migrating APS topics
2 parents 652eba7 + 2b4ed85 commit fe158ff

13 files changed

Lines changed: 109 additions & 92 deletions

‎docs-msdn/analytics-platform-system/TOC.md‎

Lines changed: 22 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -7,6 +7,7 @@
77
## [Hardware configurations](hardware-configurations.md)
88
## [Processing and storage capacity](processing-and-storage-capacity-planning.md)
99
## [High availability](high-availability.md)
10+
1011
# Backup and loading hardware
1112
## [Overview](backup-and-loading-hardware.md)
1213
## [Acquire and configure a loading server](acquire-and-configure-loading-server.md)
@@ -15,9 +16,8 @@
1516
## [Backup server capacity planning worksheet](backup-capacity-planning-worksheet.md)
1617
## [Configure InfiniBand network adapters](configure-infiniband-network-adapters.md)
1718

18-
# Backup and restore
19-
## [Overview](backup-and-restore-overview.md)
20-
## [Restore a database protected by TDE](restore-database-protected-by-tde.md)
19+
# Query
20+
## [Monitoring active queries](monitoring-active-queries.md)
2121

2222
# Load
2323
## [Overview](load-overview.md)
@@ -29,14 +29,29 @@
2929
## [dwloader Command-line Loading Tool](dwloader.md)
3030
## [Monitor loads](monitor-loads.md)
3131

32-
# [Workload management](workload-management.md)
33-
## [Workload management tasks](workload-management-tasks.md)
32+
# Database administration
33+
## Backup and restore
34+
### [Overview](backup-and-restore-overview.md)
35+
### [Restore a database protected by TDE](restore-database-protected-by-tde.md)
36+
## [PDW permissions](pdw-permissions.md)
37+
### [Grant permissions](grant-permissions.md)
38+
## [Error messages](error-messages.md)
39+
## [Locking behavior](locking-behavior.md)
40+
## [Remote table copy](remote-table-copy.md)
41+
### [Configure an external Windows system to receive remote table copies using InfiniBand](configure-an-external-windows-system-to-receive-remote-table-copies-using-infiniband.md)
42+
### [Configure an external SMP SQL Server to receive remote table copies](configure-an-external-smp-sql-server-to-receive-remote-table-copies.md)
43+
### [Configure SQL Server PDW for remote table copies](configure-sql-server-pdw-for-remote-table-copies.md)
44+
## [System databases](system-databases.md)
45+
### [Reserved database names](reserved-database-names.md)
46+
### [tempdb database](tempdb-database.md)
47+
### [master database](master-database.md)
48+
## [User sessions](user-sessions.md)
49+
## [Workload management](workload-management.md)
50+
### [Workload management tasks](workload-management-tasks.md)
3451

3552
# Security
3653
## [Transparent Data Encryption](transparent-data-encryption.md)
3754
## [Provision a certificate](provision-certificate.md)
38-
## [PDW permissions](pdw-permissions.md)
39-
### [Grant permissions](grant-permissions.md)
4055

4156
# [Appliance mangement tasks](appliance-management-tasks.md)
4257
## [Appliance installation and configuration overview](appliance-installation-and-configuration-overview.md)

draft/mpp/sqlpdw/configure-an-external-smp-sql-server-to-receive-remote-table-copies-sql-server-pdw.md renamed to docs-msdn/analytics-platform-system/configure-an-external-smp-sql-server-to-receive-remote-table-copies.md

Lines changed: 7 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "Configure an External SMP SQL Server to Receive Remote Table Copies (SQL Server PDW)"
33
ms.custom: na
4-
ms.date: 07/27/2016
4+
ms.date: 01/13/2017
55
ms.reviewer: na
66
ms.suite: na
77
ms.tgt_pltfrm: na
@@ -10,15 +10,15 @@ ms.assetid: 6bbd2ed6-064e-4b45-b67b-608dc0f2b2bc
1010
caps.latest.revision: 13
1111
author: BarbKess
1212
---
13-
# Configure an External SMP SQL Server to Receive Remote Table Copies (SQL Server PDW)
13+
# Configure an External SMP SQL Server to Receive Remote Table Copies
1414
Describes how to configure an external SQL Server instance to receive remote table copies from SQL Server PDW.
1515

16-
This topic describes one of the configuration steps for configuring remote table copy. For a list of all the configuration steps, see [Remote Table Copy (SQL Server PDW)](../sqlpdw/remote-table-copy-sql-server-pdw.md)
16+
This topic describes one of the configuration steps for configuring remote table copy. For a list of all the configuration steps, see [Remote Table Copy](remote-table-copy.md).
1717

1818
## Before You Begin
1919
Before you can configure the external SQL Server, you must:
2020

21-
- Have a Windows system with SQL Server 2008 Enterprise Edition or a later version ready to be installed or already installed. The Windows system must already be configured according to the instructions in [Configure an External Windows System To Receive Remote Table Copies Using InfiniBand (SQL Server PDW)](../sqlpdw/configure-an-external-windows-system-to-receive-remote-table-copies-using-infiniband-sql-server-pdw.md)
21+
- Have a Windows system with SQL Server 2008 Enterprise Edition or a later version ready to be installed or already installed. The Windows system must already be configured according to the instructions in [Configure an External Windows System To Receive Remote Table Copies Using InfiniBand](configure-an-external-windows-system-to-receive-remote-table-copies-using-infiniband.md).
2222

2323
- A Windows admin account with the ability to configure the SQL Server instance and the Windows system.
2424

@@ -42,7 +42,7 @@ To configure SQL Server, use the following steps:
4242
## <a name="BPSQLConfig"></a>Best Practices for SMP SQL Server Configuration for Remote Table Copy
4343
When configuring the SMP SQL Server to receive remote table copies, use the following best practices to improve performance.
4444

45-
1. Follow best practices as documented in SQL Server product documentation. For example, enable data encryption. For more information about securing SQL Server, see [Securing SQL Server](http://msdn.microsoft.com/en-us/library/bb283235(v=sql11).aspx) on MSDN.
45+
1. Follow best practices as documented in SQL Server product documentation. For example, enable data encryption. For more information about securing SQL Server, see [Securing SQL Server](https://msdn.microsoft.com/library/bb283235.aspx) on MSDN.
4646

4747
2. Use the bulk-logged or simple recovery model.
4848

@@ -52,6 +52,8 @@ When configuring the SMP SQL Server to receive remote table copies, use the foll
5252

5353
Although the bulk-logged or simple recovery models use minimal logging for the bulk inserted data, some logging still occurs. To prevent the log files from growing too large, use the SQL Server batch_size option to periodically reclaim log space.
5454

55+
<!-- MISSING LINKS
5556
## See Also
5657
[Common Metadata Query Examples &#40;SQL Server PDW&#41;](../sqlpdw/common-metadata-query-examples-sql-server-pdw.md)
58+
-->
5759

draft/mpp/sqlpdw/configure-an-external-windows-system-to-receive-remote-table-copies-using-infiniband-sql-server-pdw.md renamed to docs-msdn/analytics-platform-system/configure-an-external-windows-system-to-receive-remote-table-copies-using-infiniband.md

Lines changed: 5 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "Configure an External Windows System To Receive Remote Table Copies Using InfiniBand (SQL Server PDW)"
33
ms.custom: na
4-
ms.date: 07/27/2016
4+
ms.date: 01/13/2017
55
ms.reviewer: na
66
ms.suite: na
77
ms.tgt_pltfrm: na
@@ -10,13 +10,13 @@ ms.assetid: f866890b-cad5-49ac-bbeb-848bfb26c2d5
1010
caps.latest.revision: 11
1111
author: BarbKess
1212
---
13-
# Configure an External Windows System To Receive Remote Table Copies Using InfiniBand (SQL Server PDW)
13+
# Configure an External Windows System To Receive Remote Table Copies Using InfiniBand
1414
Describes how to purchase and configure a non-appliance Windows system connected using the InfiniBand network for use with the remote table copy feature in SQL Server PDW. The Windows system will host the SQL Server database that receives the remote table copy from a SQL Server PDW database. It is purchased separately from the appliance and connected to the appliance InfiniBand network.
1515

1616
> [!NOTE]
1717
> Connecting through the InfiniBand network is not required for using remote table copy. Connecting through the Ethernet network can be done if the Ethernet bandwidth meets your needs.
1818
19-
This topic describes one of the configuration steps for configuring remote table copy. For a list of all the configuration steps, see [Remote Table Copy &#40;SQL Server PDW&#41;](../sqlpdw/remote-table-copy-sql-server-pdw.md)
19+
This topic describes one of the configuration steps for configuring remote table copy. For a list of all the configuration steps, see [Remote Table Copy](remote-table-copy.md)
2020

2121
## Before You Begin
2222
Before you configure the external Windows system, you must:
@@ -56,6 +56,8 @@ To configure the external Windows system, use the following steps:
5656

5757
5. If a two port adapter is used, or multiple external Windows systems are connected to an appliance, assign each system a different host number within each IP subnet.
5858

59+
<!-- MISSING LINKS
5960
## See Also
6061
[Common Metadata Query Examples &#40;SQL Server PDW&#41;](../sqlpdw/common-metadata-query-examples-sql-server-pdw.md)
62+
-->
6163

draft/mpp/sqlpdw/configure-sql-server-pdw-for-remote-table-copies-sql-server-pdw.md renamed to docs-msdn/analytics-platform-system/configure-sql-server-pdw-for-remote-table-copies.md

Lines changed: 8 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "Configure SQL Server PDW for Remote Table Copies (SQL Server PDW)"
33
ms.custom: na
4-
ms.date: 07/27/2016
4+
ms.date: 01/13/2017
55
ms.reviewer: na
66
ms.suite: na
77
ms.tgt_pltfrm: na
@@ -10,10 +10,10 @@ ms.assetid: 496b4214-5891-404c-8237-c2a1e09db6d5
1010
caps.latest.revision: 11
1111
author: BarbKess
1212
---
13-
# Configure SQL Server PDW for Remote Table Copies (SQL Server PDW)
13+
# Configure SQL Server PDW for Remote Table Copies
1414
Describes how to configure SQL Server PDW to use the remote table copy feature to copy tables to SMP SQL Server databases on non-appliance servers.
1515

16-
This topic describes one of the configuration steps for configuring remote table copy. For a list of all the configuration steps, see [Remote Table Copy &#40;SQL Server PDW&#41;](../sqlpdw/remote-table-copy-sql-server-pdw.md)
16+
This topic describes one of the configuration steps for configuring remote table copy. For a list of all the configuration steps, see [Remote Table Copy](remote-table-copy.md).
1717

1818
## Before You Begin
1919
In order to configure SQL Server PDW to use remote table copy, you must:
@@ -34,7 +34,11 @@ The following steps outline how to update the DNS server.
3434
3. Use the DNS Manager to add the IP name.
3535

3636
## See Also
37+
<!-- MISSING LINKS
3738
[Common Metadata Query Examples &#40;SQL Server PDW&#41;](../sqlpdw/common-metadata-query-examples-sql-server-pdw.md)
38-
[Use a DNS Forwarder to Resolve Non-Appliance DNS Names &#40;Analytics Platform System&#41;](../management/use-a-dns-forwarder-to-resolve-non-appliance-dns-names-analytics-platform-system.md)
39+
-->
40+
[Use a DNS Forwarder to Resolve Non-Appliance DNS Names](use-a-dns-forwarder-to-resolve-non-appliance-dns-names.md)
41+
<!-- MISSING LINKS
3942
[Security - Configure Domain Trusts &#40;SQL Server PDW&#41;](../sqlpdw/security-configure-domain-trusts-sql-server-pdw.md)
43+
-->
4044

draft/mpp/sqlpdw/error-messages-sql-server-pdw.md renamed to docs-msdn/analytics-platform-system/error-messages.md

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "Error Messages (SQL Server PDW)"
33
ms.custom: na
4-
ms.date: 07/27/2016
4+
ms.date: 01/13/2017
55
ms.reviewer: na
66
ms.suite: na
77
ms.tgt_pltfrm: na
@@ -10,7 +10,7 @@ ms.assetid: e6223cba-2dec-4b8a-bc10-e2ef6a821fe0
1010
caps.latest.revision: 9
1111
author: BarbKess
1212
---
13-
# Error Messages (SQL Server PDW)
13+
# Error Messages
1414
SQL Server PDW error messages report errors and problems encountered by the SQL Server PDW components and can also include SQL Server errors surfaced through SQL Server PDW. These error messages use a consistent syntax for presenting information. Understanding this syntax will allow you to identify and correct problems on SQL Server PDW.
1515

1616
## <a name="Basics"></a>Error Message Basics
@@ -27,14 +27,16 @@ These are the potential values for each field:
2727
|*Error_Indicator*|The word “ERROR” or other text alerting the user to a problem.|ERROR|
2828
|*SQL_State_Code*|The SQL state code, according to ODBC specification. The driver generates the appropriate SQL State code any time it returns a message to an application. The text “Microsoft” indicates the source of the error.|42000|
2929
|*Driver_Details*|Driver-dependent details, such as the type of driver used.|ODBC SQL Server 2008 R2 Parallel Data Warehouse driver|
30-
|*QueryID*|The unique identifier for the query. Use this value to find additional information related to processing of the query. For example, the query execution details can be found in the Admin Console using the query ID. For more information, see [Monitor the Appliance by Using the Admin Console &#40;Analytics Platform System&#41;](../management/monitor-the-appliance-by-using-the-admin-console-analytics-platform-system.md).<br /><br />If a QueryID is not applicable, the text “Internal” is returned to the user.|QID2377|
30+
|*QueryID*|The unique identifier for the query. Use this value to find additional information related to processing of the query. For example, the query execution details can be found in the Admin Console using the query ID. For more information, see [Monitor the Appliance by Using the Admin Console](monitor-the-appliance-by-using-the-admin-console.md).<br /><br />If a QueryID is not applicable, the text “Internal” is returned to the user.|QID2377|
3131
|*Message_String*|A human-readable description of the error or problem. When returning SQL Server errors, this is the SQL Server message text.|Only equal assignment can appear in the set list of an UPDATE statement.|
3232

3333
These example values would be presented to the user like this:
3434

3535
`ERROR [42000] [Microsoft][ODBC SQL Server 2008 R2 Parallel Data Warehouse driver][QID2380]Only equal assignment can appear in the set list of an UPDATE statement.`
3636

3737
## See Also
38+
<!-- MISSING LINKS
3839
[Common Metadata Query Examples &#40;SQL Server PDW&#41;](../sqlpdw/common-metadata-query-examples-sql-server-pdw.md)
39-
[Understanding Admin Console Alerts &#40;Analytics Platform System&#41;](../management/understanding-admin-console-alerts-analytics-platform-system.md)
40+
-->
41+
[Understanding Admin Console Alerts](understanding-admin-console-alerts.md)
4042

draft/mpp/sqlpdw/locking-behavior-sql-server-pdw.md renamed to docs-msdn/analytics-platform-system/locking-behavior.md

Lines changed: 7 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "Locking Behavior (SQL Server PDW)"
33
ms.custom: na
4-
ms.date: 07/27/2016
4+
ms.date: 01/13/2017
55
ms.reviewer: na
66
ms.suite: na
77
ms.tgt_pltfrm: na
@@ -10,15 +10,9 @@ ms.assetid: c55c636e-b767-4a0c-8184-be991a10801f
1010
caps.latest.revision: 27
1111
author: BarbKess
1212
---
13-
# Locking Behavior (SQL Server PDW)
13+
# Locking Behavior
1414
SQL Server PDW uses locking to ensure the integrity of transactions and to maintain the consistency of databases when multiple users are accessing data at the same time.
1515

16-
## <a name="Contents"></a>Contents
17-
18-
- [Basics](#Basics)
19-
20-
- [General Remarks](#Remarks)
21-
2216
## <a name="Basics"></a>Locking Basics
2317
**Modes**
2418

@@ -38,7 +32,7 @@ The SharedUpdate lock prohibits Exclusive and ExclusiveUpdate lock modes and all
3832

3933
**Resource Classes**
4034

41-
Locks are held on the following classes of objects: DATABASE, SCHEMA, OBJECT (a table, view, or procedure), APPLICATION (used internally), EXTERNALDATASOURCE, EXTERNALFILEFORMAT AND SCHEMARESOLUTION (a database level lock taken while creating, altering, or dropping schema objects or database users). These object classes can appear in the object_type column of [sys.dm_pdw_waits](../sqlpdw/sys-dm-pdw-waits-sql-server-pdw.md).
35+
Locks are held on the following classes of objects: DATABASE, SCHEMA, OBJECT (a table, view, or procedure), APPLICATION (used internally), EXTERNALDATASOURCE, EXTERNALFILEFORMAT AND SCHEMARESOLUTION (a database level lock taken while creating, altering, or dropping schema objects or database users). These object classes can appear in the object_type column of [sys.dm_pdw_waits](https://msdn.microsoft.com/library/mt203893.aspx).
4236

4337
## <a name="Remarks"></a>General Remarks
4438
Locks can be applied to databases, tables, or views.
@@ -48,7 +42,7 @@ SQL Server PDW does not implement any configurable isolation levels. It supports
4842
SQL Server PDW relies on the underlying SQL Server engine to implement locking and concurrency control. If operations lead to an underlying SQL Server deadlock within the same node, SQL Server PDW leverages the SQL Server deadlock detection capability and terminates one of the blocking statements.
4943

5044
> [!NOTE]
51-
> SQL Server does not allow statements that are waiting for locks to be blocked by newer lock requests. SQL Server PDW has not fully implemented this process. In SQL Server PDW, continuous requests for new shared locks can sometimes block a previous (but waiting) request for an exclusive lock. For example, an **UPDATE** statement (requiring an exclusive lock) can be blocked by shared locks that are granted for series of **SELECT** statements. To resolve a blocked process (identified by reviewing the [sys.dm_pdw_waits &#40;SQL Server PDW&#41;](../sqlpdw/sys-dm-pdw-waits-sql-server-pdw.md) DVM), stop submitting new requests until the exclusive lock has been satisfied.
45+
> SQL Server does not allow statements that are waiting for locks to be blocked by newer lock requests. SQL Server PDW has not fully implemented this process. In SQL Server PDW, continuous requests for new shared locks can sometimes block a previous (but waiting) request for an exclusive lock. For example, an **UPDATE** statement (requiring an exclusive lock) can be blocked by shared locks that are granted for series of **SELECT** statements. To resolve a blocked process (identified by reviewing the [sys.dm_pdw_waits](https://msdn.microsoft.com/library/mt203893.aspx) DVM), stop submitting new requests until the exclusive lock has been satisfied.
5246
5347
## Lock Definition Table
5448
SQL Server supports the following types of locks. Not all lock types are available on the control node, but could occur on the compute nodes.
@@ -96,6 +90,8 @@ SQL Server supports the following types of locks. Not all lock types are availab
9690
- RangeX_X (Exclusive Key-Range and Exclusive Resource lock). This is a conversion lock used when updating a key in a range.
9791

9892
## See Also
93+
<!-- MISSING LINKS
9994
[Common Metadata Query Examples &#40;SQL Server PDW&#41;](../sqlpdw/common-metadata-query-examples-sql-server-pdw.md)
100-
[sys.dm_pdw_waits &#40;SQL Server PDW&#41;](../sqlpdw/sys-dm-pdw-waits-sql-server-pdw.md)
95+
-->
96+
[sys.dm_pdw_waits](https://msdn.microsoft.com/library/mt203893.aspx)
10197

draft/mpp/sqlpdw/master-database-sql-server-pdw.md renamed to docs-msdn/analytics-platform-system/master-database.md

Lines changed: 7 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "master Database (SQL Server PDW)"
33
ms.custom: na
4-
ms.date: 07/27/2016
4+
ms.date: 01/13/2017
55
ms.reviewer: na
66
ms.suite: na
77
ms.tgt_pltfrm: na
@@ -10,10 +10,10 @@ ms.assetid: c71617c0-6689-4f52-81c6-58f4cf7c7377
1010
caps.latest.revision: 8
1111
author: BarbKess
1212
---
13-
# master Database (SQL Server PDW)
13+
# master Database
1414
The SQL Server PDW master database stores appliance-level login information and the database catalog. It is a SQL Server master database that resides on the Control node. As such, it provides similar functionality to SQL Server PDW as master provides to SQL Server.
1515

16-
For more information about system databases, see [System Databases &#40;SQL Server PDW&#41;](../sqlpdw/system-databases-sql-server-pdw.md)
16+
For more information about system databases, see [System Databases](system-databases.md).
1717

1818
## Limitations and Restrictions
1919
The following list describes the operations you cannot perform on the SQL Server PDW master database.
@@ -38,11 +38,13 @@ You *cannot:*
3838

3939
|Task|Description|
4040
|--------|---------------|
41-
|Create a full backup of master.|Example:<br /><br />`BACKUP DATABASE master TO backup_directory;`<br /><br />For more information, see [BACKUP DATABASE &#40;SQL Server PDW&#41;](../sqlpdw/backup-database-sql-server-pdw.md).|
42-
|Restore the master database|To restore the master database, use the [Restore the Master Database &#40;Analytics Platform System&#41;](../management/restore-the-master-database-analytics-platform-system.md) page in the Configuration Manager tool.|
41+
|Create a full backup of master.|Example:<br /><br />`BACKUP DATABASE master TO backup_directory;`<br /><br />For more information, see [BACKUP DATABASE](https://msdn.microsoft.com/library/mt631607.aspx).|
42+
|Restore the master database|To restore the master database, use the [Restore the Master Database](restore-the-master-database.md) page in the Configuration Manager tool.|
4343
|View database catalog information.|`SELECT * FROM master.sys.databases;`|
4444
|View system-wide login and permission information.|`SELECT * FROM master.sys.server_permissions;`<br /><br />`SELECT * FROM master.sys.server_principals;`<br /><br />`SELECT * FROM master.sys.sql_logins;`|
4545

46+
<!-- MISSING LINKS
4647
## See Also
4748
[Common Metadata Query Examples &#40;SQL Server PDW&#41;](../sqlpdw/common-metadata-query-examples-sql-server-pdw.md)
49+
-->
4850

0 commit comments

Comments
 (0)