sys.dm_os_latch_stats (Transact-SQL)sys.dm_os_latch_stats (Transact-SQL)

適用於: 是SQL Server 是Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

傳回所有以類別組織之閂鎖等候的相關資訊。Returns information about all latch waits organized by class.

注意

若要從 Azure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW)平行處理資料倉儲Parallel Data Warehouse呼叫此,請使用dm_pdw_nodes_os_latch_stats的名稱。To call this from Azure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW) or 平行處理資料倉儲Parallel Data Warehouse, use the name sys.dm_pdw_nodes_os_latch_stats.

資料行名稱Column name [名稱]Data type 描述Description
latch_classlatch_class nvarchar(120)nvarchar(120) 閂鎖類別的名稱。Name of the latch class.
waiting_requests_countwaiting_requests_count bigintbigint 這個類別中的閂鎖等候數。Number of waits on latches in this class. 這個計數器是從開始閂鎖等候時逐量遞增計算。This counter is incremented at the start of a latch wait.
wait_time_mswait_time_ms bigintbigint 這個類別的總閂鎖等候時間 (以毫秒為單位)。Total wait time, in milliseconds, on latches in this class.

注意: 此資料行會在閂鎖等候期間每五分鐘更新一次,並在閂鎖等候結束時更新。Note: This column is updated every five minutes during a latch wait and at the end of a latch wait.
max_wait_time_msmax_wait_time_ms bigintbigint 這是記憶體物件可以等候這個閂鎖的最長時間。Maximum time a memory object has waited on this latch. 如果這個值超乎尋常地高,可能是發生內部死結。If this value is unusually high, it might indicate an internal deadlock.
pdw_node_idpdw_node_id intint 適用于Azure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW)平行處理資料倉儲Parallel Data WarehouseApplies to: Azure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW), 平行處理資料倉儲Parallel Data Warehouse

此散發所在節點的識別碼。The identifier for the node that this distribution is on.

PermissionsPermissions

SQL ServerSQL Server上,需要 VIEW SERVER STATE 許可權。On SQL ServerSQL Server, requires VIEW SERVER STATE permission.
SQL DatabaseSQL Database 高階層級上,需要資料庫中的 VIEW DATABASE STATE 許可權。On SQL DatabaseSQL Database Premium Tiers, requires the VIEW DATABASE STATE permission in the database. SQL DatabaseSQL Database 標準和基本層上,需要伺服器管理員或 Azure Active Directory 的系統管理員帳戶。On SQL DatabaseSQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

RemarksRemarks

sys.dm_os_latch_stats 可以檢查不同閂鎖類別的相對等候時間和等候次數,來識別閂鎖競爭的來源。sys.dm_os_latch_stats can be used to identify the source of latch contention by examining the relative wait numbers and wait times for the different latch classes. 某些情況下,您或許可以解決或減少閂鎖競爭的狀況。In some situations, you may be able to resolve or reduce latch contention. 不過有些時候您可能還是必須連絡 MicrosoftMicrosoft 客戶支援服務部門。However, there might be situations that will require that you to contact MicrosoftMicrosoft Customer Support Services.

您可以利用 DBCC SQLPERF 重設 sys.dm_os_latch_stats 的內容,如下所示:You can reset the contents of sys.dm_os_latch_stats by using DBCC SQLPERF as follows:

DBCC SQLPERF ('sys.dm_os_latch_stats', CLEAR);  
GO  

此舉會將所有的計數器重設為 0。This resets all counters to 0.

注意

如果重新啟動 SQL ServerSQL Server,將無法保存這些統計資料。These statistics are not persisted if SQL ServerSQL Server is restarted. 所有的資料都是從上次重設統計資料之後,或是從 SQL ServerSQL Server 啟動之後開始累加計算。All data is cumulative since the last time the statistics were reset, or since SQL ServerSQL Server was started.

Latches

閂鎖是與鎖定類似的內部輕量同步處理物件,由各種 SQL ServerSQL Server 元件所使用。A latch is an internal lightweight synchronization object similar to a lock, that is used by various SQL ServerSQL Server components. 閂鎖主要用來同步處理作業(例如緩衝區或檔案存取)中的資料庫頁面。A latch is primarily used to synchronize database pages during operations such as buffer or file access. 每一個閂鎖都與一個配置單位有關。Each latch is associated with a single allocation unit.

如果無法立即授與閂鎖要求,就會發生閂鎖等候,因為閂鎖是由另一個處於衝突模式的執行緒所持有。A latch wait occurs when a latch request cannot be granted immediately, because the latch is held by another thread in a conflicting mode. 與鎖定不同的是,閂鎖會在作業之後立即釋出,即使是進行寫入作業也一樣。Unlike locks, a latch is released immediately after the operation, even in write operations.

閂鎖是根據元件和使用方式,分成幾個類別。Latches are grouped into classes based on components and usage. 零個或零個以上特殊類別的閂鎖,可以存在於 SQL ServerSQL Server 執行個體的任何一個時間點。Zero or more latches of a particular class can exist at any point in time in an instance of SQL ServerSQL Server.

注意

sys.dm_os_latch_stats 不會追蹤立即授與或未等待的閂鎖要求。sys.dm_os_latch_stats does not track latch requests that were granted immediately, or that failed without waiting.

下表含有各種閂鎖類別的簡單描述。The following table contains brief descriptions of the various latch classes.

閂鎖類別Latch class 描述Description
ALLOC_CREATE_RINGBUFALLOC_CREATE_RINGBUF SQL ServerSQL Server 在內部使用,將建立配置環緩衝區的同步處理作業初始化。Used internally by SQL ServerSQL Server to initialize the synchronization of the creation of an allocation ring buffer.
ALLOC_CREATE_FREESPACE_CACHEALLOC_CREATE_FREESPACE_CACHE 用來將堆積內部可用空間快取的同步處理作業初始化。Used to initialize the synchronization of internal freespace caches for heaps.
ALLOC_CACHE_MANAGERALLOC_CACHE_MANAGER 用來同步處理內部一致性測試。Used to synchronize internal coherency tests.
ALLOC_FREESPACE_CACHEALLOC_FREESPACE_CACHE 利用堆積和二進位大型物件 (BLOB) 的可用空間,同步處理資料頁面快取的存取作業。Used to synchronize the access to a cache of pages with available space for heaps and binary large objects (BLOBs). 如果有多個連接同時將資料列插入堆積或 BLOB 中,可能就會發生這個類別的閂鎖競爭情形。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.
ALLOC_EXTENT_CACHEALLOC_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.
ACCESS_METHODS_DATASET_PARENTACCESS_METHODS_DATASET_PARENT 在平行作業期間,用來同步處理子資料集對父資料集的存取作業。Used to synchronize child dataset access to the parent dataset during parallel operations.
ACCESS_METHODS_HOBT_FACTORYACCESS_METHODS_HOBT_FACTORY 用來同步處理內部雜湊資料表的存取作業。Used to synchronize access to an internal hash table.
ACCESS_METHODS_HOBTACCESS_METHODS_HOBT 用來同步處理 HoBt 記憶體中表示法的存取作業。Used to synchronize access to the in-memory representation of a HoBt.
ACCESS_METHODS_HOBT_COUNTACCESS_METHODS_HOBT_COUNT 用來同步處理 HoBt 資料頁和資料列計數器的存取作業。Used to synchronize access to a HoBt page and row counters.
ACCESS_METHODS_HOBT_VIRTUAL_ROOTACCESS_METHODS_HOBT_VIRTUAL_ROOT 用來同步處理內部 B 型樹狀目錄所擷取之根頁面的存取作業。Used to synchronize access to the root page abstraction of an internal B-tree.
ACCESS_METHODS_CACHE_ONLY_HOBT_ALLOCACCESS_METHODS_CACHE_ONLY_HOBT_ALLOC 用來同步處理工作資料表的存取作業。Used to synchronize worktable access.
ACCESS_METHODS_BULK_ALLOCACCESS_METHODS_BULK_ALLOC 用來同步處理大量配置器中的存取作業。Used to synchronize access within bulk allocators.
ACCESS_METHODS_SCAN_RANGE_GENERATORACCESS_METHODS_SCAN_RANGE_GENERATOR 在平行掃描期間,用來同步處理對範圍產生器的存取作業。Used to synchronize access to a range generator during parallel scans.
ACCESS_METHODS_KEY_RANGE_GENERATORACCESS_METHODS_KEY_RANGE_GENERATOR 在關鍵範圍平行掃描期間,用來同步處理對讀取前作業的存取作業。Used to synchronize access to read-ahead operations during key range parallel scans.
APPEND_ONLY_STORAGE_INSERT_POINTAPPEND_ONLY_STORAGE_INSERT_POINT 用來同步處理快速附加專用儲存體單位中的插入作業。Used to synchronize inserts in fast append-only storage units.
APPEND_ONLY_STORAGE_FIRST_ALLOCAPPEND_ONLY_STORAGE_FIRST_ALLOC 用來同步處理附加專用儲存體單位的第一個配置作業。Used to synchronize the first allocation for an append-only storage unit.
APPEND_ONLY_STORAGE_UNIT_MANAGERAPPEND_ONLY_STORAGE_UNIT_MANAGER 用來同步處理快速附加專用儲存體單位管理員內的內部資料結構存取作業。Used for internal data structure access synchronization within the fast append-only storage unit manager.
APPEND_ONLY_STORAGE_MANAGERAPPEND_ONLY_STORAGE_MANAGER 用來同步處理快速附加專用儲存體單位管理員中的壓縮作業。Used to synchronize shrink operations in the fast append-only storage unit manager.
BACKUP_RESULT_SETBACKUP_RESULT_SET 用來同步處理平行備份結果集。Used to synchronize parallel backup result sets.
BACKUP_TAPE_POOLBACKUP_TAPE_POOL 用來同步處理備份磁帶集區。Used to synchronize backup tape pools.
BACKUP_LOG_REDOBACKUP_LOG_REDO 用來同步處理備份記錄重做作業。Used to synchronize backup log redo operations.
BACKUP_INSTANCE_IDBACKUP_INSTANCE_ID 用來同步處理備份效能監視器計數器之執行個體識別碼的產生作業。Used to synchronize the generation of instance IDs for backup performance monitor counters.
BACKUP_MANAGERBACKUP_MANAGER 用來同步處理內部備份管理員。Used to synchronize the internal backup manager.
BACKUP_MANAGER_DIFFERENTIALBACKUP_MANAGER_DIFFERENTIAL 用來同步處理差異備份作業與 DBCC。Used to synchronize differential backup operations with DBCC.
BACKUP_OPERATIONBACKUP_OPERATION 用來同步處理備份作業 (例如資料庫、記錄或檔案備份) 內的內部資料結構。Used for internal data structure synchronization within a backup operation, such as database, log, or file backup.
BACKUP_FILE_HANDLEBACKUP_FILE_HANDLE 在還原作業期間,用來同步處理檔案開啟作業。Used to synchronize file open operations during a restore operation.
BUFFERBUFFER 用來同步處理對資料庫頁面的短期存取作業。Used to synchronize short term access to database pages. 在讀取或修改任何資料庫頁面之前,必須具備緩衝區閂鎖。A buffer latch is required before reading or modifying any database page. 緩衝區閂鎖競爭會指出幾個問題,包括頁面使用頻繁和 I/O 速度緩慢。Buffer latch contention can indicate several issues, including hot pages and slow I/Os.

這個閂鎖類別涵蓋頁面閂鎖的所有可能用途。This latch class covers all possible uses of page latches. dm_os_wait_stats 讓 i/o 作業和頁面上的讀取和寫入作業所造成的頁面閂鎖等候有所差異。sys.dm_os_wait_stats makes a difference between page latch waits that are caused by I/O operations and read and write operations on the page.
BUFFER_POOL_GROWBUFFER_POOL_GROW 在緩衝集區成長作業期間,用來同步處理內部緩衝區管理員。Used for internal buffer manager synchronization during buffer pool grow operations.
DATABASE_CHECKPOINTDATABASE_CHECKPOINT 用來序列化資料庫內的檢查點。Used to serialize checkpoints within a database.
CLR_PROCEDURE_HASHTABLECLR_PROCEDURE_HASHTABLE 僅供內部使用。Internal use only.
CLR_UDX_STORECLR_UDX_STORE 僅供內部使用。Internal use only.
CLR_DATAT_ACCESSCLR_DATAT_ACCESS 僅供內部使用。Internal use only.
CLR_XVAR_PROXY_LISTCLR_XVAR_PROXY_LIST 僅供內部使用。Internal use only.
DBCC_CHECK_AGGREGATEDBCC_CHECK_AGGREGATE 僅供內部使用。Internal use only.
DBCC_CHECK_RESULTSETDBCC_CHECK_RESULTSET 僅供內部使用。Internal use only.
DBCC_CHECK_TABLEDBCC_CHECK_TABLE 僅供內部使用。Internal use only.
DBCC_CHECK_TABLE_INITDBCC_CHECK_TABLE_INIT 僅供內部使用。Internal use only.
DBCC_CHECK_TRACE_LISTDBCC_CHECK_TRACE_LIST 僅供內部使用。Internal use only.
DBCC_FILE_CHECK_OBJECTDBCC_FILE_CHECK_OBJECT 僅供內部使用。Internal use only.
DBCC_PERFDBCC_PERF 用來同步處理內部效能監視器計數器。Used to synchronize internal performance monitor counters.
DBCC_PFS_STATUSDBCC_PFS_STATUS 僅供內部使用。Internal use only.
DBCC_OBJECT_METADATADBCC_OBJECT_METADATA 僅供內部使用。Internal use only.
DBCC_HASH_DLLDBCC_HASH_DLL 僅供內部使用。Internal use only.
EVENTING_CACHEEVENTING_CACHE 僅供內部使用。Internal use only.
FCBFCB 用來同步處理檔案控制區塊的存取作業。Used to synchronize access to the file control block.
FCB_REPLICAFCB_REPLICA 僅供內部使用。Internal use only.
FGCB_ALLOCFGCB_ALLOC 用來同步處理對檔案群組中循環配置資訊的存取作業。Use to synchronize access to round robin allocation information within a filegroup.
FGCB_ADD_REMOVEFGCB_ADD_REMOVE 用來同步處理檔案群組的存取權,以進行新增、卸載、成長和縮減檔案作業。Use to synchronize access to filegroups for add, drop, grow, and shrink file operations.
FILEGROUP_MANAGERFILEGROUP_MANAGER 僅供內部使用。Internal use only.
FILE_MANAGERFILE_MANAGER 僅供內部使用。Internal use only.
FILESTREAM_FCBFILESTREAM_FCB 僅供內部使用。Internal use only.
FILESTREAM_FILE_MANAGERFILESTREAM_FILE_MANAGER 僅供內部使用。Internal use only.
FILESTREAM_GHOST_FILESFILESTREAM_GHOST_FILES 僅供內部使用。Internal use only.
FILESTREAM_DFS_ROOTFILESTREAM_DFS_ROOT 僅供內部使用。Internal use only.
LOG_MANAGERLOG_MANAGER 僅供內部使用。Internal use only.
FULLTEXT_DOCUMENT_IDFULLTEXT_DOCUMENT_ID 僅供內部使用。Internal use only.
FULLTEXT_DOCUMENT_ID_TRANSACTIONFULLTEXT_DOCUMENT_ID_TRANSACTION 僅供內部使用。Internal use only.
FULLTEXT_DOCUMENT_ID_NOTIFYFULLTEXT_DOCUMENT_ID_NOTIFY 僅供內部使用。Internal use only.
FULLTEXT_LOGSFULLTEXT_LOGS 僅供內部使用。Internal use only.
FULLTEXT_CRAWL_LOGFULLTEXT_CRAWL_LOG 僅供內部使用。Internal use only.
FULLTEXT_ADMINFULLTEXT_ADMIN 僅供內部使用。Internal use only.
FULLTEXT_AMDIN_COMMAND_CACHEFULLTEXT_AMDIN_COMMAND_CACHE 僅供內部使用。Internal use only.
FULLTEXT_LANGUAGE_TABLEFULLTEXT_LANGUAGE_TABLE 僅供內部使用。Internal use only.
FULLTEXT_CRAWL_DM_LISTFULLTEXT_CRAWL_DM_LIST 僅供內部使用。Internal use only.
FULLTEXT_CRAWL_CATALOGFULLTEXT_CRAWL_CATALOG 僅供內部使用。Internal use only.
FULLTEXT_FILE_MANAGERFULLTEXT_FILE_MANAGER 僅供內部使用。Internal use only.
DATABASE_MIRRORING_REDODATABASE_MIRRORING_REDO 僅供內部使用。Internal use only.
DATABASE_MIRRORING_SERVERDATABASE_MIRRORING_SERVER 僅供內部使用。Internal use only.
DATABASE_MIRRORING_CONNECTIONDATABASE_MIRRORING_CONNECTION 僅供內部使用。Internal use only.
DATABASE_MIRRORING_STREAMDATABASE_MIRRORING_STREAM 僅供內部使用。Internal use only.
QUERY_OPTIMIZER_VD_MANAGERQUERY_OPTIMIZER_VD_MANAGER 僅供內部使用。Internal use only.
QUERY_OPTIMIZER_ID_MANAGERQUERY_OPTIMIZER_ID_MANAGER 僅供內部使用。Internal use only.
QUERY_OPTIMIZER_VIEW_REPQUERY_OPTIMIZER_VIEW_REP 僅供內部使用。Internal use only.
RECOVERY_BAD_PAGE_TABLERECOVERY_BAD_PAGE_TABLE 僅供內部使用。Internal use only.
RECOVERY_MANAGERRECOVERY_MANAGER 僅供內部使用。Internal use only.
SECURITY_OPERATION_RULE_TABLESECURITY_OPERATION_RULE_TABLE 僅供內部使用。Internal use only.
SECURITY_OBJPERM_CACHESECURITY_OBJPERM_CACHE 僅供內部使用。Internal use only.
SECURITY_CRYPTOSECURITY_CRYPTO 僅供內部使用。Internal use only.
SECURITY_KEY_RINGSECURITY_KEY_RING 僅供內部使用。Internal use only.
SECURITY_KEY_LISTSECURITY_KEY_LIST 僅供內部使用。Internal use only.
SERVICE_BROKER_CONNECTION_RECEIVESERVICE_BROKER_CONNECTION_RECEIVE 僅供內部使用。Internal use only.
SERVICE_BROKER_TRANSMISSIONSERVICE_BROKER_TRANSMISSION 僅供內部使用。Internal use only.
SERVICE_BROKER_TRANSMISSION_UPDATESERVICE_BROKER_TRANSMISSION_UPDATE 僅供內部使用。Internal use only.
SERVICE_BROKER_TRANSMISSION_STATESERVICE_BROKER_TRANSMISSION_STATE 僅供內部使用。Internal use only.
SERVICE_BROKER_TRANSMISSION_ERRORSSERVICE_BROKER_TRANSMISSION_ERRORS 僅供內部使用。Internal use only.
SSBXmitWorkSSBXmitWork 僅供內部使用。Internal use only.
SERVICE_BROKER_MESSAGE_TRANSMISSIONSERVICE_BROKER_MESSAGE_TRANSMISSION 僅供內部使用。Internal use only.
SERVICE_BROKER_MAP_MANAGERSERVICE_BROKER_MAP_MANAGER 僅供內部使用。Internal use only.
SERVICE_BROKER_HOST_NAMESERVICE_BROKER_HOST_NAME 僅供內部使用。Internal use only.
SERVICE_BROKER_READ_CACHESERVICE_BROKER_READ_CACHE 僅供內部使用。Internal use only.
SERVICE_BROKER_WAITFOR_MANAGERSERVICE_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. 當許多連接都是:在 WAITFOR (RECEIVE)等候狀態時,就會發生此類別的閂鎖爭用;呼叫 WAITFOR (RECEIVE);超過 WAITFOR timeout;接收訊息;認可或回復包含 WAITFOR (RECEIVE)的交易;您可以藉由減少 WAITFOR (RECEIVE)等候狀態中的執行緒數目,來減少爭用。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_DATASERVICE_BROKER_WAITFOR_TRANSACTION_DATA 僅供內部使用。Internal use only.
SERVICE_BROKER_TRANSMISSION_TRANSACTION_DATASERVICE_BROKER_TRANSMISSION_TRANSACTION_DATA 僅供內部使用。Internal use only.
SERVICE_BROKER_TRANSPORTSERVICE_BROKER_TRANSPORT 僅供內部使用。Internal use only.
SERVICE_BROKER_MIRROR_ROUTESERVICE_BROKER_MIRROR_ROUTE 僅供內部使用。Internal use only.
TRACE_IDTRACE_ID 僅供內部使用。Internal use only.
TRACE_AUDIT_IDTRACE_AUDIT_ID 僅供內部使用。Internal use only.
追蹤TRACE 僅供內部使用。Internal use only.
TRACE_CONTROLLERTRACE_CONTROLLER 僅供內部使用。Internal use only.
TRACE_EVENT_QUEUETRACE_EVENT_QUEUE 僅供內部使用。Internal use only.
TRANSACTION_DISTRIBUTED_MARKTRANSACTION_DISTRIBUTED_MARK 僅供內部使用。Internal use only.
TRANSACTION_OUTCOMETRANSACTION_OUTCOME 僅供內部使用。Internal use only.
NESTING_TRANSACTION_READONLYNESTING_TRANSACTION_READONLY 僅供內部使用。Internal use only.
NESTING_TRANSACTION_FULLNESTING_TRANSACTION_FULL 僅供內部使用。Internal use only.
MSQL_TRANSACTION_MANAGERMSQL_TRANSACTION_MANAGER 僅供內部使用。Internal use only.
DATABASE_AUTONAME_MANAGERDATABASE_AUTONAME_MANAGER 僅供內部使用。Internal use only.
UTILITY_DYNAMIC_VECTORUTILITY_DYNAMIC_VECTOR 僅供內部使用。Internal use only.
UTILITY_SPARSE_BITMAPUTILITY_SPARSE_BITMAP 僅供內部使用。Internal use only.
UTILITY_DATABASE_DROPUTILITY_DATABASE_DROP 僅供內部使用。Internal use only.
UTILITY_DYNAMIC_MANAGER_VIEWUTILITY_DYNAMIC_MANAGER_VIEW 僅供內部使用。Internal use only.
UTILITY_DEBUG_FILESTREAMUTILITY_DEBUG_FILESTREAM 僅供內部使用。Internal use only.
UTILITY_LOCK_INFORMATIONUTILITY_LOCK_INFORMATION 僅供內部使用。Internal use only.
VERSIONING_TRANSACTIONVERSIONING_TRANSACTION 僅供內部使用。Internal use only.
VERSIONING_TRANSACTION_LISTVERSIONING_TRANSACTION_LIST 僅供內部使用。Internal use only.
VERSIONING_TRANSACTION_CHAINVERSIONING_TRANSACTION_CHAIN 僅供內部使用。Internal use only.
VERSIONING_STATEVERSIONING_STATE 僅供內部使用。Internal use only.
VERSIONING_STATE_CHANGEVERSIONING_STATE_CHANGE 僅供內部使用。Internal use only.
KTM_VIRTUAL_CLOCKKTM_VIRTUAL_CLOCK 僅供內部使用。Internal use only.

另請參閱See Also

DBCC SQLPERF (Transact-SQL) DBCC SQLPERF (Transact-SQL)
SQL Server 作業系統相關的動態管理 Views (transact-sql) SQL Server Operating System Related Dynamic Management Views (Transact-SQL)
SQL Server 的 Latches 物件SQL Server, Latches Object