Merge pull request MicrosoftDocs#2618 from stevestein/SqlWi5085959

v-thepet · web-flow · commit abccd51f6a9e · 2017-07-25T11:01:35.000-07:00
updated description
diff --git a/docs/relational-databases/system-dynamic-management-views/sys-dm-os-latch-stats-transact-sql.md b/docs/relational-databases/system-dynamic-management-views/sys-dm-os-latch-stats-transact-sql.md
@@ -1,32 +1,32 @@
----
-title: "sys.dm_os_latch_stats (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
-ms.date: "03/13/2017"
-ms.prod: "sql-non-specified"
-ms.reviewer: ""
-ms.suite: ""
-ms.technology: 
-  - "database-engine"
-ms.tgt_pltfrm: ""
-ms.topic: "language-reference"
-f1_keywords: 
-  - "sys.dm_os_latch_stats_TSQL"
-  - "dm_os_latch_stats_TSQL"
-  - "dm_os_latch_stats"
-  - "sys.dm_os_latch_stats"
-dev_langs: 
-  - "TSQL"
-helpviewer_keywords: 
-  - "sys.dm_os_latch_stats dynamic management view"
-ms.assetid: 2085d9fc-828c-453e-82ec-b54ed8347ae5
-caps.latest.revision: 33
-author: "JennieHubbard"
-ms.author: "jhubbard"
-manager: "jhubbard"
----
-# sys.dm_os_latch_stats (Transact-SQL)
-[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]
-
+---
+title: "sys.dm_os_latch_stats (Transact-SQL) | Microsoft Docs"
+ms.custom: ""
+ms.date: "03/13/2017"
+ms.prod: "sql-non-specified"
+ms.reviewer: ""
+ms.suite: ""
+ms.technology: 
+  - "database-engine"
+ms.tgt_pltfrm: ""
+ms.topic: "language-reference"
+f1_keywords: 
+  - "sys.dm_os_latch_stats_TSQL"
+  - "dm_os_latch_stats_TSQL"
+  - "dm_os_latch_stats"
+  - "sys.dm_os_latch_stats"
+dev_langs: 
+  - "TSQL"
+helpviewer_keywords: 
+  - "sys.dm_os_latch_stats dynamic management view"
+ms.assetid: 2085d9fc-828c-453e-82ec-b54ed8347ae5
+caps.latest.revision: 33
+author: "JennieHubbard"
+ms.author: "jhubbard"
+manager: "jhubbard"
+---
+# sys.dm_os_latch_stats (Transact-SQL)
+[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]
+
   Returns information about all latch waits organized by class.  
   
 > [!NOTE]  
@@ -163,7 +163,7 @@ GO
 |SERVICE_BROKER_MAP_MANAGER|Internal use only.|  
 |SERVICE_BROKER_HOST_NAME|Internal use only.|  
 |SERVICE_BROKER_READ_CACHE|Internal use only.|  
-|SERVICE_BROKER_WAITFOR_MANAGER|Internal use only.|  
+|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. |  
 |SERVICE_BROKER_WAITFOR_TRANSACTION_DATA|Internal use only.|  
 |SERVICE_BROKER_TRANSMISSION_TRANSACTION_DATA|Internal use only.|  
 |SERVICE_BROKER_TRANSPORT|Internal use only.|  
@@ -200,4 +200,4 @@ GO
   
   
 
-
+
