sys.dm_os_wait_stats (Transact-SQL)sys.dm_os_wait_stats (Transact-SQL)

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

傳回執行中之執行緒所遇到之所有等候的相關資訊。Returns information about all the waits encountered by threads that executed. 您可以使用這份彙總檢視來診斷 SQL ServerSQL Server 的效能問題,以及特定查詢和批次的效能問題。You can use this aggregated view to diagnose performance issues with SQL ServerSQL Server and also with specific queries and batches. dm_exec_session_wait_stats (transact-sql) 依會話提供類似的資訊。sys.dm_exec_session_wait_stats (Transact-SQL) provides similar information by session.

注意

若要從 Azure Synapse Analytics (SQL DW)Azure Synapse Analytics (SQL DW)平行處理資料倉儲Parallel Data Warehouse 呼叫此,請使用dm_pdw_nodes_os_wait_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_wait_stats.

資料行名稱Column name [名稱]Data type 描述Description
wait_typewait_type nvarchar(60)nvarchar(60) 等候類型的名稱。Name of the wait type. 如需詳細資訊,請參閱本主題稍後的等候類型For more information, see Types of Waits, later in this topic.
waiting_tasks_countwaiting_tasks_count bigintbigint 這個等候類型的等候次數。Number of waits on this wait type. 這個計數器是從每次開始等候時逐量遞增計算。This counter is incremented at the start of each wait.
wait_time_mswait_time_ms bigintbigint 這個等候類型的總等候時間 (以毫秒為單位)。Total wait time for this wait type in milliseconds. 這個時間包括 signal_wait_time_ms 在內。This time is inclusive of signal_wait_time_ms.
max_wait_time_msmax_wait_time_ms bigintbigint 這個等候類型的等候時間上限。Maximum wait time on this wait type.
signal_wait_time_mssignal_wait_time_ms bigintbigint 從等候執行緒接獲訊號到開始執行的時間。Difference between the time that the waiting thread was signaled and when it started running.
pdw_node_idpdw_node_id intint 此散發所在節點的識別碼。The identifier for the node that this distribution is on.
適用于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

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.

等候的類型Types of Waits

資源等候當背景工作要求存取無法使用的資源時,就會發生資源等候,因為資源正由某個其他背景工作角色使用,或是尚未提供。Resource waits Resource waits occur when a worker requests access to a resource that is not available because the resource is being used by some other worker or is not yet available. 鎖定、閂鎖、網路和磁碟 I/O 等候,都是資源等候的範例。Examples of resource waits are locks, latches, network and disk I/O waits. 鎖定和閂鎖等候是同步處理物件的等候。Lock and latch waits are waits on synchronization objects

佇列等候Queue waits
佇列等候發生在工作者因為等候指派工作而閒置時。Queue waits occur when a worker is idle, waiting for work to be assigned. 佇列等候大部分都是在進行系統背景工作 (例如,監視死結和刪除記錄清除工作) 時發生。Queue waits are most typically seen with system background tasks such as the deadlock monitor and deleted record cleanup tasks. 這些工作會等候工作要求被置於工作佇列。These tasks will wait for work requests to be placed into a work queue. 即使沒有新的封包置於佇列中,佇列等候也可能會定期變成使用中狀態。Queue waits may also periodically become active even if no new packets have been put on the queue.

外部等候External waits
外部等候是 SQL ServerSQL Server 工作者正在等候外部事件 (例如,擴充預存程序呼叫或連結伺服器查詢) 完成時發生。External waits occur when a SQL ServerSQL Server worker is waiting for an external event, such as an extended stored procedure call or a linked server query, to finish. 記住,當您診斷封鎖問題時,外部等候不會一直暗示工作者正在閒置,因為工作者可能很積極的在執行一些外部程式碼。When you diagnose blocking issues, remember that external waits do not always imply that the worker is idle, because the worker may actively be running some external code.

sys.dm_os_wait_stats 顯示已完成等候的時間。sys.dm_os_wait_stats shows the time for waits that have completed. 此動態管理檢視不會顯示目前的等候。This dynamic management view does not show current waits.

在下列任何一種情況下,SQL ServerSQL Server 工作者執行緒都不算是在等候中:A SQL ServerSQL Server worker thread is not considered to be waiting if any of the following is true:

  • 資源可以使用。A resource becomes available.

  • 佇列不是空的。A queue is nonempty.

  • 外部處理序完成。An external process finishes.

雖然執行緒已經不在等候中,執行緒也不必立即開始執行。Although the thread is no longer waiting, the thread does not have to start running immediately. 因為這類執行緒會先置於可執行之工作者的佇列上,而且必須等候排程器執行某個配量才行。This is because such a thread is first put on the queue of runnable workers and must wait for a quantum to run on the scheduler.

SQL ServerSQL Server,等候時間計數器是Bigint值,因此不像舊版 SQL ServerSQL Server中的對等計數器一樣容易計數器變換。In SQL ServerSQL Server the wait-time counters are bigint values and therefore are not as prone to counter rollover as the equivalent counters in earlier versions of SQL ServerSQL Server.

在執行查詢時,特定類型的等候時間可以指出查詢中的瓶頸或拋錨點。Specific types of wait times during query execution can indicate bottlenecks or stall points within the query. 同樣地,等候時間很長或伺服器等候計數很大,也代表伺服器執行個體中互動查詢互動的瓶頸或熱點。Similarly, high wait times, or wait counts server wide can indicate bottlenecks or hot spots in interaction query interactions within the server instance. 例如,鎖定等候表示查詢在競爭資料;資料頁 IO 閂鎖等候表示 IO 回應時間很慢;資料頁閂鎖更新等候表示檔案配置不正確。For example, lock waits indicate data contention by queries; page IO latch waits indicate slow IO response times; page latch update waits indicate incorrect file layout.

您可以執行下列命令,重設這份動態管理檢視的內容:The contents of this dynamic management view can be reset by running the following command:

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

這個命令會將所有的計數器重設為 0。This command resets all counters to 0.

注意

這些統計資料在 SQL ServerSQL Server 重新啟動之後都不會保存下來,而且所有的資料都是從上次統計資料重設或伺服器啟動之後開始累加計算。These statistics are not persisted across SQL ServerSQL Server restarts, and all data is cumulative since the last time the statistics were reset or the server was started.

下表列出工作會遇到的等候類型。The following table lists the wait types encountered by tasks.

類型type 描述Description
ABRABR 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
AM_INDBUILD_ALLOCATIONAM_INDBUILD_ALLOCATION 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
AM_SCHEMAMGR_UNSHARED_CACHEAM_SCHEMAMGR_UNSHARED_CACHE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
ASSEMBLY_FILTER_HASHTABLEASSEMBLY_FILTER_HASHTABLE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
ASSEMBLY_LOADASSEMBLY_LOAD 在組件載入的獨佔存取期間發生。Occurs during exclusive access to assembly loading.
ASYNC_DISKPOOL_LOCKASYNC_DISKPOOL_LOCK 在同步處理執行建立檔案,或者檔案初始化等工作的平行執行緒時發生。Occurs when there is an attempt to synchronize parallel threads that are performing tasks such as creating or initializing a file.
ASYNC_IO_COMPLETIONASYNC_IO_COMPLETION 在工作等候 I/O 完成時發生。Occurs when a task is waiting for I/Os to finish.
ASYNC_NETWORK_IOASYNC_NETWORK_IO 當工作被封鎖在網路後面時,進行網路寫入就會發生這種情形。Occurs on network writes when the task is blocked behind the network. 請確認用戶端正在處理來自伺服器的資料。Verify that the client is processing data from the server.
ASYNC_OP_COMPLETIONASYNC_OP_COMPLETION 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
ASYNC_OP_CONTEXT_READASYNC_OP_CONTEXT_READ 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
ASYNC_OP_CONTEXT_WRITEASYNC_OP_CONTEXT_WRITE 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
ASYNC_SOCKETDUP_IOASYNC_SOCKETDUP_IO 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
AUDIT_GROUPCACHE_LOCKAUDIT_GROUPCACHE_LOCK 當控制特殊快取之存取權的鎖定上存在等候時發生。Occurs when there is a wait on a lock that controls access to a special cache. 此快取包含哪些稽核要用來稽核每個稽核動作群組的相關資訊。The cache contains information about which audits are being used to audit each audit action group.
AUDIT_LOGINCACHE_LOCKAUDIT_LOGINCACHE_LOCK 當控制特殊快取之存取權的鎖定上存在等候時發生。Occurs when there is a wait on a lock that controls access to a special cache. 此快取包含哪些稽核要用來稽核登入稽核動作群組的相關資訊。The cache contains information about which audits are being used to audit login audit action groups.
AUDIT_ON_DEMAND_TARGET_LOCKAUDIT_ON_DEMAND_TARGET_LOCK 當用來確保稽核相關「擴充事件」目標之單一初始化的鎖定上存在等候時發生。Occurs when there is a wait on a lock that is used to ensure single initialization of audit related Extended Event targets.
AUDIT_XE_SESSION_MGRAUDIT_XE_SESSION_MGR 當用來同步處理稽核相關「擴充事件」工作階段之啟動和停止的鎖定上存在等候時發生。Occurs when there is a wait on a lock that is used to synchronize the starting and stopping of audit related Extended Events sessions.
BACKUPBACKUP 當工作被當做備份處理的一部分而加以封鎖時發生。Occurs when a task is blocked as part of backup processing.
BACKUP_OPERATORBACKUP_OPERATOR 在工作等候磁帶掛載時發生。Occurs when a task is waiting for a tape mount. 若要查看磁帶狀態,請查詢 sys.databases dm_io_backup_tapes。To view the tape status, query sys.dm_io_backup_tapes. 如果掛載作業沒有暫止,這個等候類型可能就表示磁帶機發生硬體問題。If a mount operation is not pending, this wait type may indicate a hardware problem with the tape drive.
BACKUPBUFFERBACKUPBUFFER 當備份工作正在等候資料,或者等候儲存資料的緩衝區時發生。Occurs when a backup task is waiting for data, or is waiting for a buffer in which to store data. 除非當工作正在等候磁帶掛載,否則這個類型並非標準類型。This type is not typical, except when a task is waiting for a tape mount.
BACKUPIOBACKUPIO 當備份工作正在等候資料,或者等候儲存資料的緩衝區時發生。Occurs when a backup task is waiting for data, or is waiting for a buffer in which to store data. 除非當工作正在等候磁帶掛載,否則這個類型並非標準類型。This type is not typical, except when a task is waiting for a tape mount.
BACKUPTHREADBACKUPTHREAD 在工作等候備份工作完成時發生。Occurs when a task is waiting for a backup task to finish. 等候時間可能會很長,從幾分鐘到數小時都可能。Wait times may be long, from several minutes to several hours. 如果等候的工作是在 I/O 處理序中,這個類型就不表示發生問題。If the task that is being waited on is in an I/O process, this type does not indicate a problem.
BAD_PAGE_PROCESSBAD_PAGE_PROCESS 當背景可疑頁面記錄器想要避免執行間隔超過每 5 秒一次時發生。Occurs when the background suspect page logger is trying to avoid running more than every five seconds. 可疑頁面過多將導致記錄器經常執行。Excessive suspect pages cause the logger to run frequently.
BLOB_METADATABLOB_METADATA 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
BMPALLOCATIONBMPALLOCATION 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
BMPBUILDBMPBUILD 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
BMPREPARTITIONBMPREPARTITION 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
BMPREPLICATIONBMPREPLICATION 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
BPSORTBPSORT 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
BROKER_CONNECTION_RECEIVE_TASKBROKER_CONNECTION_RECEIVE_TASK 在連接端點上等候接收訊息的存取權時發生。Occurs when waiting for access to receive a message on a connection endpoint. 端點的接收存取是序列化的。Receive access to the endpoint is serialized.
BROKER_DISPATCHERBROKER_DISPATCHER 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
BROKER_ENDPOINT_STATE_MUTEXBROKER_ENDPOINT_STATE_MUTEX 當有爭用存取 Service Broker 連接端點的狀態時發生。Occurs when there is contention to access the state of a Service Broker connection endpoint. 存取變更的狀態是序列化的。Access to the state for changes is serialized.
BROKER_EVENTHANDLERBROKER_EVENTHANDLER 當工作在 Service Broker 的主要事件處理常式中等候時發生。Occurs when a task is waiting in the primary event handler of the Service Broker. 發生的時間相當短暫。This should occur very briefly.
BROKER_FORWARDERBROKER_FORWARDER 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
BROKER_INITBROKER_INIT 在每個使用中資料庫中初始化 Service Broker 時發生。Occurs when initializing Service Broker in each active database. 這種情況不常發生。This should occur infrequently.
BROKER_MASTERSTARTBROKER_MASTERSTART 當工作在等候 Service Broker 的主要事件處理常式啟動時發生。Occurs when a task is waiting for the primary event handler of the Service Broker to start. 發生的時間相當短暫。This should occur very briefly.
BROKER_RECEIVE_WAITFORBROKER_RECEIVE_WAITFOR 當 RECEIVE WAITFOR 在等候時發生。Occurs when the RECEIVE WAITFOR is waiting. 這可能表示未準備好在佇列中接收任何訊息,或鎖定爭用導致無法接收來自佇列的訊息。This may mean that either no messages are ready to be received in the queue or a lock contention is preventing it from receiving messages from the queue.
BROKER_REGISTERALLENDPOINTSBROKER_REGISTERALLENDPOINTS 在初始化 Service Broker 連接端點時發生。Occurs during the initialization of a Service Broker connection endpoint. 發生的時間相當短暫。This should occur very briefly.
BROKER_SERVICEBROKER_SERVICE 當與目標服務相關聯的 Service Broker 目的地清單已更新或重新設定優先權時發生。Occurs when the Service Broker destination list that is associated with a target service is updated or re-prioritized.
BROKER_SHUTDOWNBROKER_SHUTDOWN Service Broker 計畫關閉時發生。Occurs when there is a planned shutdown of Service Broker. 即使發生,時間也相當短暫。This should occur very briefly, if at all.
BROKER_STARTBROKER_START 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
BROKER_TASK_SHUTDOWNBROKER_TASK_SHUTDOWN 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
BROKER_TASK_STOPBROKER_TASK_STOP Service Broker 佇列工作處理常式嘗試關閉工作時發生。Occurs when the Service Broker queue task handler tries to shut down the task. 狀態檢查會序化列,而且必須事先處於執行中狀態。The state check is serialized and must be in a running state beforehand.
BROKER_TASK_SUBMITBROKER_TASK_SUBMIT 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
BROKER_TO_FLUSHBROKER_TO_FLUSH Service Broker lazy 清除器清除將記憶體中的傳輸物件排清至工作資料表時發生。Occurs when the Service Broker lazy flusher flushes the in-memory transmission objects to a work table.
BROKER_TRANSMISSION_OBJECTBROKER_TRANSMISSION_OBJECT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
BROKER_TRANSMISSION_TABLEBROKER_TRANSMISSION_TABLE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
BROKER_TRANSMISSION_WORKBROKER_TRANSMISSION_WORK 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
BROKER_TRANSMITTERBROKER_TRANSMITTER 當 Service Broker 發送器正在等候工作時發生。Occurs when the Service Broker transmitter is waiting for work. Service Broker 有一個稱為「傳輸器」的元件,可將來自多個對話的訊息,排程在一或多個連接端點上透過網路傳送。Service Broker has a component known as the Transmitter which schedules messages from multiple dialogs to be sent across the wire over one or more connection endpoints. 傳輸器有2個專門的執行緒可用於此用途。The transmitter has 2 dedicated threads for this purpose. 當這些發送器執行緒正在等候對話訊息使用傳輸連接來傳送時,就會收取此等候類型的費用。This wait type is charged when these transmitter threads are waiting for dialog messages to be sent using the transport connections. 此等候類型的 waiting_tasks_count 的高值指向這些發送器執行緒的間歇性工作,而且不會指出任何效能問題。High values of waiting_tasks_count for this wait type point to intermittent work for these transmitter threads and are not indications of any performance problem. 如果完全沒有使用 service broker,waiting_tasks_count 應該是2(針對2個發送器執行緒),而 wait_time_ms 應該是實例啟動後的兩倍。If service broker is not used at all, waiting_tasks_count should be 2 (for the 2 transmitter threads) and wait_time_ms should be twice the duration since instance startup. 請參閱Service broker 等候統計資料。See Service broker wait stats.
BUILTIN_HASHKEY_MUTEXBUILTIN_HASHKEY_MUTEX 可能在啟動執行個體之後,而內部資料結構正在初始化時發生。May occur after startup of instance, while internal data structures are initializing. 資料結構初始化之後就不會再次發生。Will not recur once data structures have initialized.
CHANGE_TRACKING_WAITFORCHANGESCHANGE_TRACKING_WAITFORCHANGES 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
CHECK_PRINT_RECORDCHECK_PRINT_RECORD 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
CHECK_SCANNER_MUTEXCHECK_SCANNER_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
CHECK_TABLES_INITIALIZATIONCHECK_TABLES_INITIALIZATION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
CHECK_TABLES_SINGLE_SCANCHECK_TABLES_SINGLE_SCAN 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
CHECK_TABLES_THREAD_BARRIERCHECK_TABLES_THREAD_BARRIER 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
CHECKPOINT_QUEUECHECKPOINT_QUEUE 當檢查點工作在等候下一個檢查點要求時發生。Occurs while the checkpoint task is waiting for the next checkpoint request.
CHKPTCHKPT 在伺服器啟動時發生,目的在告知檢查點執行緒,它可以啟動了。Occurs at server startup to tell the checkpoint thread that it can start.
CLEAR_DBCLEAR_DB 在變更資料庫狀態的作業期間發生,例如開啟或關閉資料庫。Occurs during operations that change the state of a database, such as opening or closing a database.
CLR_AUTO_EVENTCLR_AUTO_EVENT 當工作目前在執行 Common Language Runtime (CLR) 執行,以及在等候特定自動事件起始時發生。Occurs when a task is currently performing common language runtime (CLR) execution and is waiting for a particular autoevent to be initiated. 等候時間長是正常情況,並不表示發生任何問題。Long waits are typical, and do not indicate a problem.
CLR_CRSTCLR_CRST 當工作目前正在執行 CLR 執行,以及正在等候進入目前正被另一個工作使用中之工作的重要區段時發生。Occurs when a task is currently performing CLR execution and is waiting to enter a critical section of the task that is currently being used by another task.
CLR_JOINCLR_JOIN 當工作目前正在執行 CLR 執行,以及正在等候另一個工作結束時發生。Occurs when a task is currently performing CLR execution and waiting for another task to end. 這個等候狀態是在工作之間有聯結時發生。This wait state occurs when there is a join between tasks.
CLR_MANUAL_EVENTCLR_MANUAL_EVENT 當工作目前正在執行 CLR 執行,以及正在等候特定的手動事件起始時發生。Occurs when a task is currently performing CLR execution and is waiting for a specific manual event to be initiated.
CLR_MEMORY_SPYCLR_MEMORY_SPY 在用來記錄來自 CLR 之所有虛擬記憶體配置的資料結構等候取得鎖定期間發生。Occurs during a wait on lock acquisition for a data structure that is used to record all virtual memory allocations that come from CLR. 如果存在平行存取,資料結構就會鎖定,以便維持其完整性。The data structure is locked to maintain its integrity if there is parallel access.
CLR_MONITORCLR_MONITOR 當工作目前正在執行 CLR 執行,以及正在等候取得監視器鎖定時發生。Occurs when a task is currently performing CLR execution and is waiting to obtain a lock on the monitor.
CLR_RWLOCK_READERCLR_RWLOCK_READER 當工作目前正在執行 CLR 執行,以及正在等候讀取器鎖定時發生。Occurs when a task is currently performing CLR execution and is waiting for a reader lock.
CLR_RWLOCK_WRITERCLR_RWLOCK_WRITER 當工作目前正在執行 CLR 執行,以及正在等候寫入器鎖定時發生。Occurs when a task is currently performing CLR execution and is waiting for a writer lock.
CLR_SEMAPHORECLR_SEMAPHORE 當工作目前正在執行 CLR 執行,以及正在等候信號時發生。Occurs when a task is currently performing CLR execution and is waiting for a semaphore.
CLR_TASK_STARTCLR_TASK_START 在等候 CLR 工作完成啟動時發生。Occurs while waiting for a CLR task to complete startup.
CLRHOST_STATE_ACCESSCLRHOST_STATE_ACCESS 在等候取得 CLR 主控資料結構之獨佔存取權的情況下發生。Occurs where there is a wait to acquire exclusive access to the CLR-hosting data structures. 這種等候類型會在設定或終止 CLR 執行階段時發生。This wait type occurs while setting up or tearing down the CLR runtime.
CMEMPARTITIONEDCMEMPARTITIONED 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
CMEMTHREADCMEMTHREAD 當工作在安全執行緒記憶體物件待命時發生。Occurs when a task is waiting on a thread-safe memory object. 如果有多個工作嘗試從同一個記憶體物件配置記憶體而導致競爭情形時,等候時間可能會增加。The wait time might increase when there is contention caused by multiple tasks trying to allocate memory from the same memory object.
COLUMNSTORE_BUILD_THROTTLECOLUMNSTORE_BUILD_THROTTLE 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
COLUMNSTORE_COLUMNDATASET_SESSION_LISTCOLUMNSTORE_COLUMNDATASET_SESSION_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
COMMIT_TABLECOMMIT_TABLE 僅供內部使用。Internal use only.
CONNECTION_ENDPOINT_LOCKCONNECTION_ENDPOINT_LOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
COUNTRECOVERYMGRCOUNTRECOVERYMGR 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
CREATE_DATINISERVICECREATE_DATINISERVICE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
CXCONSUMERCXCONSUMER 當取用者執行緒等候生產者執行緒傳送資料列時,會發生平行查詢計劃。Occurs with parallel query plans when a consumer thread waits for a producer thread to send rows. 這是平行查詢執行的正常部分。This is a normal part of parallel query execution.
適用于SQL ServerSQL Server (從 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP2 開始,SQL Server 2017 (14.x)SQL Server 2017 (14.x) CU3),SQL DatabaseSQL DatabaseApplies to: SQL ServerSQL Server (Starting with SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP2, SQL Server 2017 (14.x)SQL Server 2017 (14.x) CU3), SQL DatabaseSQL Database
CXPACKETCXPACKET 在同步處理查詢處理器交換反覆運算器,以及產生和取用資料列時,會發生平行查詢計劃。Occurs with parallel query plans when synchronizing the query processor exchange iterator, and when producing and consuming rows. 如果等候時間過長,而且無法透過微調查詢 (例如加入索引) 來縮短,請考慮調整平行處理原則的成本臨界值,或降低平行處理原則的程度。If waiting is excessive and cannot be reduced by tuning the query (such as adding indexes), consider adjusting the cost threshold for parallelism or lowering the degree of parallelism.
注意:SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP2、SQL Server 2017 (14.x)SQL Server 2017 (14.x) CU3 和 SQL DatabaseSQL Database開始,CXPACKET 只是指同步處理查詢處理器交換反覆運算器,並為取用者執行緒產生資料列。Note: Starting with SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP2, SQL Server 2017 (14.x)SQL Server 2017 (14.x) CU3, and SQL DatabaseSQL Database, CXPACKET only refers to synchronizing the query processor exchange iterator, and to producing rows for consumer threads. 取用者執行緒會在 CXCONSUMER 等候類型中分開追蹤。Consumer threads are tracked separately in the CXCONSUMER wait type.
CXROWSET_SYNCCXROWSET_SYNC 在平行範圍掃描期間發生。Occurs during a parallel range scan.
DAC_INITDAC_INIT 當專用管理員連接正在初始化時發生。Occurs while the dedicated administrator connection is initializing.
DBCC_SCALE_OUT_EXPR_CACHEDBCC_SCALE_OUT_EXPR_CACHE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
DBMIRROR_DBM_EVENTDBMIRROR_DBM_EVENT 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
DBMIRROR_DBM_MUTEXDBMIRROR_DBM_MUTEX 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
DBMIRROR_EVENTS_QUEUEDBMIRROR_EVENTS_QUEUE 當資料庫鏡像在等候處理事件時發生。Occurs when database mirroring waits for events to process.
DBMIRROR_SENDDBMIRROR_SEND 當工作在網路層等候通訊積存清除,以傳送訊息時發生。Occurs when a task is waiting for a communications backlog at the network layer to clear to be able to send messages. 它指出通訊層已經開始多載,並影響到資料庫鏡像資料輸送量。Indicates that the communications layer is starting to become overloaded and affect the database mirroring data throughput.
DBMIRROR_WORKER_QUEUEDBMIRROR_WORKER_QUEUE 指出資料庫鏡像工作者工作正在等候其他工作。Indicates that the database mirroring worker task is waiting for more work.
DBMIRRORING_CMDDBMIRRORING_CMD 當工作在等候記錄排清到磁碟時發生。Occurs when a task is waiting for log records to be flushed to disk. 這個等候狀態預期會保留一段很長的時間。This wait state is expected to be held for long periods of time.
DBSEEDING_FLOWCONTROLDBSEEDING_FLOWCONTROL 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
DBSEEDING_OPERATIONDBSEEDING_OPERATION 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
DEADLOCK_ENUM_MUTEXDEADLOCK_ENUM_MUTEX 當鎖死監視器和 sys dm_os_waiting_tasks 嘗試確定 SQL Server 不會同時執行多個鎖死搜尋時發生。Occurs when the deadlock monitor and sys.dm_os_waiting_tasks try to make sure that SQL Server is not running multiple deadlock searches at the same time.
DEADLOCK_TASK_SEARCHDEADLOCK_TASK_SEARCH 在此資源上的等候時間如果很長,表示伺服器正在 sys.dm_os_waiting_tasks 之上執行查詢,而這些查詢則造成死結監視器無法執行死結搜尋。Large waiting time on this resource indicates that the server is executing queries on top of sys.dm_os_waiting_tasks, and these queries are blocking deadlock monitor from running deadlock search. 只有死結監視器才會使用這種等候類型。This wait type is used by deadlock monitor only. 在 sys.dm_os_waiting_tasks 之上的查詢會使用 DEADLOCK_ENUM_MUTEX。Queries on top of sys.dm_os_waiting_tasks use DEADLOCK_ENUM_MUTEX.
DEBUGDEBUG 在 Transact-sql 和 CLR 偵錯工具進行內部同步處理時發生。Occurs during Transact-SQL and CLR debugging for internal synchronization.
DIRECTLOGCONSUMER_LISTDIRECTLOGCONSUMER_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
DIRTY_PAGE_POLLDIRTY_PAGE_POLL 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
DIRTY_PAGE_SYNCDIRTY_PAGE_SYNC 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
DIRTY_PAGE_TABLE_LOCKDIRTY_PAGE_TABLE_LOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
DISABLE_VERSIONINGDISABLE_VERSIONING 當 SQL Server 輪詢版本交易管理員,查看最早使用中交易的時間戳記是否晚于狀態開始變更時的時間戳記時,就會發生。Occurs when SQL Server polls the version transaction manager to see whether the timestamp of the earliest active transaction is later than the timestamp of when the state started changing. 如果是這樣,則表示所有在 ALTER DATABASE 陳述式執行之前所啟動的快照集交易,已經全部完成了。If this is this case, all the snapshot transactions that were started before the ALTER DATABASE statement was run have finished. 當 SQL Server 使用 ALTER DATABASE 語句來停用版本控制時,就會使用這個等候狀態。This wait state is used when SQL Server disables versioning by using the ALTER DATABASE statement.
DISKIO_SUSPENDDISKIO_SUSPEND 當外部備份在使用中時,工作正在等候存取檔案時發生。Occurs when a task is waiting to access a file when an external backup is active. 這是針對每個等候中的使用者處理序所報告。This is reported for each waiting user process. 如果超過每個使用者處理序五次時,可能表示外部備份花了太多時間才完成。A count larger than five per user process may indicate that the external backup is taking too much time to finish.
DISPATCHER_PRIORITY_QUEUE_SEMAPHOREDISPATCHER_PRIORITY_QUEUE_SEMAPHORE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
DISPATCHER_QUEUE_SEMAPHOREDISPATCHER_QUEUE_SEMAPHORE 當發送器集區的執行緒正在等候處理其他工作時發生。Occurs when a thread from the dispatcher pool is waiting for more work to process. 這種等候類型的等候時間應該會在發送器閒置時增加。The wait time for this wait type is expected to increase when the dispatcher is idle.
DLL_LOADING_MUTEXDLL_LOADING_MUTEX 在等候 XML 剖析器 DLL 載入時發生一次。Occurs once while waiting for the XML parser DLL to load.
DPT_ENTRY_LOCKDPT_ENTRY_LOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
DROP_DATABASE_TIMER_TASKDROP_DATABASE_TIMER_TASK 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
DROPTEMPDROPTEMP 卸除暫存物件時,如果前一次的嘗試失敗,就會在兩次嘗試之間發生這種等候類型。Occurs between attempts to drop a temporary object if the previous attempt failed. 等候持續時間將以指數方式,隨著每一次的卸除嘗試失敗而增加。The wait duration grows exponentially with each failed drop attempt.
DTCDTC 當工作在服務管理狀態轉移所用的事件時發生。Occurs when a task is waiting on an event that is used to manage state transition. 此狀態控制在收到 MS DTC 服務無法使用的通知 SQL Server 之後,Microsoft 分散式交易協調器(MS DTC)交易的復原時機。This state controls when the recovery of Microsoft Distributed Transaction Coordinator (MS DTC) transactions occurs after SQL Server receives notification that the MS DTC service has become unavailable.
DTC_ABORT_REQUESTDTC_ABORT_REQUEST 當工作階段在等候接收 MS DTC 交易的擁有權時,在 MS DTC 工作者工作階段發生。Occurs in a MS DTC worker session when the session is waiting to take ownership of a MS DTC transaction. MS DTC 擁有交易之後,工作階段就可以回復該交易。After MS DTC owns the transaction, the session can roll back the transaction. 通常,工作階段會等候另一個使用該交易的工作階段。Generally, the session will wait for another session that is using the transaction.
DTC_RESOLVEDTC_RESOLVE 當復原工作在等候跨資料庫交易中的 master 資料庫,讓工作得以查詢交易結果時發生。Occurs when a recovery task is waiting for the master database in a cross-database transaction so that the task can query the outcome of the transaction.
DTC_STATEDTC_STATE 當工作在保護您對內部 MS DTC 全域狀態物件所做變更的事件待命時發生。Occurs when a task is waiting on an event that protects changes to the internal MS DTC global state object. 這個狀態的保留時間很短。This state should be held for very short periods of time.
DTC_TMDOWN_REQUESTDTC_TMDOWN_REQUEST 當 SQL Server 收到 MS DTC 服務無法使用的通知時,在 MS DTC 背景工作會話中發生。Occurs in a MS DTC worker session when SQL Server receives notification that the MS DTC service is not available. 首先,工作者會等候 MS DTC 復原處理序啟動。First, the worker will wait for the MS DTC recovery process to start. 接著,工作者會等候取得他所處理的分散式交易結果。Then, the worker waits to obtain the outcome of the distributed transaction that the worker is working on. 除非與 MS DTC 服務的連接已經重新建立,否則這項作業會繼續進行。This may continue until the connection with the MS DTC service has been reestablished.
DTC_WAITFOR_OUTCOMEDTC_WAITFOR_OUTCOME 當復原工作在等候 MS DTC 開始解析準備交易時發生。Occurs when recovery tasks wait for MS DTC to become active to enable the resolution of prepared transactions.
DTCNEW_ENLISTDTCNEW_ENLIST 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
DTCNEW_PREPAREDTCNEW_PREPARE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
DTCNEW_RECOVERYDTCNEW_RECOVERY 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
DTCNEW_TMDTCNEW_TM 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
DTCNEW_TRANSACTION_ENLISTMENTDTCNEW_TRANSACTION_ENLISTMENT 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
DTCPNTSYNCDTCPNTSYNC 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
DUMP_LOG_COORDINATORDUMP_LOG_COORDINATOR 當主要工作正在等候子工作產生資料時發生。Occurs when a main task is waiting for a subtask to generate data. 這個狀態通常不會發生。Ordinarily, this state does not occur. 如果等候時間很長,就表示發生了非預期的封鎖。A long wait indicates an unexpected blockage. 您最好調查一下子工作。The subtask should be investigated.
DUMP_LOG_COORDINATOR_QUEUEDUMP_LOG_COORDINATOR_QUEUE 僅供內部使用。Internal use only.
DUMPTRIGGERDUMPTRIGGER 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
ECEC 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
EE_PMOLOCKEE_PMOLOCK 在陳述式執行期間同步處理某些類型的記憶體配置時發生。Occurs during synchronization of certain types of memory allocations during statement execution.
EE_SPECPROC_MAP_INITEE_SPECPROC_MAP_INIT 在同步處理內部程序雜湊表的建立時發生。Occurs during synchronization of internal procedure hash table creation. 只有在 SQL Server 實例啟動之後,初始存取雜湊資料表時,才會發生這種等候。This wait can only occur during the initial accessing of the hash table after the SQL Server instance starts.
ENABLE_EMPTY_VERSIONINGENABLE_EMPTY_VERSIONING 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
ENABLE_VERSIONINGENABLE_VERSIONING 當 SQL Server 等候這個資料庫中的所有更新交易完成,然後才宣告資料庫準備好轉換成快照隔離允許狀態時,就會發生這種情況。Occurs when SQL Server waits for all update transactions in this database to finish before declaring the database ready to transition to snapshot isolation allowed state. 當 SQL Server 使用 ALTER DATABASE 語句來啟用快照集隔離時,會使用此狀態。This state is used when SQL Server enables snapshot isolation by using the ALTER DATABASE statement.
ERROR_REPORTING_MANAGERERROR_REPORTING_MANAGER 在同步處理多個並行錯誤記錄檔的初始化時發生。Occurs during synchronization of multiple concurrent error log initializations.
EXCHANGEEXCHANGE 在平行查詢期間同步處理查詢處理器交換重複時發生。Occurs during synchronization in the query processor exchange iterator during parallel queries.
EXECSYNCEXECSYNC 平行查詢期間在與交換重複無關之區域的查詢處理器中進行同步處理時發生。Occurs during parallel queries while synchronizing in query processor in areas not related to the exchange iterator. 這類區域的範例包括點陣圖、大型二進位物件 (LOB) 和多工緩衝處理重複。Examples of such areas are bitmaps, large binary objects (LOBs), and the spool iterator. LOB 可能會經常使用這個等候狀態。LOBs may frequently use this wait state.
EXECUTION_PIPE_EVENT_INTERNALEXECUTION_PIPE_EVENT_INTERNAL 在透過連接內容傳送的批次執行產生者與取用者部分之間同步處理期間發生。Occurs during synchronization between producer and consumer parts of batch execution that are submitted through the connection context.
EXTERNAL_RG_UPDATEEXTERNAL_RG_UPDATE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
EXTERNAL_SCRIPT_NETWORK_IOEXTERNAL_SCRIPT_NETWORK_IO 僅供內部使用。Internal use only.
適用于:透過 current SQL Server 2017 (14.x)SQL Server 2017 (14.x)Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through current.
EXTERNAL_SCRIPT_PREPARE_SERVICEEXTERNAL_SCRIPT_PREPARE_SERVICE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
EXTERNAL_SCRIPT_SHUTDOWNEXTERNAL_SCRIPT_SHUTDOWN 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
EXTERNAL_WAIT_ON_LAUNCHER、EXTERNAL_WAIT_ON_LAUNCHER, 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
FABRIC_HADR_TRANSPORT_CONNECTIONFABRIC_HADR_TRANSPORT_CONNECTION 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
FABRIC_REPLICA_CONTROLLER_LISTFABRIC_REPLICA_CONTROLLER_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIGFABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
FABRIC_REPLICA_PUBLISHER_EVENT_PUBLISHFABRIC_REPLICA_PUBLISHER_EVENT_PUBLISH 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LISTFABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSINGFABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
FAILPOINTFAILPOINT 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
FCB_REPLICA_READFCB_REPLICA_READ 在同步處理快照集 (或 DBCC 所建立的暫時快照集) 疏鬆檔案的讀取作業時發生。Occurs when the reads of a snapshot (or a temporary snapshot created by DBCC) sparse file are synchronized.
FCB_REPLICA_WRITEFCB_REPLICA_WRITE 在同步處理將資料頁發送或提取到快照集 (或 DBCC 所建立的暫時快照集) 疏鬆檔案時發生。Occurs when the pushing or pulling of a page to a snapshot (or a temporary snapshot created by DBCC) sparse file is synchronized.
FEATURE_SWITCHES_UPDATEFEATURE_SWITCHES_UPDATE 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
FFT_NSO_DB_KILL_FLAGFFT_NSO_DB_KILL_FLAG 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_NSO_DB_LISTFFT_NSO_DB_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_NSO_FCBFFT_NSO_FCB 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_NSO_FCB_FINDFFT_NSO_FCB_FIND 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_NSO_FCB_PARENTFFT_NSO_FCB_PARENT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_NSO_FCB_RELEASE_CACHED_ENTRIESFFT_NSO_FCB_RELEASE_CACHED_ENTRIES 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_NSO_FCB_STATEFFT_NSO_FCB_STATE 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
FFT_NSO_FILEOBJECTFFT_NSO_FILEOBJECT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_NSO_TABLE_LISTFFT_NSO_TABLE_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_NTFS_STOREFFT_NTFS_STORE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_RECOVERYFFT_RECOVERY 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_RSFX_COMMFFT_RSFX_COMM 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_RSFX_WAIT_FOR_MEMORYFFT_RSFX_WAIT_FOR_MEMORY 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_STARTUP_SHUTDOWNFFT_STARTUP_SHUTDOWN 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_STORE_DBFFT_STORE_DB 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_STORE_ROWSET_LISTFFT_STORE_ROWSET_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FFT_STORE_TABLEFFT_STORE_TABLE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FILE_VALIDATION_THREADSFILE_VALIDATION_THREADS 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
FILESTREAM_CACHEFILESTREAM_CACHE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FILESTREAM_CHUNKERFILESTREAM_CHUNKER 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FILESTREAM_CHUNKER_INITFILESTREAM_CHUNKER_INIT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FILESTREAM_FCBFILESTREAM_FCB 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FILESTREAM_FILE_OBJECTFILESTREAM_FILE_OBJECT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FILESTREAM_WORKITEM_QUEUEFILESTREAM_WORKITEM_QUEUE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FILETABLE_SHUTDOWNFILETABLE_SHUTDOWN 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FOREIGN_REDOFOREIGN_REDO 僅供內部使用。Internal use only.
適用于:透過 current SQL Server 2017 (14.x)SQL Server 2017 (14.x)Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through current.
FORWARDER_TRANSITIONFORWARDER_TRANSITION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
FS_FC_RWLOCKFS_FC_RWLOCK 當 FILESTREAM 記憶體回收行程等候進行下列其中一項作業時發生:Occurs when there is a wait by the FILESTREAM garbage collector to do either of the following:
FS_GARBAGE_COLLECTOR_SHUTDOWNFS_GARBAGE_COLLECTOR_SHUTDOWN 當 FILESTREAM 記憶體回收行程正在等候清除工作完成時發生。Occurs when the FILESTREAM garbage collector is waiting for cleanup tasks to be completed.
FS_HEADER_RWLOCKFS_HEADER_RWLOCK 當系統等候取得 FILESTREAM 資料容器之 FILESTREAM 標頭的存取權來讀取或更新 FILESTREAM 標頭檔 (Filestream.hdr) 內容時發生。Occurs when there is a wait to acquire access to the FILESTREAM header of a FILESTREAM data container to either read or update contents in the FILESTREAM header file (Filestream.hdr).
FS_LOGTRUNC_RWLOCKFS_LOGTRUNC_RWLOCK 當系統等候取得 FILESTREAM 記錄截斷的存取權來進行下列其中一項作業時發生:Occurs when there is a wait to acquire access to FILESTREAM log truncation to do either of the following:
FSA_FORCE_OWN_XACTFSA_FORCE_OWN_XACT 當 FILESTREAM 檔案 I/O 作業需要繫結至相關聯的交易,但是此交易目前由其他工作階段所擁有時發生。Occurs when a FILESTREAM file I/O operation needs to bind to the associated transaction, but the transaction is currently owned by another session.
FSAGENTFSAGENT 當 FILESTREAM 檔案 I/O 作業正在等候其他檔案 I/O 作業所使用的 FILESTREAM 代理程式資源時發生。Occurs when a FILESTREAM file I/O operation is waiting for a FILESTREAM agent resource that is being used by another file I/O operation.
FSTR_CONFIG_MUTEXFSTR_CONFIG_MUTEX 當系統等候其他 FILESTREAM 功能重新設定完成時發生。Occurs when there is a wait for another FILESTREAM feature reconfiguration to be completed.
FSTR_CONFIG_RWLOCKFSTR_CONFIG_RWLOCK 當系統等候序列化 FILESTREAM 組態參數的存取權時發生。Occurs when there is a wait to serialize access to the FILESTREAM configuration parameters.
FT_COMPROWSET_RWLOCKFT_COMPROWSET_RWLOCK 全文檢索正在等候片段中繼資料作業。Full-text is waiting on fragment metadata operation. 記載僅供參考之用。Documented for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
FT_IFTS_RWLOCKFT_IFTS_RWLOCK 全文檢索正在等候內部的同步處理。Full-text is waiting on internal synchronization. 記載僅供參考之用。Documented for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
FT_IFTS_SCHEDULER_IDLE_WAITFT_IFTS_SCHEDULER_IDLE_WAIT 全文檢索排程器睡眠等候類型。Full-text scheduler sleep wait type. 排程器閒置中。The scheduler is idle.
FT_IFTSHC_MUTEXFT_IFTSHC_MUTEX 全文檢索正在等候 fdhost 控制項作業。Full-text is waiting on an fdhost control operation. 記載僅供參考之用。Documented for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
FT_IFTSISM_MUTEXFT_IFTSISM_MUTEX 全文檢索正在等候通訊作業。Full-text is waiting on communication operation. 記載僅供參考之用。Documented for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
FT_MASTER_MERGEFT_MASTER_MERGE 全文檢索正在等候主要合併作業。Full-text is waiting on master merge operation. 記載僅供參考之用。Documented for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
FT_MASTER_MERGE_COORDINATORFT_MASTER_MERGE_COORDINATOR 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FT_METADATA_MUTEXFT_METADATA_MUTEX 記載僅供參考之用。Documented for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
FT_PROPERTYLIST_CACHEFT_PROPERTYLIST_CACHE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
FT_RESTART_CRAWLFT_RESTART_CRAWL 在全文檢索搜耙必須從最後一個已知的恰當起點重新啟動以便從暫時性失敗中復原時發生。Occurs when a full-text crawl needs to restart from a last known good point to recover from a transient failure. 等候可讓目前正在處理該母體擴展的工作者工作得以完成或結束目前的步驟。The wait lets the worker tasks currently working on that population to complete or exit the current step.
FULLTEXT GATHERERFULLTEXT GATHERER 在同步處理全文檢索作業時發生。Occurs during synchronization of full-text operations.
GDMA_GET_RESOURCE_OWNERGDMA_GET_RESOURCE_OWNER 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
GHOSTCLEANUP_UPDATE_STATSGHOSTCLEANUP_UPDATE_STATS 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
GHOSTCLEANUPSYNCMGRGHOSTCLEANUPSYNCMGR 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
GLOBAL_QUERY_CANCELGLOBAL_QUERY_CANCEL 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
GLOBAL_QUERY_CLOSEGLOBAL_QUERY_CLOSE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
GLOBAL_QUERY_CONSUMERGLOBAL_QUERY_CONSUMER 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
GLOBAL_QUERY_PRODUCERGLOBAL_QUERY_PRODUCER 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
GLOBAL_TRAN_CREATEGLOBAL_TRAN_CREATE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
GLOBAL_TRAN_UCS_SESSIONGLOBAL_TRAN_UCS_SESSION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
GUARDIANGUARDIAN 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
HADR_AG_MUTEXHADR_AG_MUTEX 在 Always On DDL 語句或 Windows Server 容錯移轉叢集命令等候可用性群組的設定獨佔讀取/寫入權限時發生。Occurs when an Always On DDL statement or Windows Server Failover Clustering command is waiting for exclusive read/write access to the configuration of an availability group.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_AR_CRITICAL_SECTION_ENTRYHADR_AR_CRITICAL_SECTION_ENTRY 在 Always On DDL 語句或 Windows Server 容錯移轉叢集命令等候關聯可用性群組的本機複本之執行時間狀態的獨佔讀取/寫入存取時發生。Occurs when an Always On DDL statement or Windows Server Failover Clustering command is waiting for exclusive read/write access to the runtime state of the local replica of the associated availability group.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_AR_MANAGER_MUTEXHADR_AR_MANAGER_MUTEX 在可用性複本關閉等候啟動完成或者可用性複本啟動等候關閉完成時發生。Occurs when an availability replica shutdown is waiting for startup to complete or an availability replica startup is waiting for shutdown to complete. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_AR_UNLOAD_COMPLETEDHADR_AR_UNLOAD_COMPLETED 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LISTHADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST 可用性複本事件 (例如狀態變更或組態變更) 的發行者正在等候事件訂閱者清單的獨佔讀取/寫入存取權。The publisher for an availability replica event (such as a state change or configuration change) is waiting for exclusive read/write access to the list of event subscribers. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_BACKUP_BULK_LOCKHADR_BACKUP_BULK_LOCK Always On 主資料庫收到來自次要資料庫的備份要求,而且正在等候背景執行緒完成取得或釋放 BulkOp 鎖定的要求處理。The Always On primary database received a backup request from a secondary database and is waiting for the background thread to finish processing the request on acquiring or releasing the BulkOp lock.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_BACKUP_QUEUEHADR_BACKUP_QUEUE Always On 主資料庫的備份背景執行緒正在等候來自次要資料庫的新工作要求。The backup background thread of the Always On primary database is waiting for a new work request from the secondary database. (一般而言,當主資料庫持有 BulkOp 記錄,而且正在等候次要資料庫指出主資料庫可以釋放鎖定)時,就會發生這種情況。(typically, this occurs when the primary database is holding the BulkOp log and is waiting for the secondary database to indicate that the primary database can release the lock).,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_CLUSAPI_CALLHADR_CLUSAPI_CALL SQL Server 執行緒正在等候從非先占式模式(由 SQL Server 排程)切換為先占式模式(由作業系統排程),以便叫用 Windows Server 容錯移轉叢集 Api。A SQL Server thread is waiting to switch from non-preemptive mode (scheduled by SQL Server) to preemptive mode (scheduled by the operating system) in order to invoke Windows Server Failover Clustering APIs.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_COMPRESSED_CACHE_SYNCHADR_COMPRESSED_CACHE_SYNC 等待存取壓縮記錄檔區塊的快取,以避免對傳送至多個次要資料庫的記錄區塊進行重複的壓縮。Waiting for access to the cache of compressed log blocks that is used to avoid redundant compression of the log blocks sent to multiple secondary databases.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_CONNECTIVITY_INFOHADR_CONNECTIVITY_INFO 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DATABASE_FLOW_CONTROLHADR_DATABASE_FLOW_CONTROL 在已達佇列訊息的數目上限時,等候要傳送至夥伴的訊息。Waiting for messages to be sent to the partner when the maximum number of queued messages has been reached. 表示記錄掃描的執行速度比網路傳送的速度要快。Indicates that the log scans are running faster than the network sends. 只有當網路傳送速度比預期慢時,才會發生此問題。This is an issue only if network sends are slower than expected.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DATABASE_VERSIONING_STATEHADR_DATABASE_VERSIONING_STATE 在 Always On 次要資料庫的版本設定狀態變更時發生。Occurs on the versioning state change of an Always On secondary database. 這種等候適用于內部資料結構,而且通常非常短,而且不會直接影響資料存取。This wait is for internal data structures and is usually is very short with no direct effect on data access.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DATABASE_WAIT_FOR_RECOVERYHADR_DATABASE_WAIT_FOR_RECOVERY 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_DATABASE_WAIT_FOR_RESTARTHADR_DATABASE_WAIT_FOR_RESTART 正在等候資料庫在 Always On 可用性群組控制之下重新開機。Waiting for the database to restart under Always On Availability Groups control. 在正常情況下,這不是客戶問題,因為這裡應該會有等待。Under normal conditions, this is not a customer issue because waits are expected here.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONINGHADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING 當次要複本已啟用讀取工作負載時,資料列版本設定會封鎖在 Always On 可用性群組之可讀取的次要資料庫中,對物件進行的查詢。A query on object(s) in a readable secondary database of an Always On availability group is blocked on row versioning while waiting for commit or rollback of all transactions that were in-flight when the secondary replica was enabled for read workloads. 這種等候類型保證在快照集隔離下執行查詢之前,可以使用資料列版本。This wait type guarantees that row versions are available before execution of a query under snapshot isolation.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DB_COMMANDHADR_DB_COMMAND 等候交談訊息的回應(這需要另一端的明確回應,使用 Always On 對話訊息基礎結構)。Waiting for responses to conversational messages (which require an explicit response from the other side, using the Always On conversational message infrastructure). 有數種不同的訊息類型會使用這種等候類型。A number of different message types use this wait type.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DB_OP_COMPLETION_SYNCHADR_DB_OP_COMPLETION_SYNC 等候交談訊息的回應(這需要另一端的明確回應,使用 Always On 對話訊息基礎結構)。Waiting for responses to conversational messages (which require an explicit response from the other side, using the Always On conversational message infrastructure). 有數種不同的訊息類型會使用這種等候類型。A number of different message types use this wait type.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DB_OP_START_SYNCHADR_DB_OP_START_SYNC Always On DDL 語句或 Windows Server 容錯移轉叢集命令正在等候可用性資料庫及其執行時間狀態的序列化存取。An Always On DDL statement or a Windows Server Failover Clustering command is waiting for serialized access to an availability database and its runtime state.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DBR_SUBSCRIBERHADR_DBR_SUBSCRIBER 可用性複本事件 (例如狀態變更或組態變更) 的發行者正在等候對應至可用性資料庫之事件訂閱者執行階段狀態的獨佔讀取/寫入存取權。The publisher for an availability replica event (such as a state change or configuration change) is waiting for exclusive read/write access to the runtime state of an event subscriber that corresponds to an availability database. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DBR_SUBSCRIBER_FILTER_LISTHADR_DBR_SUBSCRIBER_FILTER_LIST 可用性複本事件 (例如狀態變更或組態變更) 的發行者正在等候對應至可用性資料庫之事件訂閱者清單的獨佔讀取/寫入存取權。The publisher for an availability replica event (such as a state change or configuration change) is waiting for exclusive read/write access to the list of event subscribers that correspond to availability databases. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_DBSEEDINGHADR_DBSEEDING 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
HADR_DBSEEDING_LISTHADR_DBSEEDING_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
HADR_DBSTATECHANGE_SYNCHADR_DBSTATECHANGE_SYNC 並行控制等候更新資料庫複本的內部狀態。Concurrency control wait for updating the internal state of the database replica.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_FABRIC_CALLBACKHADR_FABRIC_CALLBACK 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
HADR_FILESTREAM_BLOCK_FLUSHHADR_FILESTREAM_BLOCK_FLUSH FILESTREAM Always On 傳輸管理員正在等候,直到記錄區塊的處理完成為止。The FILESTREAM Always On transport manager is waiting until processing of a log block is finished.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_FILESTREAM_FILE_CLOSEHADR_FILESTREAM_FILE_CLOSE FILESTREAM Always On 傳輸管理員正在等候,直到下一個 FILESTREAM 檔案處理完畢,且其控制碼已關閉為止。The FILESTREAM Always On transport manager is waiting until the next FILESTREAM file gets processed and its handle gets closed.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_FILESTREAM_FILE_REQUESTHADR_FILESTREAM_FILE_REQUEST Always On 次要複本正在等候主要複本在復原期間傳送所有要求的 FILESTREAM 檔案。An Always On secondary replica is waiting for the primary replica to send all requested FILESTREAM files during UNDO.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_FILESTREAM_IOMGRHADR_FILESTREAM_IOMGR FILESTREAM Always On 傳輸管理員正在等候 R/W 鎖定,以便在啟動或關閉期間保護 FILESTREAM Always On i/o 管理員。The FILESTREAM Always On transport manager is waiting for R/W lock that protects the FILESTREAM Always On I/O manager during startup or shutdown.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_FILESTREAM_IOMGR_IOCOMPLETIONHADR_FILESTREAM_IOMGR_IOCOMPLETION FILESTREAM Always On i/o 管理員正在等候 i/o 完成。The FILESTREAM Always On I/O manager is waiting for I/O completion.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_FILESTREAM_MANAGERHADR_FILESTREAM_MANAGER FILESTREAM Always On 傳輸管理員正在等候 R/W 鎖定,以便在啟動或關閉期間保護 FILESTREAM Always On 傳輸管理員。The FILESTREAM Always On transport manager is waiting for the R/W lock that protects the FILESTREAM Always On transport manager during startup or shutdown.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_FILESTREAM_PREPROCHADR_FILESTREAM_PREPROC 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_GROUP_COMMITHADR_GROUP_COMMIT 交易認可處理正在等候允許群組認可,以便將多個認可記錄檔記錄放入單一記錄檔區塊中。Transaction commit processing is waiting to allow a group commit so that multiple commit log records can be put into a single log block. 這種等候是將記錄檔 i/o、capture 和 send 作業優化的預期條件。This wait is an expected condition that optimizes the log I/O, capture, and send operations.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_LOGCAPTURE_SYNCHADR_LOGCAPTURE_SYNC 有關建立或終結掃描時記錄擷取或套用物件的並行控制。Concurrency control around the log capture or apply object when creating or destroying scans. 當合作夥伴變更狀態或連接狀態時,這是預期的等候。This is an expected wait when partners change state or connection status.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_LOGCAPTURE_WAITHADR_LOGCAPTURE_WAIT 等候記錄檔記錄變成可用。Waiting for log records to become available. 如果讀取不在快取中的記錄,等候連接產生新的記錄檔記錄或 I/O 完成時就可能會發生這種狀況。Can occur either when waiting for new log records to be generated by connections or for I/O completion when reading log not in the cache. 這是預期的等候,如果記錄檔掃描直到記錄檔的結尾或正在從磁片讀取。This is an expected wait if the log scan is caught up to the end of log or is reading from disk.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_LOGPROGRESS_SYNCHADR_LOGPROGRESS_SYNC 更新資料庫複本的記錄進度狀態時,並行控制等候。Concurrency control wait when updating the log progress status of database replicas.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_NOTIFICATION_DEQUEUEHADR_NOTIFICATION_DEQUEUE 處理 Windows Server 容錯移轉叢集通知的背景工作正在等候下一個通知。A background task that processes Windows Server Failover Clustering notifications is waiting for the next notification. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESSHADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESS Always On 可用性複本管理員正在等候處理 Windows Server 容錯移轉叢集通知之背景工作執行時間狀態的序列化存取。The Always On availability replica manager is waiting for serialized access to the runtime state of a background task that processes Windows Server Failover Clustering notifications. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_NOTIFICATION_WORKER_STARTUP_SYNCHADR_NOTIFICATION_WORKER_STARTUP_SYNC 背景工作正在等候處理 Windows Server 容錯移轉叢集通知的背景工作啟動完成。A background task is waiting for the completion of the startup of a background task that processes Windows Server Failover Clustering notifications. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_NOTIFICATION_WORKER_TERMINATION_SYNCHADR_NOTIFICATION_WORKER_TERMINATION_SYNC 背景工作正在等候處理 Windows Server 容錯移轉叢集通知的背景工作終止。A background task is waiting for the termination of a background task that processes Windows Server Failover Clustering notifications. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_PARTNER_SYNCHADR_PARTNER_SYNC 夥伴清單上的並行控制等候。Concurrency control wait on the partner list.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_READ_ALL_NETWORKSHADR_READ_ALL_NETWORKS 等候取得 WSFC 網路清單的讀取或寫入存取權。Waiting to get read or write access to the list of WSFC networks. 僅供內部使用。Internal use only. 注意:引擎會保留用於動態管理檢視中的 WSFC 網路清單(例如 sys. dm_hadr_cluster_networks),或用來驗證參考 WSFC 網路資訊的 Always On Transact-sql 語句。Note: The engine keeps a list of WSFC networks that is used in dynamic management views (such as sys.dm_hadr_cluster_networks) or to validate Always On Transact-SQL statements that reference WSFC network information. 這份清單會在引擎啟動、WSFC 相關的通知和內部 Always On 重新開機(例如,失去和重新取得 WSFC 仲裁)時更新。This list is updated upon engine startup, WSFC related notifications, and internal Always On restart (for example, losing and regaining of WSFC quorum). 當該清單的更新正在進行時,通常會封鎖工作。Tasks will usually be blocked when an update in that list is in progress. ,,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_RECOVERY_WAIT_FOR_CONNECTIONHADR_RECOVERY_WAIT_FOR_CONNECTION 等候次要資料庫在執行復原之前連接到主要資料庫。Waiting for the secondary database to connect to the primary database before running recovery. 這是預期的等候,如果與主要複本的連線速度很慢,則可能會延長。This is an expected wait, which can lengthen if the connection to the primary is slow to establish.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_RECOVERY_WAIT_FOR_UNDOHADR_RECOVERY_WAIT_FOR_UNDO 資料庫復原正在等候次要資料庫完成還原和初始化階段,以便讓它返回與主要資料庫相同的記錄點。Database recovery is waiting for the secondary database to finish the reverting and initializing phase to bring it back to the common log point with the primary database. 這是在容錯移轉之後預期的等候。您可以透過 Windows 系統監視器(perfmon)和動態管理檢視來追蹤復原進度。This is an expected wait after failovers.Undo progress can be tracked through the Windows System Monitor (perfmon.exe) and dynamic management views.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_REPLICAINFO_SYNCHADR_REPLICAINFO_SYNC 正在等候並行存取控制更新目前的複本狀態。Waiting for concurrency control to update the current replica state.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_SEEDING_CANCELLATIONHADR_SEEDING_CANCELLATION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_SEEDING_FILE_LISTHADR_SEEDING_FILE_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_SEEDING_LIMIT_BACKUPSHADR_SEEDING_LIMIT_BACKUPS 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_SEEDING_SYNC_COMPLETIONHADR_SEEDING_SYNC_COMPLETION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_SEEDING_TIMEOUT_TASKHADR_SEEDING_TIMEOUT_TASK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_SEEDING_WAIT_FOR_COMPLETIONHADR_SEEDING_WAIT_FOR_COMPLETION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_SYNC_COMMITHADR_SYNC_COMMIT 等候已同步處理之次要資料庫的交易認可處理強行寫入記錄。Waiting for transaction commit processing for the synchronized secondary databases to harden the log. Transaction Delay 效能計數器也會反映這項等候。This wait is also reflected by the Transaction Delay performance counter. 同步處理的可用性群組必須要有這種等候類型,並指出傳送、寫入和認可記錄到次要資料庫的時間。This wait type is expected for synchronized availability groups and indicates the time to send, write, and acknowledge log to the secondary databases.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_SYNCHRONIZING_THROTTLEHADR_SYNCHRONIZING_THROTTLE 等候交易認可處理允許同步處理中的次要資料庫趕上主要記錄結尾,以便轉換成已同步處理的狀態。Waiting for transaction commit processing to allow a synchronizing secondary database to catch up to the primary end of log in order to transition to the synchronized state. 當次要資料庫即將趕上時,這是預期的等候。This is an expected wait when a secondary database is catching up.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_TDS_LISTENER_SYNCHADR_TDS_LISTENER_SYNC 內部 Always On 系統或 WSFC 叢集會要求接聽程式已啟動或停止。Either the internal Always On system or the WSFC cluster will request that listeners are started or stopped. 這項要求的處理方式一律為非同步,而且具有移除重複要求的機制。The processing of this request is always asynchronous, and there is a mechanism to remove redundant requests. 此外,這個處理序有時候會由於組態變更而暫停。There are also moments that this process is suspended because of configuration changes. 與此接聽程式同步處理機制相關的所有等候都會使用此等候類型。All waits related with this listener synchronization mechanism use this wait type. 僅供內部使用。Internal use only.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_TDS_LISTENER_SYNC_PROCESSINGHADR_TDS_LISTENER_SYNC_PROCESSING 在需要啟動和/或停止可用性群組接聽程式的 Always On Transact-sql 語句的結尾處使用。Used at the end of an Always On Transact-SQL statement that requires starting and/or stopping an availability group listener. 由於啟動/停止作業是以非同步方式完成,使用者執行緒將會封鎖使用此等候類型,直到知道接聽程式的情況為止。Since the start/stop operation is done asynchronously, the user thread will block using this wait type until the situation of the listener is known.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_THROTTLE_LOG_RATE_GOVERNORHADR_THROTTLE_LOG_RATE_GOVERNOR 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HADR_THROTTLE_LOG_RATE_MISMATCHED_SLOHADR_THROTTLE_LOG_RATE_MISMATCHED_SLO 當異地複寫次要資料庫的計算大小(較低的 SLO)設定為低於主要複本時發生。Occurs when a geo-replication secondary is configured with lower compute size (lower SLO) than the primary. 主資料庫因為次要的延遲記錄耗用量而受到節流。A primary database is throttled due to delayed log consumption by the secondary. 這是因為次要資料庫的計算容量不足,而無法跟上主資料庫的變更率。This is caused by the secondary database having insufficient compute capacity to keep up with the primary database's rate of change.
適用于: Azure SQL DatabaseApplies to: Azure SQL Database
HADR_THROTTLE_LOG_RATE_LOG_SIZEHADR_THROTTLE_LOG_RATE_LOG_SIZE 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
HADR_THROTTLE_LOG_RATE_SEEDINGHADR_THROTTLE_LOG_RATE_SEEDING 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
HADR_THROTTLE_LOG_RATE_SEND_RECV_QUEUE_SIZEHADR_THROTTLE_LOG_RATE_SEND_RECV_QUEUE_SIZE 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
HADR_TIMER_TASKHADR_TIMER_TASK 等候取得計時器工作物件的鎖定,而且也會用於工作執行間隔的實際等候。Waiting to get the lock on the timer task object and is also used for the actual waits between times that work is being performed. 例如,對於每隔10秒執行一次的工作,Always On 可用性群組會等待約10秒來重新排程工作,並在此包含等候。For example, for a task that runs every 10 seconds, after one execution, Always On Availability Groups waits about 10 seconds to reschedule the task, and the wait is included here.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_TRANSPORT_DBRLISTHADR_TRANSPORT_DBRLIST 等候傳輸層之資料庫複本清單的存取權。Waiting for access to the transport layer's database replica list. 用於授與存取權的 spinlock。Used for the spinlock that grants access to it.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_TRANSPORT_FLOW_CONTROLHADR_TRANSPORT_FLOW_CONTROL 等待未完成的未認可 Always On 訊息數目超過輸出流量控制閾值時。Waiting when the number of outstanding unacknowledged Always On messages is over the out flow control threshold. 這是基於可用性複本到複本的基礎(不是以資料庫到資料庫為基礎)。This is on an availability replica-to-replica basis (not on a database-to-database basis).,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_TRANSPORT_SESSIONHADR_TRANSPORT_SESSION Always On 可用性群組正在等待變更或存取基礎傳輸狀態。Always On Availability Groups is waiting while changing or accessing the underlying transport state.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_WORK_POOLHADR_WORK_POOL 並行控制等候 Always On 可用性群組背景工作物件。,Concurrency control wait on the Always On Availability Groups background work task object.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_WORK_QUEUEHADR_WORK_QUEUE Always On 可用性群組背景工作者執行緒,等待指派新工作。Always On Availability Groups background worker thread waiting for new work to be assigned. 當備妥的工作者等待新工作(也就是正常狀態)時,這是預期的等候。This is an expected wait when there are ready workers waiting for new work, which is the normal state.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HADR_XRF_STACK_ACCESSHADR_XRF_STACK_ACCESS 存取(查閱、加入和刪除) Always On 可用性資料庫的擴充復原分支堆疊。Accessing (look up, add, and delete) the extended recovery fork stack for an Always On availability database.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HCCO_CACHEHCCO_CACHE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HK_RESTORE_FILEMAPHK_RESTORE_FILEMAP 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HKCS_PARALLEL_MIGRATIONHKCS_PARALLEL_MIGRATION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HKCS_PARALLEL_RECOVERYHKCS_PARALLEL_RECOVERY 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
HTBUILDHTBUILD 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HTDELETEHTDELETE 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
HTMEMOHTMEMO 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
HTREINITHTREINIT 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
HTREPARTITIONHTREPARTITION 在同步處理在批次模式運算子內輸入不同處理階段的執行緒時發生。Occurs during synchronization of threads entering different processing stages inside a batch mode operator.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
HTTP_ENUMERATIONHTTP_ENUMERATION 在啟動以列舉 HTTP 端點來啟動 HTTP 時發生。Occurs at startup to enumerate the HTTP endpoints to start HTTP.
HTTP_STARTHTTP_START 在連接等候 HTTP 完成初始化時發生。Occurs when a connection is waiting for HTTP to complete initialization.
HTTP_STORAGE_CONNECTIONHTTP_STORAGE_CONNECTION 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
IMPPROV_IOWAITIMPPROV_IOWAIT 當 SQL Server 等候 bulkload i/o 完成時發生。Occurs when SQL Server waits for a bulkload I/O to finish.
INSTANCE_LOG_RATE_GOVERNORINSTANCE_LOG_RATE_GOVERNOR 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
INTERNAL_TESTINGINTERNAL_TESTING 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
IO_AUDIT_MUTEXIO_AUDIT_MUTEX 在同步處理追蹤事件緩衝區時發生。Occurs during synchronization of trace event buffers.
IO_COMPLETIONIO_COMPLETION 在等候 I/O 作業完成時發生。Occurs while waiting for I/O operations to complete. 這種等候類型通常代表非資料頁面 I/O。This wait type generally represents non-data page I/Os. 資料頁面 i/o 完成等候會顯示為 PAGEIOLATCH_* 等待。Data page I/O completion waits appear as PAGEIOLATCH_* waits.
IO_QUEUE_LIMITIO_QUEUE_LIMIT 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
IO_RETRYIO_RETRY 當讀取或寫入磁碟等 I/O 作業由於資源不足而失敗,然後重試時發生。Occurs when an I/O operation such as a read or a write to disk fails because of insufficient resources, and is then retried.
IOAFF_RANGE_QUEUEIOAFF_RANGE_QUEUE 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
KSOURCE_WAKEUPKSOURCE_WAKEUP 供服務控制工作在等候來自服務控制管理員的要求時使用。Used by the service control task while waiting for requests from the Service Control Manager. 等候時間長是正常情況,並不表示發生任何問題。Long waits are expected and do not indicate a problem.
KTM_ENLISTMENTKTM_ENLISTMENT 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
KTM_RECOVERY_MANAGERKTM_RECOVERY_MANAGER 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
KTM_RECOVERY_RESOLUTIONKTM_RECOVERY_RESOLUTION 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
LATCH_DTLATCH_DT 在等候 DT (終結) 閂鎖時發生。Occurs when waiting for a DT (destroy) latch. 其中不包括緩衝區閂鎖或交易標示閂鎖。This does not include buffer latches or transaction mark latches. * 等候的閂鎖_清單可在 sys.databases 中取得。 dm_os_latch_stats。A listing of LATCH_* waits is available in sys.dm_os_latch_stats. 請注意,sys.dm_os_latch_stats 會將 LATCH_NL、LATCH_SH、LATCH_UP、LATCH_EX 和 LATCH_DT 等候分組在一起。Note that sys.dm_os_latch_stats groups LATCH_NL, LATCH_SH, LATCH_UP, LATCH_EX, and LATCH_DT waits together.
LATCH_EXLATCH_EX 在等候 EX (獨佔) 閂鎖時發生。Occurs when waiting for an EX (exclusive) latch. 其中不包括緩衝區閂鎖或交易標示閂鎖。This does not include buffer latches or transaction mark latches. * 等候的閂鎖_清單可在 sys.databases 中取得。 dm_os_latch_stats。A listing of LATCH_* waits is available in sys.dm_os_latch_stats. 請注意,sys.dm_os_latch_stats 會將 LATCH_NL、LATCH_SH、LATCH_UP、LATCH_EX 和 LATCH_DT 等候分組在一起。Note that sys.dm_os_latch_stats groups LATCH_NL, LATCH_SH, LATCH_UP, LATCH_EX, and LATCH_DT waits together.
LATCH_KPLATCH_KP 在等候 KP (保留) 閂鎖時發生。Occurs when waiting for a KP (keep) latch. 其中不包括緩衝區閂鎖或交易標示閂鎖。This does not include buffer latches or transaction mark latches. * 等候的閂鎖_清單可在 sys.databases 中取得。 dm_os_latch_stats。A listing of LATCH_* waits is available in sys.dm_os_latch_stats. 請注意,sys.dm_os_latch_stats 會將 LATCH_NL、LATCH_SH、LATCH_UP、LATCH_EX 和 LATCH_DT 等候分組在一起。Note that sys.dm_os_latch_stats groups LATCH_NL, LATCH_SH, LATCH_UP, LATCH_EX, and LATCH_DT waits together.
LATCH_NLLATCH_NL 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
LATCH_SHLATCH_SH 在等候 SH (共用) 閂鎖時發生。Occurs when waiting for an SH (share) latch. 其中不包括緩衝區閂鎖或交易標示閂鎖。This does not include buffer latches or transaction mark latches. * 等候的閂鎖_清單可在 sys.databases 中取得。 dm_os_latch_stats。A listing of LATCH_* waits is available in sys.dm_os_latch_stats. 請注意,sys.dm_os_latch_stats 會將 LATCH_NL、LATCH_SH、LATCH_UP、LATCH_EX 和 LATCH_DT 等候分組在一起。Note that sys.dm_os_latch_stats groups LATCH_NL, LATCH_SH, LATCH_UP, LATCH_EX, and LATCH_DT waits together.
LATCH_UPLATCH_UP 在等候 UP (更新) 閂鎖時發生。Occurs when waiting for an UP (update) latch. 其中不包括緩衝區閂鎖或交易標示閂鎖。This does not include buffer latches or transaction mark latches. * 等候的閂鎖_清單可在 sys.databases 中取得。 dm_os_latch_stats。A listing of LATCH_* waits is available in sys.dm_os_latch_stats. 請注意,sys.dm_os_latch_stats 會將 LATCH_NL、LATCH_SH、LATCH_UP、LATCH_EX 和 LATCH_DT 等候分組在一起。Note that sys.dm_os_latch_stats groups LATCH_NL, LATCH_SH, LATCH_UP, LATCH_EX, and LATCH_DT waits together.
LAZYWRITER_SLEEPLAZYWRITER_SLEEP 當延遲寫入器工作暫止時發生。Occurs when lazy writer tasks are suspended. 這是等候中的背景工作所花的時間。This is a measure of the time spent by background tasks that are waiting. 如果您要尋找使用者拋錨點,就不要考慮這個狀態。Do not consider this state when you are looking for user stalls.
LCK_M_BULCK_M_BU 當工作在等候取得大量更新 (BU) 鎖定時發生。Occurs when a task is waiting to acquire a Bulk Update (BU) lock.
LCK_M_BU_ABORT_BLOCKERSLCK_M_BU_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的大量更新 (BU) 鎖定時發生Occurs when a task is waiting to acquire a Bulk Update (BU) lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_BU_LOW_PRIORITYLCK_M_BU_LOW_PRIORITY 當工作在等候取得低優先順序的大量更新 (BU) 鎖定時發生Occurs when a task is waiting to acquire a Bulk Update (BU) lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_ISLCK_M_IS 當工作在等候取得意圖共用 (IS) 鎖定時發生。Occurs when a task is waiting to acquire an Intent Shared (IS) lock.
LCK_M_IS_ABORT_BLOCKERSLCK_M_IS_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的意圖共用 (IS) 鎖定時發生Occurs when a task is waiting to acquire an Intent Shared (IS) lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_IS_LOW_PRIORITYLCK_M_IS_LOW_PRIORITY 當工作在等候取得低優先順序的意圖共用 (IS) 鎖定時發生Occurs when a task is waiting to acquire an Intent Shared (IS) lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_IULCK_M_IU 當工作在等候取得意圖更新 (IU) 鎖定時發生。Occurs when a task is waiting to acquire an Intent Update (IU) lock.
LCK_M_IU_ABORT_BLOCKERSLCK_M_IU_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的意圖更新 (IU) 鎖定時發生Occurs when a task is waiting to acquire an Intent Update (IU) lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_IU_LOW_PRIORITYLCK_M_IU_LOW_PRIORITY 當工作在等候取得低優先順序的意圖更新 (IU) 鎖定時發生Occurs when a task is waiting to acquire an Intent Update (IU) lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_IXLCK_M_IX 當工作在等候取得意圖獨佔 (IX) 鎖定時發生。Occurs when a task is waiting to acquire an Intent Exclusive (IX) lock.
LCK_M_IX_ABORT_BLOCKERSLCK_M_IX_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的意圖獨佔 (IX) 鎖定時發生Occurs when a task is waiting to acquire an Intent Exclusive (IX) lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_IX_LOW_PRIORITYLCK_M_IX_LOW_PRIORITY 當工作在等候取得低優先順序的意圖獨佔 (IX) 鎖定時發生Occurs when a task is waiting to acquire an Intent Exclusive (IX) lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RIn_NLLCK_M_RIn_NL 當工作在等候取得目前索引鍵值的 NULL 鎖定,以及目前索引鍵和前一個索引鍵之間的插入範圍鎖定時發生。Occurs when a task is waiting to acquire a NULL lock on the current key value, and an Insert Range lock between the current and previous key. 索引鍵的 NULL 鎖定是一個立即釋放鎖定。A NULL lock on the key is an instant release lock.
LCK_M_RIn_NL_ABORT_BLOCKERSLCK_M_RIn_NL_ABORT_BLOCKERS 當工作在等候取得目前索引鍵值的具有中止封鎖器的 NULL 鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的插入範圍鎖定時發生。Occurs when a task is waiting to acquire a NULL lock with Abort Blockers on the current key value, and an Insert Range lock with Abort Blockers between the current and previous key. 索引鍵的 NULL 鎖定是一個立即釋放鎖定。A NULL lock on the key is an instant release lock. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RIn_NL_LOW_PRIORITYLCK_M_RIn_NL_LOW_PRIORITY 當工作在等候取得目前索引鍵值的低優先順序的 NULL 鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的插入範圍鎖定時發生。Occurs when a task is waiting to acquire a NULL lock with Low Priority on the current key value, and an Insert Range lock with Low Priority between the current and previous key. 索引鍵的 NULL 鎖定是一個立即釋放鎖定。A NULL lock on the key is an instant release lock. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RIn_SLCK_M_RIn_S 當工作在等候取得目前索引鍵值的共用鎖定,以及目前索引鍵和前一個索引鍵之間的插入範圍鎖定時發生。Occurs when a task is waiting to acquire a shared lock on the current key value, and an Insert Range lock between the current and previous key.
LCK_M_RIn_S_ABORT_BLOCKERSLCK_M_RIn_S_ABORT_BLOCKERS 當工作在等候取得目前索引鍵值的具有中止封鎖器的共用鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的插入範圍鎖定時發生Occurs when a task is waiting to acquire a shared lock with Abort Blockers on the current key value, and an Insert Range lock with Abort Blockers between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RIn_S_LOW_PRIORITYLCK_M_RIn_S_LOW_PRIORITY 當工作在等候取得目前索引鍵值的低優先順序的共用鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的插入範圍鎖定時發生Occurs when a task is waiting to acquire a shared lock with Low Priority on the current key value, and an Insert Range lock with Low Priority between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RIn_ULCK_M_RIn_U 工作在等候取得目前索引鍵值的更新鎖定,以及目前索引鍵和前一個索引鍵之間的插入範圍鎖定。Task is waiting to acquire an Update lock on the current key value, and an Insert Range lock between the current and previous key.
LCK_M_RIn_U_ABORT_BLOCKERSLCK_M_RIn_U_ABORT_BLOCKERS 工作在等候取得目前索引鍵值的具有中止封鎖器的更新鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的插入範圍鎖定Task is waiting to acquire an Update lock with Abort Blockers on the current key value, and an Insert Range lock with Abort Blockers between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RIn_U_LOW_PRIORITYLCK_M_RIn_U_LOW_PRIORITY 工作在等候取得目前索引鍵值的低優先順序的更新鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的插入範圍鎖定Task is waiting to acquire an Update lock with Low Priority on the current key value, and an Insert Range lock with Low Priority between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RIn_XLCK_M_RIn_X 當工作在等候取得目前索引鍵值的獨佔鎖定,以及目前索引鍵和前一個索引鍵之間的插入範圍鎖定時發生。Occurs when a task is waiting to acquire an Exclusive lock on the current key value, and an Insert Range lock between the current and previous key.
LCK_M_RIn_X_ABORT_BLOCKERSLCK_M_RIn_X_ABORT_BLOCKERS 當工作在等候取得目前索引鍵值的具有中止封鎖器的獨佔鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的插入範圍鎖定時發生Occurs when a task is waiting to acquire an Exclusive lock with Abort Blockers on the current key value, and an Insert Range lock with Abort Blockers between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RIn_X_LOW_PRIORITYLCK_M_RIn_X_LOW_PRIORITY 當工作在等候取得目前索引鍵值的低優先順序的獨佔鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的插入範圍鎖定時發生Occurs when a task is waiting to acquire an Exclusive lock with Low Priority on the current key value, and an Insert Range lock with Low Priority between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RS_SLCK_M_RS_S 當工作在等候取得目前索引鍵值的共用鎖定,以及目前索引鍵和前一個索引鍵之間的共用範圍鎖定時發生。Occurs when a task is waiting to acquire a Shared lock on the current key value, and a Shared Range lock between the current and previous key.
LCK_M_RS_S_ABORT_BLOCKERSLCK_M_RS_S_ABORT_BLOCKERS 當工作在等候取得目前索引鍵值的具有中止封鎖器的共用鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的共用範圍鎖定時發生Occurs when a task is waiting to acquire a Shared lock with Abort Blockers on the current key value, and a Shared Range lock with Abort Blockers between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RS_S_LOW_PRIORITYLCK_M_RS_S_LOW_PRIORITY 當工作在等候取得目前索引鍵值的低優先順序的共用鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的共用範圍鎖定時發生Occurs when a task is waiting to acquire a Shared lock with Low Priority on the current key value, and a Shared Range lock with Low Priority between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RS_ULCK_M_RS_U 當工作在等候取得目前索引鍵值的更新鎖定,以及目前索引鍵和前一個索引鍵之間的更新範圍鎖定時發生。Occurs when a task is waiting to acquire an Update lock on the current key value, and an Update Range lock between the current and previous key.
LCK_M_RS_U_ABORT_BLOCKERSLCK_M_RS_U_ABORT_BLOCKERS 當工作在等候取得目前索引鍵值的具有中止封鎖器的更新鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的更新範圍鎖定時發生Occurs when a task is waiting to acquire an Update lock with Abort Blockers on the current key value, and an Update Range lock with Abort Blockers between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RS_U_LOW_PRIORITYLCK_M_RS_U_LOW_PRIORITY 當工作在等候取得目前索引鍵值的低優先順序的更新鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的更新範圍鎖定時發生Occurs when a task is waiting to acquire an Update lock with Low Priority on the current key value, and an Update Range lock with Low Priority between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RX_SLCK_M_RX_S 當工作在等候取得目前索引鍵值的共用鎖定,以及目前索引鍵和前一個索引鍵之間的獨佔範圍鎖定時發生。Occurs when a task is waiting to acquire a Shared lock on the current key value, and an Exclusive Range lock between the current and previous key.
LCK_M_RX_S_ABORT_BLOCKERSLCK_M_RX_S_ABORT_BLOCKERS 當工作在等候取得目前索引鍵值的具有中止封鎖器的共用鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的獨佔範圍鎖定時發生Occurs when a task is waiting to acquire a Shared lock with Abort Blockers on the current key value, and an Exclusive Range with Abort Blockers lock between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RX_S_LOW_PRIORITYLCK_M_RX_S_LOW_PRIORITY 當工作在等候取得目前索引鍵值的低優先順序的共用鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的獨佔範圍鎖定時發生Occurs when a task is waiting to acquire a Shared lock with Low Priority on the current key value, and an Exclusive Range with Low Priority lock between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RX_ULCK_M_RX_U 當工作在等候取得目前索引鍵值的更新鎖定,以及目前索引鍵和前一個索引鍵之間的獨佔範圍鎖定時發生。Occurs when a task is waiting to acquire an Update lock on the current key value, and an Exclusive range lock between the current and previous key.
LCK_M_RX_U_ABORT_BLOCKERSLCK_M_RX_U_ABORT_BLOCKERS 當工作在等候取得目前索引鍵值的具有中止封鎖器的更新鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的獨佔範圍鎖定時發生Occurs when a task is waiting to acquire an Update lock with Abort Blockers on the current key value, and an Exclusive range lock with Abort Blockers between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RX_U_LOW_PRIORITYLCK_M_RX_U_LOW_PRIORITY 當工作在等候取得目前索引鍵值的低優先順序的更新鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的獨佔範圍鎖定時發生Occurs when a task is waiting to acquire an Update lock with Low Priority on the current key value, and an Exclusive range lock with Low Priority between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RX_XLCK_M_RX_X 當工作在等候取得目前索引鍵值的獨佔鎖定,以及目前索引鍵和前一個索引鍵之間的獨佔範圍鎖定時發生。Occurs when a task is waiting to acquire an Exclusive lock on the current key value, and an Exclusive Range lock between the current and previous key.
LCK_M_RX_X_ABORT_BLOCKERSLCK_M_RX_X_ABORT_BLOCKERS 當工作在等候取得目前索引鍵值的具有中止封鎖器的獨佔鎖定,以及目前索引鍵和前一個索引鍵之間具有中止封鎖器的獨佔範圍鎖定時發生Occurs when a task is waiting to acquire an Exclusive lock with Abort Blockers on the current key value, and an Exclusive Range lock with Abort Blockers between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_RX_X_LOW_PRIORITYLCK_M_RX_X_LOW_PRIORITY 當工作在等候取得目前索引鍵值的低優先順序的獨佔鎖定,以及目前索引鍵和前一個索引鍵之間低優先順序的獨佔範圍鎖定時發生Occurs when a task is waiting to acquire an Exclusive lock with Low Priority on the current key value, and an Exclusive Range lock with Low Priority between the current and previous key. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SLCK_M_S 當工作在等候取得共用鎖定時發生。Occurs when a task is waiting to acquire a Shared lock.
LCK_M_S_ABORT_BLOCKERSLCK_M_S_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的共用鎖定時發生Occurs when a task is waiting to acquire a Shared lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_S_LOW_PRIORITYLCK_M_S_LOW_PRIORITY 當工作在等候取得低優先順序的共用鎖定時發生Occurs when a task is waiting to acquire a Shared lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SCH_MLCK_M_SCH_M 當工作在等候取得結構描述修改鎖定時發生。Occurs when a task is waiting to acquire a Schema Modify lock.
LCK_M_SCH_M_ABORT_BLOCKERSLCK_M_SCH_M_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的結構描述修改鎖定時發生Occurs when a task is waiting to acquire a Schema Modify lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SCH_M_LOW_PRIORITYLCK_M_SCH_M_LOW_PRIORITY 當工作在等候取得低優先順序的結構描述修改鎖定時發生Occurs when a task is waiting to acquire a Schema Modify lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SCH_SLCK_M_SCH_S 當工作在等候取得結構描述共用鎖定時發生。Occurs when a task is waiting to acquire a Schema Share lock.
LCK_M_SCH_S_ABORT_BLOCKERSLCK_M_SCH_S_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的結構描述共用鎖定時發生Occurs when a task is waiting to acquire a Schema Share lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SCH_S_LOW_PRIORITYLCK_M_SCH_S_LOW_PRIORITY 當工作在等候取得低優先順序的結構描述共用鎖定時發生Occurs when a task is waiting to acquire a Schema Share lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SIULCK_M_SIU 當工作在等候取得共用意圖更新鎖定時發生。Occurs when a task is waiting to acquire a Shared With Intent Update lock.
LCK_M_SIU_ABORT_BLOCKERSLCK_M_SIU_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的共用意圖更新鎖定時發生Occurs when a task is waiting to acquire a Shared With Intent Update lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SIU_LOW_PRIORITYLCK_M_SIU_LOW_PRIORITY 當工作在等候取得低優先順序的共用意圖更新鎖定時發生Occurs when a task is waiting to acquire a Shared With Intent Update lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SIXLCK_M_SIX 當工作在等候取得共用意圖獨佔鎖定時發生。Occurs when a task is waiting to acquire a Shared With Intent Exclusive lock.
LCK_M_SIX_ABORT_BLOCKERSLCK_M_SIX_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的共用意圖獨佔鎖定時發生Occurs when a task is waiting to acquire a Shared With Intent Exclusive lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_SIX_LOW_PRIORITYLCK_M_SIX_LOW_PRIORITY 當工作在等候取得低優先順序的共用意圖獨佔鎖定時發生Occurs when a task is waiting to acquire a Shared With Intent Exclusive lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_ULCK_M_U 當工作在等候取得更新鎖定時發生。Occurs when a task is waiting to acquire an Update lock.
LCK_M_U_ABORT_BLOCKERSLCK_M_U_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的更新鎖定時發生Occurs when a task is waiting to acquire an Update lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_U_LOW_PRIORITYLCK_M_U_LOW_PRIORITY 當工作在等候取得低優先順序的更新鎖定時發生Occurs when a task is waiting to acquire an Update lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_UIXLCK_M_UIX 當工作在等候取得更新意圖獨佔鎖定時發生。Occurs when a task is waiting to acquire an Update With Intent Exclusive lock.
LCK_M_UIX_ABORT_BLOCKERSLCK_M_UIX_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的更新意圖獨佔鎖定時發生Occurs when a task is waiting to acquire an Update With Intent Exclusive lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_UIX_LOW_PRIORITYLCK_M_UIX_LOW_PRIORITY 當工作在等候取得低優先順序的更新意圖獨佔鎖定時發生Occurs when a task is waiting to acquire an Update With Intent Exclusive lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_XLCK_M_X 當工作在等候取得獨佔鎖定時發生。Occurs when a task is waiting to acquire an Exclusive lock.
LCK_M_X_ABORT_BLOCKERSLCK_M_X_ABORT_BLOCKERS 當工作在等候取得具有中止封鎖器的獨佔鎖定時發生Occurs when a task is waiting to acquire an Exclusive lock with Abort Blockers. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LCK_M_X_LOW_PRIORITYLCK_M_X_LOW_PRIORITY 當工作在等候取得低優先順序的獨佔鎖定時發生Occurs when a task is waiting to acquire an Exclusive lock with Low Priority. (與 ALTER TABLE 和 ALTER INDEX 的低優先順序等候選項有關)。(Related to the low priority wait option of ALTER TABLE and ALTER INDEX.),
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
LOG_POOL_SCANLOG_POOL_SCAN 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
LOG_RATE_GOVERNORLOG_RATE_GOVERNOR 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
LOGBUFFERLOGBUFFER 當工作在等候記錄緩衝區的空間來儲存記錄時發生。Occurs when a task is waiting for space in the log buffer to store a log record. 如果這個值一直居高不下,可能表示記錄裝置趕不上伺服器產生的記錄量。Consistently high values may indicate that the log devices cannot keep up with the amount of log being generated by the server.
LOGCAPTURE_LOGPOOLTRUNCPOINTLOGCAPTURE_LOGPOOLTRUNCPOINT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
LOGGENERATIONLOGGENERATION 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
LOGMGRLOGMGR 當工作在關閉資料庫時,於關閉記錄之前等候任何未完成的記錄 I/O 完成時發生。Occurs when a task is waiting for any outstanding log I/Os to finish before shutting down the log while closing the database.
LOGMGR_FLUSHLOGMGR_FLUSH 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
LOGMGR_PMM_LOGLOGMGR_PMM_LOG 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
LOGMGR_QUEUELOGMGR_QUEUE 在記錄寫入器工作等候工作要求時發生。Occurs while the log writer task waits for work requests.
LOGMGR_RESERVE_APPENDLOGMGR_RESERVE_APPEND 當工作在等候記錄截斷清出記錄空間,讓工作寫入新記錄時發生。Occurs when a task is waiting to see whether log truncation frees up log space to enable the task to write a new log record. 請考慮增加受影響之資料庫的記錄檔案大小,以縮短這個等候時間。Consider increasing the size of the log file(s) for the affected database to reduce this wait.
LOGPOOL_CACHESIZELOGPOOL_CACHESIZE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
LOGPOOL_CONSUMERLOGPOOL_CONSUMER 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
LOGPOOL_CONSUMERSETLOGPOOL_CONSUMERSET 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
LOGPOOL_FREEPOOLSLOGPOOL_FREEPOOLS 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
LOGPOOL_MGRSETLOGPOOL_MGRSET 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
LOGPOOL_REPLACEMENTSETLOGPOOL_REPLACEMENTSET 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
LOGPOOLREFCOUNTEDOBJECT_REFDONELOGPOOLREFCOUNTEDOBJECT_REFDONE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
LOWFAIL_MEMMGR_QUEUELOWFAIL_MEMMGR_QUEUE 在等候記憶體變成可供使用的狀態時發生。Occurs while waiting for memory to be available for use.
MD_AGENT_YIELDMD_AGENT_YIELD 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
MD_LAZYCACHE_RWLOCKMD_LAZYCACHE_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
MEMORY_ALLOCATION_EXTMEMORY_ALLOCATION_EXT 從內部 SQL Server 記憶體集區或作業系統配置記憶體時發生。Occurs while allocating memory from either the internal SQL Server memory pool or the operation system.,
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
MEMORY_GRANT_UPDATEMEMORY_GRANT_UPDATE 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
METADATA_LAZYCACHE_RWLOCKMETADATA_LAZYCACHE_RWLOCK 僅供內部使用。Internal use only.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
MIGRATIONBUFFERMIGRATIONBUFFER 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
MISCELLANEOUSMISCELLANEOUS 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
MISCELLANEOUSMISCELLANEOUS 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
MSQL_DQMSQL_DQ 在工作等候分散式查詢作業完成時發生。Occurs when a task is waiting for a distributed query operation to finish. 這種等候類型可用來偵測潛在的 Multiple Active Result Set (MARS) 應用程式死結。This is used to detect potential Multiple Active Result Set (MARS) application deadlocks. 等候會隨著分散式查詢呼叫的完成而結束。The wait ends when the distributed query call finishes.
MSQL_XACT_MGR_MUTEXMSQL_XACT_MGR_MUTEX 當工作在等候取得工作階段交易管理員的擁有權,以執行工作階段層級交易作業時發生。Occurs when a task is waiting to obtain ownership of the session transaction manager to perform a session level transaction operation.
MSQL_XACT_MUTEXMSQL_XACT_MUTEX 在同步處理交易使用量時發生。Occurs during synchronization of transaction usage. 要求必須先取得 Mutex,才能使用交易。A request must acquire the mutex before it can use the transaction.
MSQL_XPMSQL_XP 當工作在等候擴充預存程序結束時發生。Occurs when a task is waiting for an extended stored procedure to end. SQL Server 使用此等候狀態來偵測潛在的 MARS 應用程式鎖死。SQL Server uses this wait state to detect potential MARS application deadlocks. 這個等候會隨著擴充預存程序呼叫的結束而停止。The wait stops when the extended stored procedure call ends.
MSSEARCHMSSEARCH 在使用全文檢索搜尋呼叫時發生。Occurs during Full-Text Search calls. 這個等候會隨著全文檢索作業的完成而結束。This wait ends when the full-text operation completes. 這並不表示發生競爭情況,而是指出全文檢索作業的持續時間。It does not indicate contention, but rather the duration of full-text operations.
NET_WAITFOR_PACKETNET_WAITFOR_PACKET 當連接在網路讀取期間等候網路封包時發生。Occurs when a connection is waiting for a network packet during a network read.
NETWORKSXMLMGRLOADNETWORKSXMLMGRLOAD 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
NODE_CACHE_MUTEXNODE_CACHE_MUTEX 僅供內部使用。Internal use only.
OLEDBOLEDB 當 SQL Server 呼叫 SQL Server Native Client OLE DB 提供者時發生。Occurs when SQL Server calls the SQL Server Native Client OLE DB Provider. 這個等候類型不用於同步處理,This wait type is not used for synchronization. 而會指出呼叫 OLE DB 提供者的持續時間。Instead, it indicates the duration of calls to the OLE DB provider.
ONDEMAND_TASK_QUEUEONDEMAND_TASK_QUEUE 在背景工作等候高優先權的系統工作要求時發生。Occurs while a background task waits for high priority system task requests. 如果等候時間很長,表示沒有高優先權的要求需要處理,而且應該不會造成任何問題。Long wait times indicate that there have been no high priority requests to process, and should not cause concern.
PAGEIOLATCH_DTPAGEIOLATCH_DT 當工作在位於 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is in an I/O request. 閂鎖要求是終結模式。The latch request is in Destroy mode. 如果等候時間很長,表示磁碟子系統有問題。Long waits may indicate problems with the disk subsystem.
PAGEIOLATCH_EXPAGEIOLATCH_EX 當工作在位於 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is in an I/O request. 閂鎖要求是獨佔模式。The latch request is in Exclusive mode. 如果等候時間很長,表示磁碟子系統有問題。Long waits may indicate problems with the disk subsystem.
PAGEIOLATCH_KPPAGEIOLATCH_KP 當工作在位於 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is in an I/O request. 閂鎖要求是保留模式。The latch request is in Keep mode. 如果等候時間很長,表示磁碟子系統有問題。Long waits may indicate problems with the disk subsystem.
PAGEIOLATCH_NLPAGEIOLATCH_NL 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
PAGEIOLATCH_SHPAGEIOLATCH_SH 當工作在位於 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is in an I/O request. 閂鎖要求是共用模式。The latch request is in Shared mode. 如果等候時間很長,表示磁碟子系統有問題。Long waits may indicate problems with the disk subsystem.
PAGEIOLATCH_UPPAGEIOLATCH_UP 當工作在位於 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is in an I/O request. 閂鎖要求是更新模式。The latch request is in Update mode. 如果等候時間很長,表示磁碟子系統有問題。Long waits may indicate problems with the disk subsystem.
PAGELATCH_DTPAGELATCH_DT 當工作不是在 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is not in an I/O request. 閂鎖要求是終結模式。The latch request is in Destroy mode.
PAGELATCH_EXPAGELATCH_EX 當工作不是在 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is not in an I/O request. 閂鎖要求是獨佔模式。The latch request is in Exclusive mode.
PAGELATCH_KPPAGELATCH_KP 當工作不是在 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is not in an I/O request. 閂鎖要求是保留模式。The latch request is in Keep mode.
PAGELATCH_NLPAGELATCH_NL 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
PAGELATCH_SHPAGELATCH_SH 當工作不是在 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is not in an I/O request. 閂鎖要求是共用模式。The latch request is in Shared mode.
PAGELATCH_UPPAGELATCH_UP 當工作不是在 I/O 要求中的緩衝區閂鎖待命時發生。Occurs when a task is waiting on a latch for a buffer that is not in an I/O request. 閂鎖要求是更新模式。The latch request is in Update mode.
PARALLEL_BACKUP_QUEUEPARALLEL_BACKUP_QUEUE 在序列化 RESTORE HEADERONLY、RESTORE FILELISTONLY 或 RESTORE LABELONLY 所產生的輸出時發生。Occurs when serializing output produced by RESTORE HEADERONLY, RESTORE FILELISTONLY, or RESTORE LABELONLY.
PARALLEL_REDO_DRAIN_WORKERPARALLEL_REDO_DRAIN_WORKER 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PARALLEL_REDO_FLOW_CONTROLPARALLEL_REDO_FLOW_CONTROL 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PARALLEL_REDO_LOG_CACHEPARALLEL_REDO_LOG_CACHE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PARALLEL_REDO_TRAN_LISTPARALLEL_REDO_TRAN_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PARALLEL_REDO_TRAN_TURNPARALLEL_REDO_TRAN_TURN 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PARALLEL_REDO_WORKER_SYNCPARALLEL_REDO_WORKER_SYNC 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PARALLEL_REDO_WORKER_WAIT_WORKPARALLEL_REDO_WORKER_WAIT_WORK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PERFORMANCE_COUNTERS_RWLOCKPERFORMANCE_COUNTERS_RWLOCK 僅供內部使用。Internal use only.
PHYSICAL_SEEDING_DMVPHYSICAL_SEEDING_DMV 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
POOL_LOG_RATE_GOVERNORPOOL_LOG_RATE_GOVERNOR 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PREEMPTIVE_ABRPREEMPTIVE_ABR 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
PREEMPTIVE_AUDIT_ACCESS_EVENTLOGPREEMPTIVE_AUDIT_ACCESS_EVENTLOG SQL ServerSQL Server 作業系統 (SQLOS) 排程器切換到先佔式模式,以便將稽核事件寫入 Windows 事件記錄檔時發生。Occurs when the SQL ServerSQL Server Operating System (SQLOS) scheduler switches to preemptive mode to write an audit event to the Windows event log.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
PREEMPTIVE_AUDIT_ACCESS_SECLOGPREEMPTIVE_AUDIT_ACCESS_SECLOG 當 SQLOS 排程器切換到先佔式模式,以便將稽核事件寫入 Windows 安全性記錄檔時發生。Occurs when the SQLOS scheduler switches to preemptive mode to write an audit event to the Windows Security log.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
PREEMPTIVE_CLOSEBACKUPMEDIAPREEMPTIVE_CLOSEBACKUPMEDIA 當 SQLOS 排程器切換到先佔式模式,以便關閉備份媒體時發生。Occurs when the SQLOS scheduler switches to preemptive mode to close backup media.
PREEMPTIVE_CLOSEBACKUPTAPEPREEMPTIVE_CLOSEBACKUPTAPE 當 SQLOS 排程器切換到先佔式模式,以便關閉磁帶備份裝置時發生。Occurs when the SQLOS scheduler switches to preemptive mode to close a tape backup device.
PREEMPTIVE_CLOSEBACKUPVDIDEVICEPREEMPTIVE_CLOSEBACKUPVDIDEVICE 當 SQLOS 排程器切換到先佔式模式,以便關閉虛擬備份裝置時發生。Occurs when the SQLOS scheduler switches to preemptive mode to close a virtual backup device.
PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROLPREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL 當 SQLOS 排程器切換到先佔式模式,以便執行 Windows 容錯移轉叢集作業時發生。Occurs when the SQLOS scheduler switches to preemptive mode to perform Windows failover cluster operations.
PREEMPTIVE_COM_COCREATEINSTANCEPREEMPTIVE_COM_COCREATEINSTANCE 當 SQLOS 排程器切換到先佔式模式,以便建立 COM 物件時發生。Occurs when the SQLOS scheduler switches to preemptive mode to create a COM object.
PREEMPTIVE_COM_COGETCLASSOBJECTPREEMPTIVE_COM_COGETCLASSOBJECT 僅供內部使用。Internal use only.
PREEMPTIVE_COM_CREATEACCESSORPREEMPTIVE_COM_CREATEACCESSOR 僅供內部使用。Internal use only.
PREEMPTIVE_COM_DELETEROWSPREEMPTIVE_COM_DELETEROWS 僅供內部使用。Internal use only.
PREEMPTIVE_COM_GETCOMMANDTEXTPREEMPTIVE_COM_GETCOMMANDTEXT 僅供內部使用。Internal use only.
PREEMPTIVE_COM_GETDATAPREEMPTIVE_COM_GETDATA 僅供內部使用。Internal use only.
PREEMPTIVE_COM_GETNEXTROWSPREEMPTIVE_COM_GETNEXTROWS 僅供內部使用。Internal use only.
PREEMPTIVE_COM_GETRESULTPREEMPTIVE_COM_GETRESULT 僅供內部使用。Internal use only.
PREEMPTIVE_COM_GETROWSBYBOOKMARKPREEMPTIVE_COM_GETROWSBYBOOKMARK 僅供內部使用。Internal use only.
PREEMPTIVE_COM_LBFLUSHPREEMPTIVE_COM_LBFLUSH 僅供內部使用。Internal use only.
PREEMPTIVE_COM_LBLOCKREGIONPREEMPTIVE_COM_LBLOCKREGION 僅供內部使用。Internal use only.
PREEMPTIVE_COM_LBREADATPREEMPTIVE_COM_LBREADAT 僅供內部使用。Internal use only.
PREEMPTIVE_COM_LBSETSIZEPREEMPTIVE_COM_LBSETSIZE 僅供內部使用。Internal use only.
PREEMPTIVE_COM_LBSTATPREEMPTIVE_COM_LBSTAT 僅供內部使用。Internal use only.
PREEMPTIVE_COM_LBUNLOCKREGIONPREEMPTIVE_COM_LBUNLOCKREGION 僅供內部使用。Internal use only.
PREEMPTIVE_COM_LBWRITEATPREEMPTIVE_COM_LBWRITEAT 僅供內部使用。Internal use only.
PREEMPTIVE_COM_QUERYINTERFACEPREEMPTIVE_COM_QUERYINTERFACE 僅供內部使用。Internal use only.
PREEMPTIVE_COM_RELEASEPREEMPTIVE_COM_RELEASE 僅供內部使用。Internal use only.
PREEMPTIVE_COM_RELEASEACCESSORPREEMPTIVE_COM_RELEASEACCESSOR 僅供內部使用。Internal use only.
PREEMPTIVE_COM_RELEASEROWSPREEMPTIVE_COM_RELEASEROWS 僅供內部使用。Internal use only.
PREEMPTIVE_COM_RELEASESESSIONPREEMPTIVE_COM_RELEASESESSION 僅供內部使用。Internal use only.
PREEMPTIVE_COM_RESTARTPOSITIONPREEMPTIVE_COM_RESTARTPOSITION 僅供內部使用。Internal use only.
PREEMPTIVE_COM_SEQSTRMREADPREEMPTIVE_COM_SEQSTRMREAD 僅供內部使用。Internal use only.
PREEMPTIVE_COM_SEQSTRMREADANDWRITEPREEMPTIVE_COM_SEQSTRMREADANDWRITE 僅供內部使用。Internal use only.
PREEMPTIVE_COM_SETDATAFAILUREPREEMPTIVE_COM_SETDATAFAILURE 僅供內部使用。Internal use only.
PREEMPTIVE_COM_SETPARAMETERINFOPREEMPTIVE_COM_SETPARAMETERINFO 僅供內部使用。Internal use only.
PREEMPTIVE_COM_SETPARAMETERPROPERTIESPREEMPTIVE_COM_SETPARAMETERPROPERTIES 僅供內部使用。Internal use only.
PREEMPTIVE_COM_STRMLOCKREGIONPREEMPTIVE_COM_STRMLOCKREGION 僅供內部使用。Internal use only.
PREEMPTIVE_COM_STRMSEEKANDREADPREEMPTIVE_COM_STRMSEEKANDREAD 僅供內部使用。Internal use only.
PREEMPTIVE_COM_STRMSEEKANDWRITEPREEMPTIVE_COM_STRMSEEKANDWRITE 僅供內部使用。Internal use only.
PREEMPTIVE_COM_STRMSETSIZEPREEMPTIVE_COM_STRMSETSIZE 僅供內部使用。Internal use only.
PREEMPTIVE_COM_STRMSTATPREEMPTIVE_COM_STRMSTAT 僅供內部使用。Internal use only.
PREEMPTIVE_COM_STRMUNLOCKREGIONPREEMPTIVE_COM_STRMUNLOCKREGION 僅供內部使用。Internal use only.
PREEMPTIVE_CONSOLEWRITEPREEMPTIVE_CONSOLEWRITE 僅供內部使用。Internal use only.
PREEMPTIVE_CREATEPARAMPREEMPTIVE_CREATEPARAM 僅供內部使用。Internal use only.
PREEMPTIVE_DEBUGPREEMPTIVE_DEBUG 僅供內部使用。Internal use only.
PREEMPTIVE_DFSADDLINKPREEMPTIVE_DFSADDLINK 僅供內部使用。Internal use only.
PREEMPTIVE_DFSLINKEXISTCHECKPREEMPTIVE_DFSLINKEXISTCHECK 僅供內部使用。Internal use only.
PREEMPTIVE_DFSLINKHEALTHCHECKPREEMPTIVE_DFSLINKHEALTHCHECK 僅供內部使用。Internal use only.
PREEMPTIVE_DFSREMOVELINKPREEMPTIVE_DFSREMOVELINK 僅供內部使用。Internal use only.
PREEMPTIVE_DFSREMOVEROOTPREEMPTIVE_DFSREMOVEROOT 僅供內部使用。Internal use only.
PREEMPTIVE_DFSROOTFOLDERCHECKPREEMPTIVE_DFSROOTFOLDERCHECK 僅供內部使用。Internal use only.
PREEMPTIVE_DFSROOTINITPREEMPTIVE_DFSROOTINIT 僅供內部使用。Internal use only.
PREEMPTIVE_DFSROOTSHARECHECKPREEMPTIVE_DFSROOTSHARECHECK 僅供內部使用。Internal use only.
PREEMPTIVE_DTC_ABORTPREEMPTIVE_DTC_ABORT 僅供內部使用。Internal use only.
PREEMPTIVE_DTC_ABORTREQUESTDONEPREEMPTIVE_DTC_ABORTREQUESTDONE 僅供內部使用。Internal use only.
PREEMPTIVE_DTC_BEGINTRANSACTIONPREEMPTIVE_DTC_BEGINTRANSACTION 僅供內部使用。Internal use only.
PREEMPTIVE_DTC_COMMITREQUESTDONEPREEMPTIVE_DTC_COMMITREQUESTDONE 僅供內部使用。Internal use only.
PREEMPTIVE_DTC_ENLISTPREEMPTIVE_DTC_ENLIST 僅供內部使用。Internal use only.
PREEMPTIVE_DTC_PREPAREREQUESTDONEPREEMPTIVE_DTC_PREPAREREQUESTDONE 僅供內部使用。Internal use only.
PREEMPTIVE_FILESIZEGETPREEMPTIVE_FILESIZEGET 僅供內部使用。Internal use only.
PREEMPTIVE_FSAOLEDB_ABORTTRANSACTIONPREEMPTIVE_FSAOLEDB_ABORTTRANSACTION 僅供內部使用。Internal use only.
PREEMPTIVE_FSAOLEDB_COMMITTRANSACTIONPREEMPTIVE_FSAOLEDB_COMMITTRANSACTION 僅供內部使用。Internal use only.
PREEMPTIVE_FSAOLEDB_STARTTRANSACTIONPREEMPTIVE_FSAOLEDB_STARTTRANSACTION 僅供內部使用。Internal use only.
PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDOPREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO 僅供內部使用。Internal use only.
PREEMPTIVE_GETRMINFOPREEMPTIVE_GETRMINFO 僅供內部使用。Internal use only.
PREEMPTIVE_HADR_LEASE_MECHANISMPREEMPTIVE_HADR_LEASE_MECHANISM Microsoft 支援服務診斷的 Always On 可用性群組租用管理員排程。Always On Availability Groups lease manager scheduling for Microsoft Support diagnostics.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PREEMPTIVE_HTTP_EVENT_WAITPREEMPTIVE_HTTP_EVENT_WAIT 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PREEMPTIVE_HTTP_REQUESTPREEMPTIVE_HTTP_REQUEST 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PREEMPTIVE_LOCKMONITORPREEMPTIVE_LOCKMONITOR 僅供內部使用。Internal use only.
PREEMPTIVE_MSS_RELEASEPREEMPTIVE_MSS_RELEASE 僅供內部使用。Internal use only.
PREEMPTIVE_ODBCOPSPREEMPTIVE_ODBCOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OLE_UNINITPREEMPTIVE_OLE_UNINIT 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_ABORTORCOMMITTRANPREEMPTIVE_OLEDB_ABORTORCOMMITTRAN 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_ABORTTRANPREEMPTIVE_OLEDB_ABORTTRAN 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_GETDATASOURCEPREEMPTIVE_OLEDB_GETDATASOURCE 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_GETLITERALINFOPREEMPTIVE_OLEDB_GETLITERALINFO 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_GETPROPERTIESPREEMPTIVE_OLEDB_GETPROPERTIES 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_GETPROPERTYINFOPREEMPTIVE_OLEDB_GETPROPERTYINFO 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_GETSCHEMALOCKPREEMPTIVE_OLEDB_GETSCHEMALOCK 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_JOINTRANSACTIONPREEMPTIVE_OLEDB_JOINTRANSACTION 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_RELEASEPREEMPTIVE_OLEDB_RELEASE 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDB_SETPROPERTIESPREEMPTIVE_OLEDB_SETPROPERTIES 僅供內部使用。Internal use only.
PREEMPTIVE_OLEDBOPSPREEMPTIVE_OLEDBOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_ACCEPTSECURITYCONTEXTPREEMPTIVE_OS_ACCEPTSECURITYCONTEXT 僅供內部使用。Internal use only.
PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLEPREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_AUTHENTICATIONOPSPREEMPTIVE_OS_AUTHENTICATIONOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_AUTHORIZATIONOPSPREEMPTIVE_OS_AUTHORIZATIONOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXTPREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT 僅供內部使用。Internal use only.
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSIDPREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID 僅供內部使用。Internal use only.
PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGERPREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER 僅供內部使用。Internal use only.
PREEMPTIVE_OS_BACKUPREADPREEMPTIVE_OS_BACKUPREAD 僅供內部使用。Internal use only.
PREEMPTIVE_OS_CLOSEHANDLEPREEMPTIVE_OS_CLOSEHANDLE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_CLUSTEROPSPREEMPTIVE_OS_CLUSTEROPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_COMOPSPREEMPTIVE_OS_COMOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_COMPLETEAUTHTOKENPREEMPTIVE_OS_COMPLETEAUTHTOKEN 僅供內部使用。Internal use only.
PREEMPTIVE_OS_COPYFILEPREEMPTIVE_OS_COPYFILE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_CREATEDIRECTORYPREEMPTIVE_OS_CREATEDIRECTORY 僅供內部使用。Internal use only.
PREEMPTIVE_OS_CREATEFILEPREEMPTIVE_OS_CREATEFILE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_CRYPTACQUIRECONTEXTPREEMPTIVE_OS_CRYPTACQUIRECONTEXT 僅供內部使用。Internal use only.
PREEMPTIVE_OS_CRYPTIMPORTKEYPREEMPTIVE_OS_CRYPTIMPORTKEY 僅供內部使用。Internal use only.
PREEMPTIVE_OS_CRYPTOPSPREEMPTIVE_OS_CRYPTOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DECRYPTMESSAGEPREEMPTIVE_OS_DECRYPTMESSAGE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DELETEFILEPREEMPTIVE_OS_DELETEFILE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DELETESECURITYCONTEXTPREEMPTIVE_OS_DELETESECURITYCONTEXT 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DEVICEIOCONTROLPREEMPTIVE_OS_DEVICEIOCONTROL 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DEVICEOPSPREEMPTIVE_OS_DEVICEOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DIRSVC_NETWORKOPSPREEMPTIVE_OS_DIRSVC_NETWORKOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DISCONNECTNAMEDPIPEPREEMPTIVE_OS_DISCONNECTNAMEDPIPE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DOMAINSERVICESOPSPREEMPTIVE_OS_DOMAINSERVICESOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DSGETDCNAMEPREEMPTIVE_OS_DSGETDCNAME 僅供內部使用。Internal use only.
PREEMPTIVE_OS_DTCOPSPREEMPTIVE_OS_DTCOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_ENCRYPTMESSAGEPREEMPTIVE_OS_ENCRYPTMESSAGE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_FILEOPSPREEMPTIVE_OS_FILEOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_FINDFILEPREEMPTIVE_OS_FINDFILE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_FLUSHFILEBUFFERSPREEMPTIVE_OS_FLUSHFILEBUFFERS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_FORMATMESSAGEPREEMPTIVE_OS_FORMATMESSAGE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_FREECREDENTIALSHANDLEPREEMPTIVE_OS_FREECREDENTIALSHANDLE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_FREELIBRARYPREEMPTIVE_OS_FREELIBRARY 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GENERICOPSPREEMPTIVE_OS_GENERICOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETADDRINFOPREEMPTIVE_OS_GETADDRINFO 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETCOMPRESSEDFILESIZEPREEMPTIVE_OS_GETCOMPRESSEDFILESIZE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETDISKFREESPACEPREEMPTIVE_OS_GETDISKFREESPACE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETFILEATTRIBUTESPREEMPTIVE_OS_GETFILEATTRIBUTES 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETFILESIZEPREEMPTIVE_OS_GETFILESIZE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETFINALFILEPATHBYHANDLEPREEMPTIVE_OS_GETFINALFILEPATHBYHANDLE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PREEMPTIVE_OS_GETLONGPATHNAMEPREEMPTIVE_OS_GETLONGPATHNAME 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETPROCADDRESSPREEMPTIVE_OS_GETPROCADDRESS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINTPREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT 僅供內部使用。Internal use only.
PREEMPTIVE_OS_GETVOLUMEPATHNAMEPREEMPTIVE_OS_GETVOLUMEPATHNAME 僅供內部使用。Internal use only.
PREEMPTIVE_OS_INITIALIZESECURITYCONTEXTPREEMPTIVE_OS_INITIALIZESECURITYCONTEXT 僅供內部使用。Internal use only.
PREEMPTIVE_OS_LIBRARYOPSPREEMPTIVE_OS_LIBRARYOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_LOADLIBRARYPREEMPTIVE_OS_LOADLIBRARY 僅供內部使用。Internal use only.
PREEMPTIVE_OS_LOGONUSERPREEMPTIVE_OS_LOGONUSER 僅供內部使用。Internal use only.
PREEMPTIVE_OS_LOOKUPACCOUNTSIDPREEMPTIVE_OS_LOOKUPACCOUNTSID 僅供內部使用。Internal use only.
PREEMPTIVE_OS_MESSAGEQUEUEOPSPREEMPTIVE_OS_MESSAGEQUEUEOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_MOVEFILEPREEMPTIVE_OS_MOVEFILE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_NETGROUPGETUSERSPREEMPTIVE_OS_NETGROUPGETUSERS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERSPREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_NETUSERGETGROUPSPREEMPTIVE_OS_NETUSERGETGROUPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_NETUSERGETLOCALGROUPSPREEMPTIVE_OS_NETUSERGETLOCALGROUPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_NETUSERMODALSGETPREEMPTIVE_OS_NETUSERMODALSGET 僅供內部使用。Internal use only.
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYPREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY 僅供內部使用。Internal use only.
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREEPREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_OPENDIRECTORYPREEMPTIVE_OS_OPENDIRECTORY 僅供內部使用。Internal use only.
PREEMPTIVE_OS_PDH_WMI_INITPREEMPTIVE_OS_PDH_WMI_INIT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PREEMPTIVE_OS_PIPEOPSPREEMPTIVE_OS_PIPEOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_PROCESSOPSPREEMPTIVE_OS_PROCESSOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTESPREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PREEMPTIVE_OS_QUERYREGISTRYPREEMPTIVE_OS_QUERYREGISTRY 僅供內部使用。Internal use only.
PREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKENPREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKEN 僅供內部使用。Internal use only.
PREEMPTIVE_OS_REMOVEDIRECTORYPREEMPTIVE_OS_REMOVEDIRECTORY 僅供內部使用。Internal use only.
PREEMPTIVE_OS_REPORTEVENTPREEMPTIVE_OS_REPORTEVENT 僅供內部使用。Internal use only.
PREEMPTIVE_OS_REVERTTOSELFPREEMPTIVE_OS_REVERTTOSELF 僅供內部使用。Internal use only.
PREEMPTIVE_OS_RSFXDEVICEOPSPREEMPTIVE_OS_RSFXDEVICEOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_SECURITYOPSPREEMPTIVE_OS_SECURITYOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_SERVICEOPSPREEMPTIVE_OS_SERVICEOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_SETENDOFFILEPREEMPTIVE_OS_SETENDOFFILE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_SETFILEPOINTERPREEMPTIVE_OS_SETFILEPOINTER 僅供內部使用。Internal use only.
PREEMPTIVE_OS_SETFILEVALIDDATAPREEMPTIVE_OS_SETFILEVALIDDATA 僅供內部使用。Internal use only.
PREEMPTIVE_OS_SETNAMEDSECURITYINFOPREEMPTIVE_OS_SETNAMEDSECURITYINFO 僅供內部使用。Internal use only.
PREEMPTIVE_OS_SQLCLROPSPREEMPTIVE_OS_SQLCLROPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_SQMLAUNCHPREEMPTIVE_OS_SQMLAUNCH 僅供內部使用。Internal use only.
適用於SQL Server 2008 R2SQL Server 2008 R2SQL Server 2016 (13.x)SQL Server 2016 (13.x)Applies to: SQL Server 2008 R2SQL Server 2008 R2 through SQL Server 2016 (13.x)SQL Server 2016 (13.x).
PREEMPTIVE_OS_VERIFYSIGNATUREPREEMPTIVE_OS_VERIFYSIGNATURE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_VERIFYTRUSTPREEMPTIVE_OS_VERIFYTRUST 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PREEMPTIVE_OS_VSSOPSPREEMPTIVE_OS_VSSOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_WAITFORSINGLEOBJECTPREEMPTIVE_OS_WAITFORSINGLEOBJECT 僅供內部使用。Internal use only.
PREEMPTIVE_OS_WINSOCKOPSPREEMPTIVE_OS_WINSOCKOPS 僅供內部使用。Internal use only.
PREEMPTIVE_OS_WRITEFILEPREEMPTIVE_OS_WRITEFILE 僅供內部使用。Internal use only.
PREEMPTIVE_OS_WRITEFILEGATHERPREEMPTIVE_OS_WRITEFILEGATHER 僅供內部使用。Internal use only.
PREEMPTIVE_OS_WSASETLASTERRORPREEMPTIVE_OS_WSASETLASTERROR 僅供內部使用。Internal use only.
PREEMPTIVE_REENLISTPREEMPTIVE_REENLIST 僅供內部使用。Internal use only.
PREEMPTIVE_RESIZELOGPREEMPTIVE_RESIZELOG 僅供內部使用。Internal use only.
PREEMPTIVE_ROLLFORWARDREDOPREEMPTIVE_ROLLFORWARDREDO 僅供內部使用。Internal use only.
PREEMPTIVE_ROLLFORWARDUNDOPREEMPTIVE_ROLLFORWARDUNDO 僅供內部使用。Internal use only.
PREEMPTIVE_SB_STOPENDPOINTPREEMPTIVE_SB_STOPENDPOINT 僅供內部使用。Internal use only.
PREEMPTIVE_SERVER_STARTUPPREEMPTIVE_SERVER_STARTUP 僅供內部使用。Internal use only.
PREEMPTIVE_SETRMINFOPREEMPTIVE_SETRMINFO 僅供內部使用。Internal use only.
PREEMPTIVE_SHAREDMEM_GETDATAPREEMPTIVE_SHAREDMEM_GETDATA 僅供內部使用。Internal use only.
PREEMPTIVE_SNIOPENPREEMPTIVE_SNIOPEN 僅供內部使用。Internal use only.
PREEMPTIVE_SOSHOSTPREEMPTIVE_SOSHOST 僅供內部使用。Internal use only.
PREEMPTIVE_SOSTESTINGPREEMPTIVE_SOSTESTING 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
PREEMPTIVE_SP_SERVER_DIAGNOSTICSPREEMPTIVE_SP_SERVER_DIAGNOSTICS 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PREEMPTIVE_STARTRMPREEMPTIVE_STARTRM 僅供內部使用。Internal use only.
PREEMPTIVE_STREAMFCB_CHECKPOINTPREEMPTIVE_STREAMFCB_CHECKPOINT 僅供內部使用。Internal use only.
PREEMPTIVE_STREAMFCB_RECOVERPREEMPTIVE_STREAMFCB_RECOVER 僅供內部使用。Internal use only.
PREEMPTIVE_STRESSDRIVERPREEMPTIVE_STRESSDRIVER 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
PREEMPTIVE_TESTINGPREEMPTIVE_TESTING 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
PREEMPTIVE_TRANSIMPORTPREEMPTIVE_TRANSIMPORT 僅供內部使用。Internal use only.
PREEMPTIVE_UNMARSHALPROPAGATIONTOKENPREEMPTIVE_UNMARSHALPROPAGATIONTOKEN 僅供內部使用。Internal use only.
PREEMPTIVE_VSS_CREATESNAPSHOTPREEMPTIVE_VSS_CREATESNAPSHOT 僅供內部使用。Internal use only.
PREEMPTIVE_VSS_CREATEVOLUMESNAPSHOTPREEMPTIVE_VSS_CREATEVOLUMESNAPSHOT 僅供內部使用。Internal use only.
PREEMPTIVE_XE_CALLBACKEXECUTEPREEMPTIVE_XE_CALLBACKEXECUTE 僅供內部使用。Internal use only.
PREEMPTIVE_XE_CX_FILE_OPENPREEMPTIVE_XE_CX_FILE_OPEN 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
PREEMPTIVE_XE_CX_HTTP_CALLPREEMPTIVE_XE_CX_HTTP_CALL 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
PREEMPTIVE_XE_DISPATCHERPREEMPTIVE_XE_DISPATCHER 僅供內部使用。Internal use only.
PREEMPTIVE_XE_ENGINEINITPREEMPTIVE_XE_ENGINEINIT 僅供內部使用。Internal use only.
PREEMPTIVE_XE_GETTARGETSTATEPREEMPTIVE_XE_GETTARGETSTATE 僅供內部使用。Internal use only.
PREEMPTIVE_XE_SESSIONCOMMITPREEMPTIVE_XE_SESSIONCOMMIT 僅供內部使用。Internal use only.
PREEMPTIVE_XE_TARGETFINALIZEPREEMPTIVE_XE_TARGETFINALIZE 僅供內部使用。Internal use only.
PREEMPTIVE_XE_TARGETINITPREEMPTIVE_XE_TARGETINIT 僅供內部使用。Internal use only.
PREEMPTIVE_XE_TIMERRUNPREEMPTIVE_XE_TIMERRUN 僅供內部使用。Internal use only.
PREEMPTIVE_XETESTINGPREEMPTIVE_XETESTING 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
PRINT_ROLLBACK_PROGRESSPRINT_ROLLBACK_PROGRESS 用於使用者處理序在已經使用 ALTER DATABASE 終止子句加以轉換的資料庫中結束時等候。Used to wait while user processes are ended in a database that has been transitioned by using the ALTER DATABASE termination clause. 如需詳細資訊,請參閱 ALTER DATABASE (Transact-sql)。For more information, see ALTER DATABASE (Transact-SQL).
PRU_ROLLBACK_DEFERREDPRU_ROLLBACK_DEFERRED 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_ALL_COMPONENTS_INITIALIZEDPWAIT_ALL_COMPONENTS_INITIALIZED 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_COOP_SCANPWAIT_COOP_SCAN 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_DIRECTLOGCONSUMER_GETNEXTPWAIT_DIRECTLOGCONSUMER_GETNEXT 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PWAIT_EVENT_SESSION_INIT_MUTEXPWAIT_EVENT_SESSION_INIT_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_FABRIC_REPLICA_CONTROLLER_DATA_LOSSPWAIT_FABRIC_REPLICA_CONTROLLER_DATA_LOSS 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PWAIT_HADR_ACTION_COMPLETEDPWAIT_HADR_ACTION_COMPLETED 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNCPWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC 當背景工作正在等候接收(經由輪詢) Windows Server 容錯移轉叢集通知的背景工作終止時發生。Occurs when a background task is waiting for the termination of the background task that receives (via polling) Windows Server Failover Clustering notifications.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADR_CLUSTER_INTEGRATIONPWAIT_HADR_CLUSTER_INTEGRATION [附加]、[取代] 和/或 [移除] 作業正在等候抓取 Always On 內部清單(例如網路、網路位址或可用性群組接聽程式的清單)的寫入鎖定。An append, replace, and/or remove operation is waiting to grab a write lock on an Always On internal list (such as a list of networks, network addresses, or availability group listeners). 僅供內部使用,Internal use only,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADR_FAILOVER_COMPLETEDPWAIT_HADR_FAILOVER_COMPLETED 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADR_JOINPWAIT_HADR_JOIN 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
PWAIT_HADR_OFFLINE_COMPLETEDPWAIT_HADR_OFFLINE_COMPLETED Always On drop 可用性群組作業正在等候目標可用性群組離線,然後再終結 Windows Server 容錯移轉叢集物件。An Always On drop availability group operation is waiting for the target availability group to go offline before destroying Windows Server Failover Clustering objects.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADR_ONLINE_COMPLETEDPWAIT_HADR_ONLINE_COMPLETED Always On 建立或容錯移轉可用性群組作業正在等候目標可用性群組上線。An Always On create or failover availability group operation is waiting for the target availability group to come online.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADR_POST_ONLINE_COMPLETEDPWAIT_HADR_POST_ONLINE_COMPLETED Always On drop 可用性群組作業正在等候先前命令中排程的任何背景工作終止。An Always On drop availability group operation is waiting for the termination of any background task that was scheduled as part of a previous command. 例如,可能會存在將可用性資料庫轉換成主要角色的背景工作。For example, there may be a background task that is transitioning availability databases to the primary role. DROP AVAILABILITY GROUP DDL 必須等候此背景工作終止,才能避免競爭情形。The DROP AVAILABILITY GROUP DDL must wait for this background task to terminate in order to avoid race conditions.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADR_SERVER_READY_CONNECTIONSPWAIT_HADR_SERVER_READY_CONNECTIONS 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADR_WORKITEM_COMPLETEDPWAIT_HADR_WORKITEM_COMPLETED 等候非同步工作完成之執行緒的內部等候。Internal wait by a thread waiting for an async work task to complete. 這是預期的等候,而且適用于 CSS。This is an expected wait and is for CSS use.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_HADRSIMPWAIT_HADRSIM 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
PWAIT_LOG_CONSOLIDATION_IOPWAIT_LOG_CONSOLIDATION_IO 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
PWAIT_LOG_CONSOLIDATION_POLLPWAIT_LOG_CONSOLIDATION_POLL 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
PWAIT_MD_LOGIN_STATSPWAIT_MD_LOGIN_STATS 在內部同步處理登入統計資料的中繼資料時發生。Occurs during internal synchronization in metadata on login stats.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_MD_RELATION_CACHEPWAIT_MD_RELATION_CACHE 在內部同步處理資料表或索引上的中繼資料時發生。Occurs during internal synchronization in metadata on table or index.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_MD_SERVER_CACHEPWAIT_MD_SERVER_CACHE 在連結伺服器的中繼資料內部同步處理期間發生。Occurs during internal synchronization in metadata on linked servers.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_MD_UPGRADE_CONFIGPWAIT_MD_UPGRADE_CONFIG 在升級伺服器範圍設定的內部同步處理期間發生。Occurs during internal synchronization in upgrading server wide configurations.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_PREEMPTIVE_APP_USAGE_TIMERPWAIT_PREEMPTIVE_APP_USAGE_TIMER 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOGPWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_QRY_BPMEMORYPWAIT_QRY_BPMEMORY 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_REPLICA_ONLINE_INIT_MUTEXPWAIT_REPLICA_ONLINE_INIT_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNCPWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
PWAIT_SBS_FILE_OPERATIONPWAIT_SBS_FILE_OPERATION 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
PWAIT_XTP_FSSTORAGE_MAINTENANCEPWAIT_XTP_FSSTORAGE_MAINTENANCE 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
PWAIT_XTP_HOST_STORAGE_WAITPWAIT_XTP_HOST_STORAGE_WAIT 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_ASYNC_CHECK_CONSISTENCY_TASKQDS_ASYNC_CHECK_CONSISTENCY_TASK 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_ASYNC_PERSIST_TASKQDS_ASYNC_PERSIST_TASK 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_ASYNC_PERSIST_TASK_STARTQDS_ASYNC_PERSIST_TASK_START 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_ASYNC_QUEUEQDS_ASYNC_QUEUE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
QDS_BCKG_TASKQDS_BCKG_TASK 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_BLOOM_FILTERQDS_BLOOM_FILTER 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEPQDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_CTXSQDS_CTXS 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_DB_DISKQDS_DB_DISK 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_DYN_VECTORQDS_DYN_VECTOR 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_EXCLUSIVE_ACCESSQDS_EXCLUSIVE_ACCESS 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
QDS_HOST_INITQDS_HOST_INIT 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
QDS_LOADDBQDS_LOADDB 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_PERSIST_TASK_MAIN_LOOP_SLEEPQDS_PERSIST_TASK_MAIN_LOOP_SLEEP 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_QDS_CAPTURE_INITQDS_QDS_CAPTURE_INIT 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
QDS_SHUTDOWN_QUEUEQDS_SHUTDOWN_QUEUE 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_STMTQDS_STMT 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_STMT_DISKQDS_STMT_DISK 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_TASK_SHUTDOWNQDS_TASK_SHUTDOWN 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QDS_TASK_STARTQDS_TASK_START 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QE_WARN_LIST_SYNCQE_WARN_LIST_SYNC 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
QPJOB_KILLQPJOB_KILL 指出非同步自動統計資料更新開始執行時,已被 KILL 的呼叫所取消。Indicates that an asynchronous automatic statistics update was canceled by a call to KILL as the update was starting to run. 終止執行緒已經暫停,正在等候它開始接聽 KILL 命令。The terminating thread is suspended, waiting for it to start listening for KILL commands. 其值最好少於一秒。A good value is less than one second.
QPJOB_WAITFOR_ABORTQPJOB_WAITFOR_ABORT 指出非同步自動統計資料更新在執行時,已被 KILL 的呼叫所取消。Indicates that an asynchronous automatic statistics update was canceled by a call to KILL when it was running. 雖然這項更新已經完成了,但卻被暫停到終止執行緒訊息協調完成為止。The update has now completed but is suspended until the terminating thread message coordination is complete. 這種狀態雖然很平常,卻很少見,而且為時甚短。This is an ordinary but rare state, and should be very short. 其值最好少於一秒。A good value is less than one second.
QRY_MEM_GRANT_INFO_MUTEXQRY_MEM_GRANT_INFO_MUTEX 當查詢執行記憶體管理試圖控制靜態授與資訊清單的存取時發生。Occurs when Query Execution memory management tries to control access to static grant information list. 這個狀態會列出目前已授與和等候中之記憶體要求的相關資訊。This state lists information about the current granted and waiting memory requests. 這個狀態是一種簡單的存取控制狀態。This state is a simple access control state. 這個狀態應該不會有長時間的等候。There should never be a long wait on this state. 如果沒有釋出這個 Mutex,所有新的記憶體使用查詢都會停止回應。If this mutex is not released, all new memory-using queries will stop responding.
QRY_PARALLEL_THREAD_MUTEXQRY_PARALLEL_THREAD_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
QRY_PROFILE_LIST_MUTEXQRY_PROFILE_LIST_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
QUERY_ERRHDL_SERVICE_DONEQUERY_ERRHDL_SERVICE_DONE 僅供參考之用。Identified for informational purposes only. 不支援。Not supported.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
QUERY_WAIT_ERRHDL_SERVICEQUERY_WAIT_ERRHDL_SERVICE 僅供參考之用。Identified for informational purposes only. 不支援。Not supported.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
QUERY_EXECUTION_INDEX_SORT_EVENT_OPENQUERY_EXECUTION_INDEX_SORT_EVENT_OPEN 在離線建立索引建置平行執行時,以及排序中的不同工作者執行緒同步處理排序檔存取作業時的某些情況中發生。Occurs in certain cases when offline create index build is run in parallel, and the different worker threads that are sorting synchronize access to the sort files.
QUERY_NOTIFICATION_MGR_MUTEXQUERY_NOTIFICATION_MGR_MUTEX 在同步處理查詢通知管理員中的記憶體回收佇列時發生。Occurs during synchronization of the garbage collection queue in the Query Notification Manager.
QUERY_NOTIFICATION_SUBSCRIPTION_MUTEXQUERY_NOTIFICATION_SUBSCRIPTION_MUTEX 在同步處理查詢通知中交易的狀態時發生。Occurs during state synchronization for transactions in Query Notifications.
QUERY_NOTIFICATION_TABLE_MGR_MUTEXQUERY_NOTIFICATION_TABLE_MGR_MUTEX 在查詢通知管理員內執行內部同步處理時發生。Occurs during internal synchronization within the Query Notification Manager.
QUERY_NOTIFICATION_UNITTEST_MUTEXQUERY_NOTIFICATION_UNITTEST_MUTEX 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
QUERY_OPTIMIZER_PRINT_MUTEXQUERY_OPTIMIZER_PRINT_MUTEX 在同步處理查詢最佳化工具診斷輸出生產作業時發生。Occurs during synchronization of query optimizer diagnostic output production. 只有在 Microsoft 產品支援的方向已啟用診斷設定時,才會發生這種等候類型。This wait type only occurs if diagnostic settings have been enabled under direction of Microsoft Product Support.
QUERY_TASK_ENQUEUE_MUTEXQUERY_TASK_ENQUEUE_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
QUERY_TRACEOUTQUERY_TRACEOUT 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
RBIO_WAIT_VLFRBIO_WAIT_VLF 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
RBIO_RG_STORAGERBIO_RG_STORAGE 當超大規模資料庫資料庫計算節點因為頁面伺服器上延遲的記錄耗用量而受到節流時發生。Occurs when a Hyperscale database compute node is being throttled due to delayed log consumption at the page server(s).
適用于: Azure SQL Database 超大規模資料庫。Applies to: Azure SQL Database Hyperscale.
RBIO_RG_DESTAGERBIO_RG_DESTAGE 當超大規模資料庫資料庫計算節點因為長期記錄儲存體的延遲記錄耗用量而受到節流時發生。Occurs when a Hyperscale database compute node is being throttled due to delayed log consumption by the long term log storage.
適用于: Azure SQL Database 超大規模資料庫。Applies to: Azure SQL Database Hyperscale.
RBIO_RG_REPLICARBIO_RG_REPLICA 當超大規模資料庫資料庫計算節點因為可讀取的次要複本節點而延遲記錄耗用量而進行節流時發生。Occurs when a Hyperscale database compute node is being throttled due to delayed log consumption by the readable secondary replica node(s).
適用于: Azure SQL Database 超大規模資料庫。Applies to: Azure SQL Database Hyperscale.
RBIO_RG_LOCALDESTAGERBIO_RG_LOCALDESTAGE 當超大規模資料庫資料庫計算節點因為記錄服務而延遲記錄耗用量而進行節流時發生。Occurs when a Hyperscale database compute node is being throttled due to delayed log consumption by the log service.
適用于: Azure SQL Database 超大規模資料庫。Applies to: Azure SQL Database Hyperscale.
RECOVER_CHANGEDBRECOVER_CHANGEDB 在同步處理暖待命資料庫中的資料庫狀態時發生。Occurs during synchronization of database status in warm standby database.
RECOVERY_MGR_LOCKRECOVERY_MGR_LOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
REDO_THREAD_PENDING_WORKREDO_THREAD_PENDING_WORK 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
REDO_THREAD_SYNCREDO_THREAD_SYNC 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
REMOTE_BLOCK_IOREMOTE_BLOCK_IO 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
REMOTE_DATA_ARCHIVE_MIGRATION_DMVREMOTE_DATA_ARCHIVE_MIGRATION_DMV 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
REMOTE_DATA_ARCHIVE_SCHEMA_DMVREMOTE_DATA_ARCHIVE_SCHEMA_DMV 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
REMOTE_DATA_ARCHIVE_SCHEMA_TASK_QUEUEREMOTE_DATA_ARCHIVE_SCHEMA_TASK_QUEUE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
REPL_CACHE_ACCESSREPL_CACHE_ACCESS 在複寫發行項快取上進行同步處理時發生。Occurs during synchronization on a replication article cache. 在這些等候期間,複寫記錄讀取器將會暫停,而已發行資料表上的資料定義語言 (DDL) 陳述式也會遭到封鎖。During these waits, the replication log reader stalls, and data definition language (DDL) statements on a published table are blocked.
REPL_HISTORYCACHE_ACCESSREPL_HISTORYCACHE_ACCESS 僅供內部使用。Internal use only.
REPL_SCHEMA_ACCESSREPL_SCHEMA_ACCESS 在同步處理複寫結構描述版本資訊時發生。Occurs during synchronization of replication schema version information. 在已複寫物件上執行 DDL 陳述式時,以及當記錄讀取器依據 DDL 出現位置來建立或取用版本化結構描述時,都會出現這種狀態。This state exists when DDL statements are executed on the replicated object, and when the log reader builds or consumes versioned schema based on DDL occurrence. 如果您在具有異動複寫的單一發行者上有許多已發行的資料庫,而且已發行的資料庫非常活躍,則可以在這種等候類型上看到爭用。Contention can be seen on this wait type if you have many published databases on a single publisher with transactional replication and the published databases are very active.
REPL_TRANFSINFO_ACCESSREPL_TRANFSINFO_ACCESS 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
REPL_TRANHASHTABLE_ACCESSREPL_TRANHASHTABLE_ACCESS 僅供內部使用。Internal use only.
REPL_TRANTEXTINFO_ACCESSREPL_TRANTEXTINFO_ACCESS 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
REPLICA_WRITESREPLICA_WRITES 在工作等候頁面寫入資料庫快照集或 DBCC 複本完成時發生。Occurs while a task waits for completion of page writes to database snapshots or DBCC replicas.
REQUEST_DISPENSER_PAUSEREQUEST_DISPENSER_PAUSE 當工作在等候所有未處理 I/O 完成,使其可凍結檔案 I/O 以供快照集備份時發生。Occurs when a task is waiting for all outstanding I/O to complete, so that I/O to a file can be frozen for snapshot backup.
REQUEST_FOR_DEADLOCK_SEARCHREQUEST_FOR_DEADLOCK_SEARCH 在死結監視器等候開始下個死結搜尋時發生。Occurs while the deadlock monitor waits to start the next deadlock search. 這個等候應該在兩次死結偵測之間發生,在此資源上的等候時間如果很長,並不表示發生任何問題。This wait is expected between deadlock detections, and lengthy total waiting time on this resource does not indicate a problem.
RESERVED_MEMORY_ALLOCATION_EXTRESERVED_MEMORY_ALLOCATION_EXT 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
RESMGR_THROTTLEDRESMGR_THROTTLED 當新的要求送入,然後根據 GROUP_MAX_REQUESTS 設定降低速度。Occurs when a new request comes in and is throttled based on the GROUP_MAX_REQUESTS setting.
RESOURCE_GOVERNOR_IDLERESOURCE_GOVERNOR_IDLE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
RESOURCE_QUEUERESOURCE_QUEUE 在同步處理各種內部資源佇列時發生。Occurs during synchronization of various internal resource queues.
RESOURCE_SEMAPHORERESOURCE_SEMAPHORE 在其他並行查詢導致查詢記憶體要求無法立即取得授權時發生。Occurs when a query memory request cannot be granted immediately due to other concurrent queries. 如果等候頻率很高且等候時間很長,可能表示並行查詢數目過多、重複編譯,或是記憶體要求量過大。High waits and wait times may indicate excessive number of concurrent queries, or excessive memory request amounts.
RESOURCE_SEMAPHORE_MUTEXRESOURCE_SEMAPHORE_MUTEX 在查詢等候系統滿足其執行緒保留要求時發生。Occurs while a query waits for its request for a thread reservation to be fulfilled. 同步處理查詢編譯與記憶體授權要求時也會發生這種等候類型。It also occurs when synchronizing query compile and memory grant requests.
RESOURCE_SEMAPHORE_QUERY_COMPILERESOURCE_SEMAPHORE_QUERY_COMPILE 當並行查詢編譯數目達到調整流速上限時發生。Occurs when the number of concurrent query compilations reaches a throttling limit. 如果等候頻率很高且等候時間很長,可能表示編譯數目過多,或是計畫無法快取。High waits and wait times may indicate excessive compilations, recompiles, or uncachable plans.
RESOURCE_SEMAPHORE_SMALL_QUERYRESOURCE_SEMAPHORE_SMALL_QUERY 在其他並行查詢導致小型查詢之記憶體要求無法立即取得授權時發生。Occurs when memory request by a small query cannot be granted immediately due to other concurrent queries. 等候時間應該不會超過幾秒鐘,因為如果伺服器無法在幾秒鐘內授權使用要求的記憶體,它就會將要求傳送到主要查詢記憶體集區。Wait time should not exceed more than a few seconds, because the server transfers the request to the main query memory pool if it fails to grant the requested memory within a few seconds. 如果等候頻率很高,可能表示並行的小型查詢數目過多,而主要記憶體集區則受到等候中的查詢所封鎖。High waits may indicate an excessive number of concurrent small queries while the main memory pool is blocked by waiting queries.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
RESTORE_FILEHANDLECACHE_ENTRYLOCKRESTORE_FILEHANDLECACHE_ENTRYLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
RESTORE_FILEHANDLECACHE_LOCKRESTORE_FILEHANDLECACHE_LOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
RG_RECONFIGRG_RECONFIG 僅供內部使用。Internal use only.
ROWGROUP_OP_STATSROWGROUP_OP_STATS 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
ROWGROUP_VERSIONROWGROUP_VERSION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
RTDATA_LISTRTDATA_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
SATELLITE_CARGOSATELLITE_CARGO 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SATELLITE_SERVICE_SETUPSATELLITE_SERVICE_SETUP 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SATELLITE_TASKSATELLITE_TASK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SBS_DISPATCHSBS_DISPATCH 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
SBS_RECEIVE_TRANSPORTSBS_RECEIVE_TRANSPORT 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
SBS_TRANSPORTSBS_TRANSPORT 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
SCAN_CHAR_HASH_ARRAY_INITIALIZATIONSCAN_CHAR_HASH_ARRAY_INITIALIZATION 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SEC_DROP_TEMP_KEYSEC_DROP_TEMP_KEY 在嘗試卸除暫時安全性金鑰失敗之後,再次重試之前發生。Occurs after a failed attempt to drop a temporary security key before a retry attempt.
SECURITY_CNG_PROVIDER_MUTEXSECURITY_CNG_PROVIDER_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
SECURITY_CRYPTO_CONTEXT_MUTEXSECURITY_CRYPTO_CONTEXT_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SECURITY_DBE_STATE_MUTEXSECURITY_DBE_STATE_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SECURITY_KEYRING_RWLOCKSECURITY_KEYRING_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SECURITY_MUTEXSECURITY_MUTEX 當系統等候控制可延伸金鑰管理 (EKM) 密碼編譯提供者之全域清單和 EKM 工作階段之工作階段範圍清單存取權的 Mutex 時發生。Occurs when there is a wait for mutexes that control access to the global list of Extensible Key Management (EKM) cryptographic providers and the session-scoped list of EKM sessions.
SECURITY_RULETABLE_MUTEXSECURITY_RULETABLE_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SEMPLAT_DSI_BUILDSEMPLAT_DSI_BUILD 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SEQUENCE_GENERATIONSEQUENCE_GENERATION 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SEQUENTIAL_GUIDSEQUENTIAL_GUID 正在取得新的循序 GUID 時發生。Occurs while a new sequential GUID is being obtained.
SERVER_IDLE_CHECKSERVER_IDLE_CHECK 當資源監視器嘗試將 SQL Server 實例宣告為閒置或嘗試喚醒時,在同步處理 SQL Server 實例閒置狀態時發生。Occurs during synchronization of SQL Server instance idle status when a resource monitor is attempting to declare a SQL Server instance as idle or trying to wake up.
SERVER_RECONFIGURESERVER_RECONFIGURE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SESSION_WAIT_STATS_CHILDRENSESSION_WAIT_STATS_CHILDREN 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SHARED_DELTASTORE_CREATIONSHARED_DELTASTORE_CREATION 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SHUTDOWNSHUTDOWN 在關機陳述式等候使用中的連接結束時發生。Occurs while a shutdown statement waits for active connections to exit.
SLEEP_BPOOL_FLUSHSLEEP_BPOOL_FLUSH 在檢查點調整流速發出新 I/O 之流速以避免磁碟子系統爆滿時發生。Occurs when a checkpoint is throttling the issuance of new I/Os in order to avoid flooding the disk subsystem.
SLEEP_BUFFERPOOL_HELPLWSLEEP_BUFFERPOOL_HELPLW 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SLEEP_DBSTARTUPSLEEP_DBSTARTUP 在啟動資料庫期間等候所有資料庫復原時發生。Occurs during database startup while waiting for all databases to recover.
SLEEP_DCOMSTARTUPSLEEP_DCOMSTARTUP 在等候 DCOM 初始化完成的 SQL Server 實例啟動期間,最多會發生一次。Occurs once at most during SQL Server instance startup while waiting for DCOM initialization to complete.
SLEEP_MASTERDBREADYSLEEP_MASTERDBREADY 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SLEEP_MASTERMDREADYSLEEP_MASTERMDREADY 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SLEEP_MASTERUPGRADEDSLEEP_MASTERUPGRADED 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SLEEP_MEMORYPOOL_ALLOCATEPAGESSLEEP_MEMORYPOOL_ALLOCATEPAGES 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SLEEP_MSDBSTARTUPSLEEP_MSDBSTARTUP 在 SQL 追蹤等候 msdb 資料庫啟動完成時發生。Occurs when SQL Trace waits for the msdb database to complete startup.
SLEEP_RETRY_VIRTUALALLOCSLEEP_RETRY_VIRTUALALLOC 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SLEEP_SYSTEMTASKSLEEP_SYSTEMTASK 在啟動背景工作期間等候 tempdb 啟動完成時發生。Occurs during the start of a background task while waiting for tempdb to complete startup.
SLEEP_TASKSLEEP_TASK 當工作在等候一般事件發生期間進入休眠時發生。Occurs when a task sleeps while waiting for a generic event to occur.
SLEEP_TEMPDBSTARTUPSLEEP_TEMPDBSTARTUP 在工作等候 tempdb 完成啟動時發生。Occurs while a task waits for tempdb to complete startup.
SLEEP_WORKSPACE_ALLOCATEPAGESLEEP_WORKSPACE_ALLOCATEPAGE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SLO_UPDATESLO_UPDATE 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
SMSYNCSMSYNC 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SNI_CONN_DUPSNI_CONN_DUP 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
SNI_CRITICAL_SECTIONSNI_CRITICAL_SECTION 在 SQL Server 網路元件內的內部同步處理期間發生。Occurs during internal synchronization within SQL Server networking components.
SNI_HTTP_WAITFOR_0_DISCONSNI_HTTP_WAITFOR_0_DISCON 在 SQL Server 關閉期間,等候未處理的 HTTP 連接結束時發生。Occurs during SQL Server shutdown, while waiting for outstanding HTTP connections to exit.
SNI_LISTENER_ACCESSSNI_LISTENER_ACCESS 等候非統一記憶體存取 (NUMA) 節點更新狀態變更時發生。Occurs while waiting for non-uniform memory access (NUMA) nodes to update state change. 狀態變更的存取權是序列化的。Access to state change is serialized.
SNI_TASK_COMPLETIONSNI_TASK_COMPLETION 當系統在 NUMA 節點狀態變更期間等候所有工作完成時發生。Occurs when there is a wait for all tasks to finish during a NUMA node state change.
SNI_WRITE_ASYNCSNI_WRITE_ASYNC 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
SOAP_READSOAP_READ 在等候 HTTP 網路讀取動作完成時發生。Occurs while waiting for an HTTP network read to complete.
SOAP_WRITESOAP_WRITE 在等候 HTTP 網路寫入動作完成時發生。Occurs while waiting for an HTTP network write to complete.
SOCKETDUPLICATEQUEUE_CLEANUPSOCKETDUPLICATEQUEUE_CLEANUP 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
SOS_CALLBACK_REMOVALSOS_CALLBACK_REMOVAL 在回撥清單上執行同步處理以移除回撥時發生。Occurs while performing synchronization on a callback list in order to remove a callback. 在伺服器初始化完成之後,此計數器不應該變更。It is not expected for this counter to change after server initialization is completed.
SOS_DISPATCHER_MUTEXSOS_DISPATCHER_MUTEX 在發送器集區的內部同步處理期間發生。Occurs during internal synchronization of the dispatcher pool. 這包括正在調整集區時。This includes when the pool is being adjusted.
SOS_LOCALALLOCATORLISTSOS_LOCALALLOCATORLIST SQL ServerSQL Server 記憶體管理員中執行內部同步處理時發生。Occurs during internal synchronization in the SQL ServerSQL Server memory manager.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
SOS_MEMORY_TOPLEVELBLOCKALLOCATORSOS_MEMORY_TOPLEVELBLOCKALLOCATOR 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SOS_MEMORY_USAGE_ADJUSTMENTSOS_MEMORY_USAGE_ADJUSTMENT 調整集區之間的記憶體使用量時發生。Occurs when memory usage is being adjusted among pools.
SOS_OBJECT_STORE_DESTROY_MUTEXSOS_OBJECT_STORE_DESTROY_MUTEX 在記憶體集區中執行內部同步處理期間從集區終結物件時發生。Occurs during internal synchronization in memory pools when destroying objects from the pool.
SOS_PHYS_PAGE_CACHESOS_PHYS_PAGE_CACHE 表示執行緒等候取得 Mutex 的時間,執行緒必須取得 Mutex,才能配置實體頁面,或將這些頁面傳回作業系統。Accounts for the time a thread waits to acquire the mutex it must acquire before it allocates physical pages or before it returns those pages to the operating system. 只有當 SQL Server 的實例使用 AWE 記憶體時,才會出現此類型的等候。Waits on this type only appear if the instance of SQL Server uses AWE memory.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SOS_PROCESS_AFFINITY_MUTEXSOS_PROCESS_AFFINITY_MUTEX 在同步處理程序相似性設定的存取作業時發生。Occurs during synchronizing of access to process affinity settings.
SOS_RESERVEDMEMBLOCKLISTSOS_RESERVEDMEMBLOCKLIST 在 SQL Server 記憶體管理員的內部同步處理期間發生。Occurs during internal synchronization in the SQL Server memory manager.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
SOS_SCHEDULER_YIELDSOS_SCHEDULER_YIELD 在工作主動產生排程器以供其他工作執行時發生。Occurs when a task voluntarily yields the scheduler for other tasks to execute. 在這段等候期間,該工作將等候系統更新其配量。During this wait the task is waiting for its quantum to be renewed.
SOS_SMALL_PAGE_ALLOCSOS_SMALL_PAGE_ALLOC 在配置和釋放某些記憶體物件所管理的記憶體期間發生。Occurs during the allocation and freeing of memory that is managed by some memory objects.
SOS_STACKSTORE_INIT_MUTEXSOS_STACKSTORE_INIT_MUTEX 在同步處理內部存放區初始化時發生。Occurs during synchronization of internal store initialization.
SOS_SYNC_TASK_ENQUEUE_EVENTSOS_SYNC_TASK_ENQUEUE_EVENT 在以同步的方式啟動工作時發生。Occurs when a task is started in a synchronous manner. SQL Server 中的大部分工作都是以非同步方式啟動,在工作要求放在工作佇列之後,控制項會立即回到起始處。Most tasks in SQL Server are started in an asynchronous manner, in which control returns to the starter immediately after the task request has been placed on the work queue.
SOS_VIRTUALMEMORY_LOWSOS_VIRTUALMEMORY_LOW 在記憶體配置等候資源管理員釋放虛擬記憶體時發生。Occurs when a memory allocation waits for a resource manager to free up virtual memory.
SOSHOST_EVENTSOSHOST_EVENT 在主控的元件(例如 CLR)等候 SQL Server 事件同步處理物件時發生。Occurs when a hosted component, such as CLR, waits on a SQL Server event synchronization object.
SOSHOST_INTERNALSOSHOST_INTERNAL 在同步處理主控元件 (例如 CLR) 使用的記憶體管理員回撥時發生。Occurs during synchronization of memory manager callbacks used by hosted components, such as CLR.
SOSHOST_MUTEXSOSHOST_MUTEX 當主控的元件(例如 CLR)等候 SQL Server 的 mutex 同步處理物件時發生。Occurs when a hosted component, such as CLR, waits on a SQL Server mutex synchronization object.
SOSHOST_RWLOCKSOSHOST_RWLOCK 在主控的元件(例如 CLR)等候 SQL Server 讀取器寫入器同步處理物件時發生。Occurs when a hosted component, such as CLR, waits on a SQL Server reader-writer synchronization object.
SOSHOST_SEMAPHORESOSHOST_SEMAPHORE 當主控的元件(例如 CLR)等候 SQL Server 信號同步處理物件時發生。Occurs when a hosted component, such as CLR, waits on a SQL Server semaphore synchronization object.
SOSHOST_SLEEPSOSHOST_SLEEP 當主控的工作在等候一般事件發生期間進入休眠時發生。Occurs when a hosted task sleeps while waiting for a generic event to occur. 主控的工作是供主控的元件 (例如 CLR) 使用。Hosted tasks are used by hosted components such as CLR.
SOSHOST_TRACELOCKSOSHOST_TRACELOCK 在同步處理追蹤資料流的存取作業時發生。Occurs during synchronization of access to trace streams.
SOSHOST_WAITFORDONESOSHOST_WAITFORDONE 在主控的元件 (例如 CLR) 等候工作完成時發生。Occurs when a hosted component, such as CLR, waits for a task to complete.
SP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEPSP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEP 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SP_SERVER_DIAGNOSTICS_BUFFER_ACCESSSP_SERVER_DIAGNOSTICS_BUFFER_ACCESS 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SP_SERVER_DIAGNOSTICS_INIT_MUTEXSP_SERVER_DIAGNOSTICS_INIT_MUTEX 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SP_SERVER_DIAGNOSTICS_SLEEPSP_SERVER_DIAGNOSTICS_SLEEP 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SQLCLR_APPDOMAINSQLCLR_APPDOMAIN 在 CLR 等候應用程式網域完成啟動時發生。Occurs while CLR waits for an application domain to complete startup.
SQLCLR_ASSEMBLYSQLCLR_ASSEMBLY 在等候存取 appdomain 中已載入的組件清單時發生。Occurs while waiting for access to the loaded assembly list in the appdomain.
SQLCLR_DEADLOCK_DETECTIONSQLCLR_DEADLOCK_DETECTION 在 CLR 等候死結偵測完成時發生。Occurs while CLR waits for deadlock detection to complete.
SQLCLR_QUANTUM_PUNISHMENTSQLCLR_QUANTUM_PUNISHMENT 在 CLR 工作由於本身已超過其執行配量而進行調整流速時發生。Occurs when a CLR task is throttled because it has exceeded its execution quantum. 執行這項調整流速的目的是為了降低這個大量使用資源的工作對其他工作所造成的影響。This throttling is done in order to reduce the effect of this resource-intensive task on other tasks.
SQLSORT_NORMMUTEXSQLSORT_NORMMUTEX 在內部同步處理期間初始化內部排序結構時發生。Occurs during internal synchronization, while initializing internal sorting structures.
SQLSORT_SORTMUTEXSQLSORT_SORTMUTEX 在內部同步處理期間初始化內部排序結構時發生。Occurs during internal synchronization, while initializing internal sorting structures.
SQLTRACE_BUFFER_FLUSHSQLTRACE_BUFFER_FLUSH 當工作在等候背景工作每四秒將追蹤緩衝區排清到磁碟時發生。Occurs when a task is waiting for a background task to flush trace buffers to disk every four seconds.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
SQLTRACE_FILE_BUFFERSQLTRACE_FILE_BUFFER 在檔案追蹤期間同步處理追蹤緩衝區時發生。Occurs during synchronization on trace buffers during a file trace.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SQLTRACE_FILE_READ_IO_COMPLETIONSQLTRACE_FILE_READ_IO_COMPLETION 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SQLTRACE_FILE_WRITE_IO_COMPLETIONSQLTRACE_FILE_WRITE_IO_COMPLETION 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SQLTRACE_INCREMENTAL_FLUSH_SLEEPSQLTRACE_INCREMENTAL_FLUSH_SLEEP 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SQLTRACE_LOCKSQLTRACE_LOCK 僅供內部使用。Internal use only.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2APPLIES TO: SQL Server 2008 R2SQL Server 2008 R2 only.
SQLTRACE_PENDING_BUFFER_WRITERSSQLTRACE_PENDING_BUFFER_WRITERS 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
SQLTRACE_SHUTDOWNSQLTRACE_SHUTDOWN 在追蹤關機等候未處理的追蹤事件完成時發生。Occurs while trace shutdown waits for outstanding trace events to complete.
SQLTRACE_WAIT_ENTRIESSQLTRACE_WAIT_ENTRIES 在 SQL 追蹤事件佇列等候封包到達佇列時發生。Occurs while a SQL Trace event queue waits for packets to arrive on the queue.
SRVPROC_SHUTDOWNSRVPROC_SHUTDOWN 在關機處理序等候內部資源釋出以完整關機時發生。Occurs while the shutdown process waits for internal resources to be released to shutdown cleanly.
STARTUP_DEPENDENCY_MANAGERSTARTUP_DEPENDENCY_MANAGER 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
TDS_BANDWIDTH_STATETDS_BANDWIDTH_STATE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
TDS_INITTDS_INIT 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
TDS_PROXY_CONTAINERTDS_PROXY_CONTAINER 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
TEMPOBJTEMPOBJ 在已同步處理暫存物件卸除時發生。Occurs when temporary object drops are synchronized. 這種等候很罕見,只有在工作已要求 temp 資料表卸除的獨佔存取權時才會發生。This wait is rare, and only occurs if a task has requested exclusive access for temp table drops.
TEMPORAL_BACKGROUND_PROCEED_CLEANUPTEMPORAL_BACKGROUND_PROCEED_CLEANUP 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
TERMINATE_LISTENERTERMINATE_LISTENER 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
THREADPOOLTHREADPOOL 當工作在等候工作者以供其執行時發生。Occurs when a task is waiting for a worker to run on. 這可能表示工作者設定上限太低,或者批次執行花費的時間超乎尋常地多,因而減少了可以滿足其他批次的可用工作者數目。This can indicate that the maximum worker setting is too low, or that batch executions are taking unusually long, thus reducing the number of workers available to satisfy other batches.
TIMEPRIV_TIMEPERIODTIMEPRIV_TIMEPERIOD 在「擴充事件」計時器的內部同步處理期間發生。Occurs during internal synchronization of the Extended Events timer.
TRACE_EVTNOTIFTRACE_EVTNOTIF 僅供內部使用。Internal use only.
TRACEWRITETRACEWRITE 在 SQL 追蹤資料列集追蹤提供者等候可用緩衝區或具有待處理事件之緩衝區時發生。Occurs when the SQL Trace rowset trace provider waits for either a free buffer or a buffer with events to process.
TRAN_MARKLATCH_DTTRAN_MARKLATCH_DT 在交易標示閂鎖上等候終結模式閂鎖時發生。Occurs when waiting for a destroy mode latch on a transaction mark latch. 交易標示閂鎖可用來同步處理認可與已標示交易。Transaction mark latches are used for synchronization of commits with marked transactions.
TRAN_MARKLATCH_EXTRAN_MARKLATCH_EX 在已標示交易上等候獨佔模式閂鎖時發生。Occurs when waiting for an exclusive mode latch on a marked transaction. 交易標示閂鎖可用來同步處理認可與已標示交易。Transaction mark latches are used for synchronization of commits with marked transactions.
TRAN_MARKLATCH_KPTRAN_MARKLATCH_KP 在已標示交易上等候保留模式閂鎖時發生。Occurs when waiting for a keep mode latch on a marked transaction. 交易標示閂鎖可用來同步處理認可與已標示交易。Transaction mark latches are used for synchronization of commits with marked transactions.
TRAN_MARKLATCH_NLTRAN_MARKLATCH_NL 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
TRAN_MARKLATCH_SHTRAN_MARKLATCH_SH 在已標示交易上等候共用模式閂鎖時發生。Occurs when waiting for a shared mode latch on a marked transaction. 交易標示閂鎖可用來同步處理認可與已標示交易。Transaction mark latches are used for synchronization of commits with marked transactions.
TRAN_MARKLATCH_UPTRAN_MARKLATCH_UP 在已標示交易上等候更新模式閂鎖時發生。Occurs when waiting for an update mode latch on a marked transaction. 交易標示閂鎖可用來同步處理認可與已標示交易。Transaction mark latches are used for synchronization of commits with marked transactions.
TRANSACTION_MUTEXTRANSACTION_MUTEX 在同步處理多個批次對交易的存取作業時發生。Occurs during synchronization of access to a transaction by multiple batches.
UCS_ENDPOINT_CHANGEUCS_ENDPOINT_CHANGE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
UCS_MANAGERUCS_MANAGER 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
UCS_MEMORY_NOTIFICATIONUCS_MEMORY_NOTIFICATION 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
UCS_SESSION_REGISTRATIONUCS_SESSION_REGISTRATION 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
UCS_TRANSPORTUCS_TRANSPORT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
UCS_TRANSPORT_STREAM_CHANGEUCS_TRANSPORT_STREAM_CHANGE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
UTIL_PAGE_ALLOCUTIL_PAGE_ALLOC 在交易記錄掃描在記憶體壓力下等候記憶體變成可供使用的狀態時發生。Occurs when transaction log scans wait for memory to be available during memory pressure.
VDI_CLIENT_COMPLETECOMMANDVDI_CLIENT_COMPLETECOMMAND 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
VDI_CLIENT_GETCOMMANDVDI_CLIENT_GETCOMMAND 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
VDI_CLIENT_OPERATIONVDI_CLIENT_OPERATION 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
VDI_CLIENT_OTHERVDI_CLIENT_OTHER 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
VERSIONING_COMMITTINGVERSIONING_COMMITTING 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
VIA_ACCEPTVIA_ACCEPT 當虛擬介面卡 (VIA) 提供者連接在啟動期間完成時發生。Occurs when a Virtual Interface Adapter (VIA) provider connection is completed during startup.
VIEW_DEFINITION_MUTEXVIEW_DEFINITION_MUTEX 在同步處理快取檢視定義的存取作業時發生。Occurs during synchronization on access to cached view definitions.
WAIT_FOR_RESULTSWAIT_FOR_RESULTS 在等候查詢通知被觸發時發生。Occurs when waiting for a query notification to be triggered.
WAIT_ON_SYNC_STATISTICS_REFRESHWAIT_ON_SYNC_STATISTICS_REFRESH 在等候同步統計資料更新完成,然後查詢編譯和執行可以繼續時發生。Occurs when waiting for synchronous statistics update to complete before query compilation and execution can resume.
適用於:從 SQL Server 2019 (15.x)SQL Server 2019 (15.x)Applies to: Starting with SQL Server 2019 (15.x)SQL Server 2019 (15.x)
WAIT_SCRIPTDEPLOYMENT_REQUESTWAIT_SCRIPTDEPLOYMENT_REQUEST 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_SCRIPTDEPLOYMENT_WORKERWAIT_SCRIPTDEPLOYMENT_WORKER 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XLOGREAD_SIGNALWAIT_XLOGREAD_SIGNAL 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
WAIT_XTP_ASYNC_TX_COMPLETIONWAIT_XTP_ASYNC_TX_COMPLETION 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_CKPT_AGENT_WAKEUPWAIT_XTP_CKPT_AGENT_WAKEUP 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_CKPT_CLOSEWAIT_XTP_CKPT_CLOSE 在等候檢查點完成時發生。Occurs when waiting for a checkpoint to complete.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_CKPT_ENABLEDWAIT_XTP_CKPT_ENABLED 當檢查點已停用,且正在等候檢查點啟用時發生。Occurs when checkpointing is disabled, and waiting for checkpointing to be enabled.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_CKPT_STATE_LOCKWAIT_XTP_CKPT_STATE_LOCK 同步檢查檢查點狀態時發生。Occurs when synchronizing checking of checkpoint state.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_COMPILE_WAITWAIT_XTP_COMPILE_WAIT 僅供內部使用。Internal use only.
適用於SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。APPLIES TO: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
WAIT_XTP_GUESTWAIT_XTP_GUEST 當資料庫記憶體配置器需要停止接收低記憶體通知時發生。Occurs when the database memory allocator needs to stop receiving low-memory notifications.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
WAIT_XTP_HOST_WAITWAIT_XTP_HOST_WAIT 當資料庫引擎觸發等候並由主機執行時,就會發生。Occurs when waits are triggered by the database engine and implemented by the host.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_OFFLINE_CKPT_BEFORE_REDOWAIT_XTP_OFFLINE_CKPT_BEFORE_REDO 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_OFFLINE_CKPT_LOG_IOWAIT_XTP_OFFLINE_CKPT_LOG_IO 離線檢查點等候記錄讀取 IO 完成時發生。Occurs when offline checkpoint is waiting for a log read IO to complete.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_OFFLINE_CKPT_NEW_LOGWAIT_XTP_OFFLINE_CKPT_NEW_LOG 當離線檢查點在等候新記錄檔記錄進行掃描時發生。Occurs when offline checkpoint is waiting for new log records to scan.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_PROCEDURE_ENTRYWAIT_XTP_PROCEDURE_ENTRY 當 drop 程式正在等候該程式的所有目前執行完成時發生。Occurs when a drop procedure is waiting for all current executions of that procedure to complete.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_RECOVERYWAIT_XTP_RECOVERY 當資料庫復原在等候記憶體優化物件的復原完成時發生。Occurs when database recovery is waiting for recovery of memory-optimized objects to finish.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAIT_XTP_SERIAL_RECOVERYWAIT_XTP_SERIAL_RECOVERY 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
WAIT_XTP_SWITCH_TO_INACTIVEWAIT_XTP_SWITCH_TO_INACTIVE 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
WAIT_XTP_TASK_SHUTDOWNWAIT_XTP_TASK_SHUTDOWN 在等候記憶體內部 OLTP 執行緒完成時發生。Occurs when waiting for an In-Memory OLTP thread to complete.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
WAIT_XTP_TRAN_DEPENDENCYWAIT_XTP_TRAN_DEPENDENCY 在等候交易相依性時發生。Occurs when waiting for transaction dependencies.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WAITFORWAITFOR 發生于 WAITFOR Transact-sql 語句的結果。Occurs as a result of a WAITFOR Transact-SQL statement. 等候的持續時間由陳述式的參數決定。The duration of the wait is determined by the parameters to the statement. 這是使用者起始的等候。This is a user-initiated wait.
WAITFOR_PER_QUEUEWAITFOR_PER_QUEUE 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
WAITFOR_TASKSHUTDOWNWAITFOR_TASKSHUTDOWN 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
WAITSTAT_MUTEXWAITSTAT_MUTEX 在同步處理用來擴展 sys.dm_os_wait_stats 之統計資料集合的存取作業時發生。Occurs during synchronization of access to the collection of statistics used to populate sys.dm_os_wait_stats.
WCCWCC 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
WINDOW_AGGREGATES_MULTIPASSWINDOW_AGGREGATES_MULTIPASS 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
WINFAB_API_CALLWINFAB_API_CALL 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WINFAB_REPLICA_BUILD_OPERATIONWINFAB_REPLICA_BUILD_OPERATION 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
WINFAB_REPORT_FAULTWINFAB_REPORT_FAULT 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
WORKTBL_DROPWORKTBL_DROP 在工作資料表卸除失敗之後,於重試之前暫停時發生。Occurs while pausing before retrying, after a failed worktable drop.
WRITE_COMPLETIONWRITE_COMPLETION 當寫入作業正在進行時發生。Occurs when a write operation is in progress.
WRITELOGWRITELOG 在等候記錄排清完成時發生。Occurs while waiting for a log flush to complete. 造成記錄排清的一般作業包括檢查點和交易認可。Common operations that cause log flushes are checkpoints and transaction commits.
XACT_OWN_TRANSACTIONXACT_OWN_TRANSACTION 在等候取得交易的擁有權時發生。Occurs while waiting to acquire ownership of a transaction.
XACT_RECLAIM_SESSIONXACT_RECLAIM_SESSION 在等候工作階段目前的擁有者釋出工作階段擁有權時發生。Occurs while waiting for the current owner of a session to release ownership of the session.
XACTLOCKINFOXACTLOCKINFO 在同步處理交易鎖定清單的存取作業時發生。Occurs during synchronization of access to the list of locks for a transaction. 除了交易本身之外,諸如死結偵測和鎖定移轉等作業也會在頁面分割時存取鎖定清單。In addition to the transaction itself, the list of locks is accessed by operations such as deadlock detection and lock migration during page splits.
XACTWORKSPACE_MUTEXXACTWORKSPACE_MUTEX 在同步處理從交易脫離的作業,以及交易之編列成員之間的資料庫鎖定數目時發生。Occurs during synchronization of defections from a transaction, as well as the number of database locks between enlist members of a transaction.
XDB_CONN_DUP_HASHXDB_CONN_DUP_HASH 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
XDES_HISTORYXDES_HISTORY 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
XDES_OUT_OF_ORDER_LISTXDES_OUT_OF_ORDER_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
XDES_SNAPSHOTXDES_SNAPSHOT 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
XDESTSVERMGRXDESTSVERMGR 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
XE_BUFFERMGR_ALLPROCESSED_EVENTXE_BUFFERMGR_ALLPROCESSED_EVENT 當擴充的事件工作階段緩衝區排清至目標時發生。Occurs when Extended Events session buffers are flushed to targets. 這項等候發生在背景執行緒中。This wait occurs on a background thread.
XE_BUFFERMGR_FREEBUF_EVENTXE_BUFFERMGR_FREEBUF_EVENT 當下列其中一個條件成立時發生:Occurs when either of the following conditions is true:
XE_CALLBACK_LISTXE_CALLBACK_LIST 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
XE_CX_FILE_READXE_CX_FILE_READ 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
XE_DISPATCHER_CONFIG_SESSION_LISTXE_DISPATCHER_CONFIG_SESSION_LIST 當使用非同步目標的擴充的事件工作階段啟動或停止時發生。Occurs when an Extended Events session that is using asynchronous targets is started or stopped. 這個等候表示下列其中一個狀況:This wait indicates either of the following:
XE_DISPATCHER_JOINXE_DISPATCHER_JOIN 當用於擴充的事件工作階段的背景執行緒結束時發生。Occurs when a background thread that is used for Extended Events sessions is terminating.
XE_DISPATCHER_WAITXE_DISPATCHER_WAIT 當用於擴充的事件工作階段的背景執行緒正在等候事件緩衝區處理時發生。Occurs when a background thread that is used for Extended Events sessions is waiting for event buffers to process.
XE_FILE_TARGET_TVFXE_FILE_TARGET_TVF 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
XE_LIVE_TARGET_TVFXE_LIVE_TARGET_TVF 僅供內部使用。Internal use only.
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.
XE_MODULEMGR_SYNCXE_MODULEMGR_SYNC 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
XE_OLS_LOCKXE_OLS_LOCK 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
XE_PACKAGE_LOCK_BACKOFFXE_PACKAGE_LOCK_BACKOFF 僅供參考之用。Identified for informational purposes only. 不支援。Not supported.
適用于:僅 SQL Server 2008 R2SQL Server 2008 R2Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
XE_SERVICES_EVENTMANUALXE_SERVICES_EVENTMANUAL 僅供內部使用。Internal use only.
XE_SERVICES_MUTEXXE_SERVICES_MUTEX 僅供內部使用。Internal use only.
XE_SERVICES_RWLOCKXE_SERVICES_RWLOCK 僅供內部使用。Internal use only.
XE_SESSION_CREATE_SYNCXE_SESSION_CREATE_SYNC 僅供內部使用。Internal use only.
XE_SESSION_FLUSHXE_SESSION_FLUSH 僅供內部使用。Internal use only.
XE_SESSION_SYNCXE_SESSION_SYNC 僅供內部使用。Internal use only.
XE_STM_CREATEXE_STM_CREATE 僅供內部使用。Internal use only.
XE_TIMER_EVENTXE_TIMER_EVENT 僅供內部使用。Internal use only.
XE_TIMER_MUTEXXE_TIMER_MUTEX 僅供內部使用。Internal use only.
XE_TIMER_TASK_DONEXE_TIMER_TASK_DONE 僅供內部使用。Internal use only.
XIO_CREDENTIAL_MGR_RWLOCKXIO_CREDENTIAL_MGR_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
XIO_CREDENTIAL_RWLOCKXIO_CREDENTIAL_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
XIO_EDS_MGR_RWLOCKXIO_EDS_MGR_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
XIO_EDS_RWLOCKXIO_EDS_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
XIO_IOSTATS_BLOBLIST_RWLOCKXIO_IOSTATS_BLOBLIST_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
XIO_IOSTATS_FCBLIST_RWLOCKXIO_IOSTATS_FCBLIST_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2017 (14.x)SQL Server 2017 (14.x) 及更新版本。Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) and later.
XIO_LEASE_RENEW_MGR_RWLOCKXIO_LEASE_RENEW_MGR_RWLOCK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
XTP_HOST_DB_COLLECTIONXTP_HOST_DB_COLLECTION 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
XTP_HOST_LOG_ACTIVITYXTP_HOST_LOG_ACTIVITY 僅供內部使用。Internal use only.
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
XTP_HOST_PARALLEL_RECOVERYXTP_HOST_PARALLEL_RECOVERY 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
XTP_PREEMPTIVE_TASKXTP_PREEMPTIVE_TASK 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
XTP_TRUNCATION_LSNXTP_TRUNCATION_LSN 僅供內部使用。Internal use only.
適用對象SQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更新版本。Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.
XTPPROC_CACHE_ACCESSXTPPROC_CACHE_ACCESS 在存取所有原生編譯的預存程式快取物件時發生。Occurs when for accessing all natively compiled stored procedure cache objects.,
適用對象SQL Server 2014 (12.x)SQL Server 2014 (12.x) 及更新版本。Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) and later.
XTPPROC_PARTITIONED_STACK_CREATEXTPPROC_PARTITIONED_STACK_CREATE 在針對指定的程式配置每個 NUMA 節點原生編譯預存程式快取結構(必須針對單一執行緒執行)時發生。Occurs when allocating per-NUMA node natively compiled stored procedure cache structures (must be done single threaded) for a given procedure.,
適用對象SQL Server 2012 (11.x)SQL Server 2012 (11.x) 及更新版本。Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) and later.

下列 XEvents 與資料分割切換和線上索引重建相關。The following XEvents are related to partition SWITCH and online index rebuild. 如需語法的詳細資訊,請參閱 (alter TABLE) transact-sqlalter ( )INDEX transact-sqlFor information about syntax, see ALTER TABLE (Transact-SQL) and ALTER INDEX (Transact-SQL).

  • lock_request_priority_statelock_request_priority_state

  • process_killed_by_abort_blockersprocess_killed_by_abort_blockers

  • ddl_with_wait_at_low_priorityddl_with_wait_at_low_priority

如需鎖定相容性矩陣,請參閱sys.databases (dm_tran_locks)For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).

另請參閱See also

SQL Server 作業系統相關的動態管理 Views (transact-sql) SQL Server Operating System Related Dynamic Management Views (Transact-SQL)
dm_exec_session_wait_stats (transact-sql) sys.dm_exec_session_wait_stats (Transact-SQL)
dm_db_wait_stats (Azure SQL Database)sys.dm_db_wait_stats (Azure SQL Database)