Skip to content

Commit db2f610

Browse files
huypubhuypub
authored
Merge pull request #19458 from MicrosoftDocs/master
6/02 AM Publish
2 parents e3644d9 + 11f2606 commit db2f610

53 files changed

Lines changed: 189 additions & 96 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/relational-databases/system-dynamic-management-views/sys-dm-io-virtual-file-stats-transact-sql.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -20,15 +20,15 @@ helpviewer_keywords:
2020
ms.assetid: fa3e321f-6fe5-45ff-b397-02a0dd3d6b7d
2121
author: WilliamDAssafMSFT
2222
ms.author: wiassaf
23-
monikerRange: "=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
23+
monikerRange: "=azuresqldb-current||=azure-sqldw-latest||>= aps-pdw-2016||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
2424
---
2525
# sys.dm_io_virtual_file_stats (Transact-SQL)
26-
[!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa.md)]
26+
[!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
2727

2828
Returns I/O statistics for data and log files. This dynamic management function replaces the [fn_virtualfilestats](../../relational-databases/system-functions/sys-fn-virtualfilestats-transact-sql.md) function.
2929

3030
> [!NOTE]
31-
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)], use the name **sys.dm_pdw_nodes_io_virtual_file_stats**.
31+
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)], use the name **sys.dm_pdw_nodes_io_virtual_file_stats**. [!INCLUDE[synapse-analytics-od-unsupported-syntax](../../includes/synapse-analytics-od-unsupported-syntax.md)]
3232
3333
## Syntax
3434

‎docs/relational-databases/system-dynamic-management-views/sys-dm-operation-status-azure-sql-database.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,11 +19,11 @@ helpviewer_keywords:
1919
ms.assetid: cc847784-7f61-4c69-8b78-5f971bb24d61
2020
author: WilliamDAssafMSFT
2121
ms.author: wiassaf
22-
monikerRange: "= azuresqldb-current || = azure-sqldw-latest"
22+
monikerRange: "= azuresqldb-current"
2323
---
2424
# sys.dm_operation_status
2525

26-
[!INCLUDE [asdb-asdbmi-asa](../../includes/applies-to-version/asdb-asdbmi-asa.md)]
26+
[!INCLUDE [asdb-asdbmi](../../includes/applies-to-version/asdb-asdbmi.md)]
2727

2828
Returns information about operations performed on databases in a [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)] server.
2929

‎docs/relational-databases/system-dynamic-management-views/sys-dm-os-buffer-descriptors-transact-sql.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -20,16 +20,16 @@ helpviewer_keywords:
2020
ms.assetid: 012aab95-8888-4f35-9ea3-b5dff6e3f60f
2121
author: WilliamDAssafMSFT
2222
ms.author: wiassaf
23-
monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
23+
monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current|| >= aps-pdw-2016 || = azure-sqldw-latest"
2424
---
2525
# sys.dm_os_buffer_descriptors (Transact-SQL)
26-
[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
26+
[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb-asa-pdw.md)]
2727

2828
Returns information about all the data pages that are currently in the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] buffer pool. The output of this view can be used to determine the distribution of database pages in the buffer pool according to database, object, or type. In [!INCLUDE[ssnoversion](../../includes/ssnoversion-md.md)], this dynamic management view also returns information about the data pages in the buffer pool extension file. For more information, see [Buffer Pool Extension](../../database-engine/configure-windows/buffer-pool-extension.md).
2929

3030
When a data page is read from disk, the page is copied into the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] buffer pool and cached for reuse. Each cached data page has one buffer descriptor. Buffer descriptors uniquely identify each data page that is currently cached in an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. sys.dm_os_buffer_descriptors returns cached pages for all user and system databases. This includes pages that are associated with the Resource database.
3131

32-
> **NOTE:** To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_buffer_descriptors**.
32+
> **NOTE:** To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_buffer_descriptors**. [!INCLUDE[synapse-analytics-od-unsupported-syntax](../../includes/synapse-analytics-od-unsupported-syntax.md)]
3333
3434
|Column name|Data type|Description|
3535
|-----------------|---------------|-----------------|

‎docs/relational-databases/system-dynamic-management-views/sys-dm-os-child-instances-transact-sql.md‎

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -21,9 +21,10 @@ helpviewer_keywords:
2121
ms.assetid: 1bef3074-0ccc-48fa-8f3d-14f3d99df86b
2222
author: WilliamDAssafMSFT
2323
ms.author: wiassaf
24+
monikerRange: ">= sql-server-2016 || >= sql-server-linux-2017|| >= aps-pdw-2016 || = azure-sqldw-latest"
2425
---
2526
# sys.dm_os_child_instances (Transact-SQL)
26-
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
27+
[!INCLUDE [sql-asa-pdw](../../includes/applies-to-version/sql-asa-pdw.md)]
2728

2829
Returns a row for each user instance that has been created from the parent server instance.
2930

@@ -32,8 +33,8 @@ ms.author: wiassaf
3233
The information returned from **sys.dm_os_child_instances** can be used to determine the state of each User Instance (heart_beat) and to obtain the pipe name (instance_pipe_name) that can be used to create a connection to the User Instance using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or SQLCmd. You can only connect to a User Instance after it has been started by an external process, such as a client application. SQL management tools cannot start a User Instance.
3334

3435
> **NOTE:** User Instances are a feature of [!INCLUDE[ssExpressEd11](../../includes/ssexpressed11-md.md)] only.
35-
>
36-
> **NOTE** To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_child_instances**.
36+
37+
> **NOTE** To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_child_instances**. [!INCLUDE[synapse-analytics-od-unsupported-syntax](../../includes/synapse-analytics-od-unsupported-syntax.md)]
3738
3839
|Column|Data type|Description|
3940
|------------|---------------|-----------------|

‎docs/relational-databases/system-dynamic-management-views/sys-dm-os-cluster-nodes-transact-sql.md‎

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -19,13 +19,14 @@ helpviewer_keywords:
1919
ms.assetid: 92fa804e-2d08-42c6-a36f-9791544b1d42
2020
author: WilliamDAssafMSFT
2121
ms.author: wiassaf
22+
monikerRange: ">= sql-server-2016 || >= sql-server-linux-2017|| >= aps-pdw-2016 || = azure-sqldw-latest"
2223
---
2324
# sys.dm_os_cluster_nodes (Transact-SQL)
24-
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
25+
[!INCLUDE [sql-asa-pdw](../../includes/applies-to-version/sql-asa-pdw.md)]
2526

26-
Returns one row for each node in the failover cluster instance configuration. If the current instance is a failover clustered instance, it returns a list of nodes on which this failover cluster instance (formerly "virtual server") has been defined. If the current server instance is not a failover clustered instance, it returns an empty rowset.
27+
Returns one row for each node in the failover cluster instance configuration. If the current instance is a failover clustered instance, it returns a list of nodes on which this failover cluster instance (formerly "virtual server") has been defined. If the current server instance is not a failover clustered instance, it returns an empty rowset.
2728

28-
> **NOTE:** To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_cluster_nodes**.
29+
> **NOTE:** To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_cluster_nodes**. [!INCLUDE[synapse-analytics-od-unsupported-syntax](../../includes/synapse-analytics-od-unsupported-syntax.md)]
2930
3031
|Column name|Data type|Description|
3132
|-----------------|---------------|-----------------|

‎docs/relational-databases/system-dynamic-management-views/sys-dm-os-dispatcher-pools-transact-sql.md‎

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -20,14 +20,15 @@ helpviewer_keywords:
2020
ms.assetid: b9edbc83-c6bc-4753-9bb5-a454cfe7d6bf
2121
author: WilliamDAssafMSFT
2222
ms.author: wiassaf
23+
monikerRange: ">= sql-server-2016 || >= sql-server-linux-2017|| >= aps-pdw-2016 || = azure-sqldw-latest"
2324
---
2425
# sys.dm_os_dispatcher_pools (Transact-SQL)
25-
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
26+
[!INCLUDE [sql-asa-pdw](../../includes/applies-to-version/sql-asa-pdw.md)]
2627

27-
Returns information about session dispatcher pools. Dispatcher pools are thread pools used by system components to perform background processing.
28+
Returns information about session dispatcher pools. Dispatcher pools are thread pools used by system components to perform background processing.
2829

2930
> [!NOTE]
30-
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_dispatcher_pools**.
31+
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_dispatcher_pools**. [!INCLUDE[synapse-analytics-od-unsupported-syntax](../../includes/synapse-analytics-od-unsupported-syntax.md)]
3132
3233
|Column name|Data type|Description|
3334
|-----------------|---------------|-----------------|

‎docs/relational-databases/system-dynamic-management-views/sys-dm-os-hosts-transact-sql.md‎

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,14 +19,15 @@ helpviewer_keywords:
1919
ms.assetid: a313ff3b-1fe9-421e-b94b-cea19c43b0e5
2020
author: WilliamDAssafMSFT
2121
ms.author: wiassaf
22+
monikerRange: ">= sql-server-2016 || >= sql-server-linux-2017|| >= aps-pdw-2016 || = azure-sqldw-latest"
2223
---
2324
# sys.dm_os_hosts (Transact-SQL)
24-
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
25+
[!INCLUDE [sql-asa-pdw](../../includes/applies-to-version/sql-asa-pdw.md)]
2526

2627
Returns all the hosts currently registered in an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. This view also returns the resources that are used by these hosts.
2728

2829
> [!NOTE]
29-
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_hosts**.
30+
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_hosts**. [!INCLUDE[synapse-analytics-od-unsupported-syntax](../../includes/synapse-analytics-od-unsupported-syntax.md)]
3031
3132
|Column name|Data type|Description|
3233
|-----------------|---------------|-----------------|

‎docs/relational-databases/system-dynamic-management-views/sys-dm-os-latch-stats-transact-sql.md‎

Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -19,14 +19,15 @@ helpviewer_keywords:
1919
ms.assetid: 2085d9fc-828c-453e-82ec-b54ed8347ae5
2020
author: WilliamDAssafMSFT
2121
ms.author: wiassaf
22+
monikerRange: ">= sql-server-2016 || >= sql-server-linux-2017||=azuresqldb-current|| >= aps-pdw-2016||= azure-sqldw-latest"
2223
---
2324
# sys.dm_os_latch_stats (Transact-SQL)
24-
[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
25+
[!INCLUDE [sql-asdb-asa-pdw](../../includes/applies-to-version/sql-asdb-asa-pdw.md)]
2526

2627
Returns information about all latch waits organized by class.
2728

2829
> [!NOTE]
29-
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_latch_stats**.
30+
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_latch_stats**. [!INCLUDE[synapse-analytics-od-unsupported-syntax](../../includes/synapse-analytics-od-unsupported-syntax.md)]
3031
3132
|Column name|Data type|Description|
3233
|-----------------|---------------|-----------------|
@@ -70,7 +71,7 @@ GO
7071
|Latch class|Description|
7172
|-----------------|-----------------|
7273
|ALLOC_CREATE_RINGBUF|Used internally by [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to initialize the synchronization of the creation of an allocation ring buffer.|
73-
|ALLOC_CREATE_FREESPACE_CACHE|Used to initialize the synchronization of internal freespace caches for heaps.|
74+
|ALLOC_CREATE_FREESPACE_CACHE|Used to initialize the synchronization of internal free space caches for heaps.|
7475
|ALLOC_CACHE_MANAGER|Used to synchronize internal coherency tests.|
7576
|ALLOC_FREESPACE_CACHE|Used to synchronize the access to a cache of pages with available space for heaps and binary large objects (BLOBs). Contention on latches of this class can occur when multiple connections try to insert rows into a heap or BLOB at the same time. You can reduce this contention by partitioning the object. Each partition has its own latch. Partitioning will distribute the inserts across multiple latches.|
7677
|ALLOC_EXTENT_CACHE|Used to synchronize the access to a cache of extents that contains pages that are not allocated. Contention on latches of this class can occur when multiple connections try to allocate data pages in the same allocation unit at the same time. This contention can be reduced by partitioning the object of which this allocation unit is a part.|
@@ -159,7 +160,7 @@ GO
159160
|SERVICE_BROKER_MAP_MANAGER|Internal use only.|
160161
|SERVICE_BROKER_HOST_NAME|Internal use only.|
161162
|SERVICE_BROKER_READ_CACHE|Internal use only.|
162-
|SERVICE_BROKER_WAITFOR_MANAGER| Used to synchronize an instance level map of waiter queues. One queue exists per database ID, Database Version, and Queue ID tuple. Contention on latches of this class can occur when many connections are: In a WAITFOR(RECEIVE) wait state; calling WAITFOR(RECEIVE); exceeding the WAITFOR timeout; receiving a message; committing or rolling back the transaction that contains the WAITFOR(RECEIVE); You can reduce the contention by reducing the number of threads in a WAITFOR(RECEIVE) wait state. |
163+
|SERVICE_BROKER_WAITFOR_MANAGER| Used to synchronize an instance level map of wait queues. One queue exists per database ID, Database Version, and Queue ID tuple. Contention on latches of this class can occur when many connections are: In a WAITFOR(RECEIVE) wait state; calling WAITFOR(RECEIVE); exceeding the WAITFOR timeout; receiving a message; committing or rolling back the transaction that contains the WAITFOR(RECEIVE); You can reduce the contention by reducing the number of threads in a WAITFOR(RECEIVE) wait state. |
163164
|SERVICE_BROKER_WAITFOR_TRANSACTION_DATA|Internal use only.|
164165
|SERVICE_BROKER_TRANSMISSION_TRANSACTION_DATA|Internal use only.|
165166
|SERVICE_BROKER_TRANSPORT|Internal use only.|

‎docs/relational-databases/system-dynamic-management-views/sys-dm-os-loaded-modules-transact-sql.md‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -19,9 +19,10 @@ helpviewer_keywords:
1919
ms.assetid: 56c7743a-b568-4943-bd3b-73c57d9d641c
2020
author: WilliamDAssafMSFT
2121
ms.author: wiassaf
22+
monikerRange: ">= sql-server-2016 || >= sql-server-linux-2017|| >= aps-pdw-2016"
2223
---
2324
# sys.dm_os_loaded_modules (Transact-SQL)
24-
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
25+
[!INCLUDE [sql-pdw](../../includes/applies-to-version/sql-pdw.md)]
2526

2627
Returns a row for each module loaded into the server address space.
2728

‎docs/relational-databases/system-dynamic-management-views/sys-dm-os-memory-brokers-transact-sql.md‎

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,9 +19,10 @@ helpviewer_keywords:
1919
ms.assetid: 48dd6ad9-0d36-4370-8a12-4921d0df4b86
2020
author: WilliamDAssafMSFT
2121
ms.author: wiassaf
22+
monikerRange: ">= sql-server-2016 || >= sql-server-linux-2017|| >= aps-pdw-2016 || = azure-sqldw-latest"
2223
---
2324
# sys.dm_os_memory_brokers (Transact-SQL)
24-
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
25+
[!INCLUDE [sql-asa-pdw](../../includes/applies-to-version/sql-asa-pdw.md)]
2526

2627
Allocations that are internal to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] use the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] memory manager. Tracking the difference between process memory counters from **sys.dm_os_process_memory** and internal counters can indicate memory use from external components in the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] memory space.
2728

@@ -30,7 +31,7 @@ ms.author: wiassaf
3031
The following table provides information about memory brokers.
3132

3233
> [!NOTE]
33-
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_memory_brokers**.
34+
> To call this from [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] or [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], use the name **sys.dm_pdw_nodes_os_memory_brokers**. [!INCLUDE[synapse-analytics-od-unsupported-syntax](../../includes/synapse-analytics-od-unsupported-syntax.md)]
3435
3536
|Column name|Data type|Description|
3637
|-----------------|---------------|-----------------|

0 commit comments

Comments
 (0)