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

适用对象: yesSQL ServeryesAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse 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. sys.dm_exec_session_wait_stats (TRANSACT-SQL) 提供类似的会话的信息。sys.dm_exec_session_wait_stats (Transact-SQL) provides similar information by session.

备注

若要调用此项从 Azure SQL 数据仓库Azure SQL Data Warehouse并行数据仓库Parallel Data Warehouse ,使用的名称sys.dm_pdw_nodes_os_wait_statsTo call this from Azure SQL 数据仓库Azure SQL Data Warehouse 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 SQL 数据仓库Azure SQL Data Warehouse并行数据仓库Parallel Data WarehouseApplies to: Azure SQL 数据仓库Azure SQL Data Warehouse, 并行数据仓库Parallel Data Warehouse

权限Permissions

SQL ServerSQL Server,需要VIEW SERVER STATE权限。On SQL ServerSQL Server, requires VIEW SERVER STATE permission.
SQL 数据库SQL Database高级层,需要VIEW DATABASE STATE数据库中的权限。On SQL 数据库SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission in the database. SQL 数据库SQL Database标准版和基本层,需要服务器管理员Azure Active Directory 管理员帐户。On SQL 数据库SQL 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 ServerIn 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.

typetype 描述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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
AM_SCHEMAMGR_UNSHARED_CACHEAM_SCHEMAMGR_UNSHARED_CACHE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
ASSEMBLY_FILTER_HASHTABLEASSEMBLY_FILTER_HASHTABLE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
ASYNC_OP_CONTEXT_READASYNC_OP_CONTEXT_READ 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
ASYNC_OP_CONTEXT_WRITEASYNC_OP_CONTEXT_WRITE 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
ASYNC_SOCKETDUP_IOASYNC_SOCKETDUP_IO 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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.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 当后台可疑页记录器正在尝试避免每隔五秒以上的时间运行时出现。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
BROKER_TASK_SHUTDOWNBROKER_TASK_SHUTDOWN 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
BROKER_TO_FLUSHBROKER_TO_FLUSH 当 Service Broker 延迟 flusher 刷新将内存中传输对象添加到工作表时发生。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
BROKER_TRANSMISSION_TABLEBROKER_TRANSMISSION_TABLE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
BROKER_TRANSMISSION_WORKBROKER_TRANSMISSION_WORK 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
CHECK_TABLES_INITIALIZATIONCHECK_TABLES_INITIALIZATION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
CHECK_TABLES_SINGLE_SCANCHECK_TABLES_SINGLE_SCAN 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
CHECK_TABLES_THREAD_BARRIERCHECK_TABLES_THREAD_BARRIER 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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 当某任务当前正在执行公共语言运行时 (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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
COLUMNSTORE_COLUMNDATASET_SESSION_LISTCOLUMNSTORE_COLUMNDATASET_SESSION_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
COMMIT_TABLECOMMIT_TABLE 仅限内部使用。Internal use only.
CONNECTION_ENDPOINT_LOCKCONNECTION_ENDPOINT_LOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
COUNTRECOVERYMGRCOUNTRECOVERYMGR 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
CREATE_DATINISERVICECREATE_DATINISERVICE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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 数据库SQL 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 数据库SQL 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 数据库SQL 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 数据库SQL 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
DBSEEDING_OPERATIONDBSEEDING_OPERATION 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
DIRTY_PAGE_POLLDIRTY_PAGE_POLL 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
DIRTY_PAGE_SYNCDIRTY_PAGE_SYNC 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
DIRTY_PAGE_TABLE_LOCKDIRTY_PAGE_TABLE_LOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
DROP_DATABASE_TIMER_TASKDROP_DATABASE_TIMER_TASK 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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. Microsoft 分布式事务处理协调器 (MS DTC) 事务的恢复发生后 SQL Server 接收通知的 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
DTCNEW_PREPAREDTCNEW_PREPARE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
DTCNEW_RECOVERYDTCNEW_RECOVERY 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
DTCNEW_TMDTCNEW_TM 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
DTCNEW_TRANSACTION_ENLISTMENTDTCNEW_TRANSACTION_ENLISTMENT 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
DTCPNTSYNCDTCPNTSYNC 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
EXTERNAL_SCRIPT_NETWORK_IOEXTERNAL_SCRIPT_NETWORK_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) through current.
EXTERNAL_SCRIPT_PREPARE_SERVICEEXTERNAL_SCRIPT_PREPARE_SERVICE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
EXTERNAL_SCRIPT_SHUTDOWNEXTERNAL_SCRIPT_SHUTDOWN 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
EXTERNAL_WAIT_ON_LAUNCHER,EXTERNAL_WAIT_ON_LAUNCHER, 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
FABRIC_HADR_TRANSPORT_CONNECTIONFABRIC_HADR_TRANSPORT_CONNECTION 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
FABRIC_REPLICA_CONTROLLER_LISTFABRIC_REPLICA_CONTROLLER_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIGFABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
FABRIC_REPLICA_PUBLISHER_EVENT_PUBLISHFABRIC_REPLICA_PUBLISHER_EVENT_PUBLISH 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LISTFABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_DB_KILL_FLAGFFT_NSO_DB_KILL_FLAG 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_DB_LISTFFT_NSO_DB_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_FCBFFT_NSO_FCB 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_FCB_FINDFFT_NSO_FCB_FIND 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_FCB_PARENTFFT_NSO_FCB_PARENT 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_FCB_RELEASE_CACHED_ENTRIESFFT_NSO_FCB_RELEASE_CACHED_ENTRIES 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_FCB_STATEFFT_NSO_FCB_STATE 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_FILEOBJECTFFT_NSO_FILEOBJECT 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_NSO_TABLE_LISTFFT_NSO_TABLE_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_NTFS_STOREFFT_NTFS_STORE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_RECOVERYFFT_RECOVERY 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_RSFX_COMMFFT_RSFX_COMM 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_RSFX_WAIT_FOR_MEMORYFFT_RSFX_WAIT_FOR_MEMORY 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_STARTUP_SHUTDOWNFFT_STARTUP_SHUTDOWN 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_STORE_DBFFT_STORE_DB 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_STORE_ROWSET_LISTFFT_STORE_ROWSET_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FFT_STORE_TABLEFFT_STORE_TABLE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FILE_VALIDATION_THREADSFILE_VALIDATION_THREADS 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
FILESTREAM_CACHEFILESTREAM_CACHE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FILESTREAM_CHUNKERFILESTREAM_CHUNKER 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FILESTREAM_CHUNKER_INITFILESTREAM_CHUNKER_INIT 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FILESTREAM_FCBFILESTREAM_FCB 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FILESTREAM_FILE_OBJECTFILESTREAM_FILE_OBJECT 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FILESTREAM_WORKITEM_QUEUEFILESTREAM_WORKITEM_QUEUE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FILETABLE_SHUTDOWNFILETABLE_SHUTDOWN 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
FOREIGN_REDOFOREIGN_REDO 仅限内部使用。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) through current.
FORWARDER_TRANSITIONFORWARDER_TRANSITION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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 操作等待的 FILESTREAM 代理资源正由另一个文件 I/O 操作使用时出现。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
GHOSTCLEANUP_UPDATE_STATSGHOSTCLEANUP_UPDATE_STATS 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
GHOSTCLEANUPSYNCMGRGHOSTCLEANUPSYNCMGR 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
GLOBAL_QUERY_CANCELGLOBAL_QUERY_CANCEL 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
GLOBAL_QUERY_CLOSEGLOBAL_QUERY_CLOSE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
GLOBAL_QUERY_CONSUMERGLOBAL_QUERY_CONSUMER 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
GLOBAL_QUERY_PRODUCERGLOBAL_QUERY_PRODUCER 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
GLOBAL_TRAN_CREATEGLOBAL_TRAN_CREATE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
GLOBAL_TRAN_UCS_SESSIONGLOBAL_TRAN_UCS_SESSION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
GUARDIANGUARDIAN 标识为仅供参考。Identified for informational purposes only. 不提供支持。Not supported. 不保证以后的兼容性。Future compatibility is not guaranteed.
HADR_AG_MUTEXHADR_AG_MUTEX Alwayson 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_AR_CRITICAL_SECTION_ENTRYHADR_AR_CRITICAL_SECTION_ENTRY Alwayson 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_AR_UNLOAD_COMPLETEDHADR_AR_UNLOAD_COMPLETED 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_BACKUP_BULK_LOCKHADR_BACKUP_BULK_LOCK Alwayson 主数据库收到来自辅助数据库的备份请求并且正在等待后台线程完成对获取或释放 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_BACKUP_QUEUEHADR_BACKUP_QUEUE Alwayson 主数据库的备份后台线程正在等待来自辅助数据库的新工作请求。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_CONNECTIVITY_INFOHADR_CONNECTIVITY_INFO 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_DATABASE_WAIT_FOR_RECOVERYHADR_DATABASE_WAIT_FOR_RECOVERY 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HADR_DATABASE_WAIT_FOR_RESTARTHADR_DATABASE_WAIT_FOR_RESTART 正在等待重新启动 Alwayson 可用性组控制下的数据库。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_DB_COMMANDHADR_DB_COMMAND 正在等待响应会话消息 (这需要从的另一端,使用 Alwayson 会话消息基础结构的显式响应)。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_DB_OP_COMPLETION_SYNCHADR_DB_OP_COMPLETION_SYNC 正在等待响应会话消息 (这需要从的另一端,使用 Alwayson 会话消息基础结构的显式响应)。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_DB_OP_START_SYNCHADR_DB_OP_START_SYNC Alwayson 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_DBSEEDINGHADR_DBSEEDING 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
HADR_DBSEEDING_LISTHADR_DBSEEDING_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_FABRIC_CALLBACKHADR_FABRIC_CALLBACK 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
HADR_FILESTREAM_BLOCK_FLUSHHADR_FILESTREAM_BLOCK_FLUSH FILESTREAM Alwayson 传输管理器正在等待,直到处理的日志块的完成。,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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_FILESTREAM_FILE_CLOSEHADR_FILESTREAM_FILE_CLOSE FILESTREAM Alwayson 传输管理器正在等待,直到下一步的 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_FILESTREAM_IOMGRHADR_FILESTREAM_IOMGR FILESTREAM Alwayson 传输管理器正在等待 R/W 锁来保护 FILESTREAM 始终在 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_FILESTREAM_IOMGR_IOCOMPLETIONHADR_FILESTREAM_IOMGR_IOCOMPLETION 文件流始终在 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_FILESTREAM_MANAGERHADR_FILESTREAM_MANAGER FILESTREAM Alwayson 传输管理器正在等待 R/W 锁来保护 FILESTREAM Alwayson 传输管理器启动或关机期间。,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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_FILESTREAM_PREPROCHADR_FILESTREAM_PREPROC 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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、 捕获和发送操作。,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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_PARTNER_SYNCHADR_PARTNER_SYNC 对伙伴列表的并发控制等待。,Concurrency control wait on the partner list.,
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_READ_ALL_NETWORKSHADR_READ_ALL_NETWORKS 等待获取对 WSFC 网络列表的读取或写入访问。Waiting to get read or write access to the list of WSFC networks. 仅限内部使用。Internal use only. 注意:引擎保存动态管理视图 (如 sys.dm_hadr_cluster_networks) 中使用的 WSFC 网络列表,或若要验证始终在 TRANSACT-SQL 语句引用 WSFC 网络信息。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 相关通知和内部 Alwayson 重新启动 (例如,丢失和重新获取 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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.exe) 和动态管理视图中跟踪进度。,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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_SEEDING_CANCELLATIONHADR_SEEDING_CANCELLATION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HADR_SEEDING_FILE_LISTHADR_SEEDING_FILE_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HADR_SEEDING_LIMIT_BACKUPSHADR_SEEDING_LIMIT_BACKUPS 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HADR_SEEDING_SYNC_COMPLETIONHADR_SEEDING_SYNC_COMPLETION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HADR_SEEDING_TIMEOUT_TASKHADR_SEEDING_TIMEOUT_TASK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HADR_SEEDING_WAIT_FOR_COMPLETIONHADR_SEEDING_WAIT_FOR_COMPLETION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HADR_SYNC_COMMITHADR_SYNC_COMMIT 正在等待针对同步辅助数据库的事务提交处理来强制写入日志。Waiting for transaction commit processing for the synchronized secondary databases to harden the log. 事务延迟性能计数器也会反映这一等待。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_TDS_LISTENER_SYNCHADR_TDS_LISTENER_SYNC 内部 Alwayson 系统或 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_TDS_LISTENER_SYNC_PROCESSINGHADR_TDS_LISTENER_SYNC_PROCESSING 需要启动和/或停止某一可用性组侦听器的 Alwayson 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_THROTTLE_LOG_RATE_GOVERNORHADR_THROTTLE_LOG_RATE_GOVERNOR 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
HADR_THROTTLE_LOG_RATE_SEEDINGHADR_THROTTLE_LOG_RATE_SEEDING 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_TRANSPORT_DBRLISTHADR_TRANSPORT_DBRLIST 正在等待访问传输层的数据库副本列表。Waiting for access to the transport layer's database replica list. 用于授予对其访问权限的自旋锁。,Used for the spinlock that grants access to it.,
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HADR_XRF_STACK_ACCESSHADR_XRF_STACK_ACCESS 访问 (查找、 添加和删除) Alwayson 可用性数据库的扩展的恢复分叉堆栈。,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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
HCCO_CACHEHCCO_CACHE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HK_RESTORE_FILEMAPHK_RESTORE_FILEMAP 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HKCS_PARALLEL_MIGRATIONHKCS_PARALLEL_MIGRATION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
HKCS_PARALLEL_RECOVERYHKCS_PARALLEL_RECOVERY 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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.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.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.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.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.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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
LOG_POOL_SCANLOG_POOL_SCAN 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
LOG_RATE_GOVERNORLOG_RATE_GOVERNOR 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
LOGPOOL_CONSUMERLOGPOOL_CONSUMER 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
LOGPOOL_CONSUMERSETLOGPOOL_CONSUMERSET 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
LOGPOOL_FREEPOOLSLOGPOOL_FREEPOOLS 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
LOGPOOL_MGRSETLOGPOOL_MGRSET 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
LOGPOOL_REPLACEMENTSETLOGPOOL_REPLACEMENTSET 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
LOGPOOLREFCOUNTEDOBJECT_REFDONELOGPOOLREFCOUNTEDOBJECT_REFDONE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
MD_LAZYCACHE_RWLOCKMD_LAZYCACHE_RWLOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
MEMORY_GRANT_UPDATEMEMORY_GRANT_UPDATE 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
METADATA_LAZYCACHE_RWLOCKMETADATA_LAZYCACHE_RWLOCK 仅限内部使用。Internal use only.
适用于:SQL Server 2008 R2SQL Server 2008 R2仅。Applies to: SQL Server 2008 R2SQL Server 2008 R2 only.
MIGRATIONBUFFERMIGRATIONBUFFER 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
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. 它用于检测潜在的多个活动的结果集 (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. 请求必须先获取互斥体才可以使用事务。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PARALLEL_REDO_FLOW_CONTROLPARALLEL_REDO_FLOW_CONTROL 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PARALLEL_REDO_LOG_CACHEPARALLEL_REDO_LOG_CACHE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PARALLEL_REDO_TRAN_LISTPARALLEL_REDO_TRAN_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PARALLEL_REDO_TRAN_TURNPARALLEL_REDO_TRAN_TURN 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PARALLEL_REDO_WORKER_SYNCPARALLEL_REDO_WORKER_SYNC 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PARALLEL_REDO_WORKER_WAIT_WORKPARALLEL_REDO_WORKER_WAIT_WORK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
POOL_LOG_RATE_GOVERNORPOOL_LOG_RATE_GOVERNOR 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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 R2仅。Applies 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 R2仅。Applies 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 计划程序切换到抢先模式时发生,以便执行故障转移群集操作。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 Always On 可用性组租约管理器 Microsoft 支持诊断的计划。,Always On Availability Groups lease manager scheduling for Microsoft Support diagnostics.,
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PREEMPTIVE_HTTP_EVENT_WAITPREEMPTIVE_HTTP_EVENT_WAIT 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PREEMPTIVE_HTTP_REQUESTPREEMPTIVE_HTTP_REQUEST 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
PREEMPTIVE_XE_CX_HTTP_CALLPREEMPTIVE_XE_CX_HTTP_CALL 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_ALL_COMPONENTS_INITIALIZEDPWAIT_ALL_COMPONENTS_INITIALIZED 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_COOP_SCANPWAIT_COOP_SCAN 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_DIRECTLOGCONSUMER_GETNEXTPWAIT_DIRECTLOGCONSUMER_GETNEXT 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PWAIT_EVENT_SESSION_INIT_MUTEXPWAIT_EVENT_SESSION_INIT_MUTEX 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_FABRIC_REPLICA_CONTROLLER_DATA_LOSSPWAIT_FABRIC_REPLICA_CONTROLLER_DATA_LOSS 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADR_ACTION_COMPLETEDPWAIT_HADR_ACTION_COMPLETED 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADR_CLUSTER_INTEGRATIONPWAIT_HADR_CLUSTER_INTEGRATION 追加、 替换和/或删除操作正在等待获取 Alwayson 内部列表 (例如网络、 网络地址或可用性组侦听器的列表) 上的写入锁。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADR_FAILOVER_COMPLETEDPWAIT_HADR_FAILOVER_COMPLETED 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADR_JOINPWAIT_HADR_JOIN 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADR_OFFLINE_COMPLETEDPWAIT_HADR_OFFLINE_COMPLETED Alwayson 删除可用性组操作正在等待目标可用性组在销毁 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADR_ONLINE_COMPLETEDPWAIT_HADR_ONLINE_COMPLETED Alwayson 创建或故障转移可用性组操作正在等待目标可用性组联机。,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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADR_POST_ONLINE_COMPLETEDPWAIT_HADR_POST_ONLINE_COMPLETED Alwayson 删除可用性组操作正在等待作为之前命令的一部分计划任何后台任务终止。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADR_SERVER_READY_CONNECTIONSPWAIT_HADR_SERVER_READY_CONNECTIONS 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_HADRSIMPWAIT_HADRSIM 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
PWAIT_LOG_CONSOLIDATION_IOPWAIT_LOG_CONSOLIDATION_IO 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
PWAIT_LOG_CONSOLIDATION_POLLPWAIT_LOG_CONSOLIDATION_POLL 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_PREEMPTIVE_APP_USAGE_TIMERPWAIT_PREEMPTIVE_APP_USAGE_TIMER 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOGPWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_QRY_BPMEMORYPWAIT_QRY_BPMEMORY 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_REPLICA_ONLINE_INIT_MUTEXPWAIT_REPLICA_ONLINE_INIT_MUTEX 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
PWAIT_SBS_FILE_OPERATIONPWAIT_SBS_FILE_OPERATION 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
PWAIT_XTP_FSSTORAGE_MAINTENANCEPWAIT_XTP_FSSTORAGE_MAINTENANCE 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
PWAIT_XTP_HOST_STORAGE_WAITPWAIT_XTP_HOST_STORAGE_WAIT 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_ASYNC_CHECK_CONSISTENCY_TASKQDS_ASYNC_CHECK_CONSISTENCY_TASK 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_ASYNC_PERSIST_TASKQDS_ASYNC_PERSIST_TASK 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_ASYNC_PERSIST_TASK_STARTQDS_ASYNC_PERSIST_TASK_START 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_ASYNC_QUEUEQDS_ASYNC_QUEUE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
QDS_BCKG_TASKQDS_BCKG_TASK 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_BLOOM_FILTERQDS_BLOOM_FILTER 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_CTXSQDS_CTXS 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_DB_DISKQDS_DB_DISK 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_DYN_VECTORQDS_DYN_VECTOR 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_EXCLUSIVE_ACCESSQDS_EXCLUSIVE_ACCESS 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
QDS_HOST_INITQDS_HOST_INIT 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
QDS_LOADDBQDS_LOADDB 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_PERSIST_TASK_MAIN_LOOP_SLEEPQDS_PERSIST_TASK_MAIN_LOOP_SLEEP 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_QDS_CAPTURE_INITQDS_QDS_CAPTURE_INIT 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
QDS_SHUTDOWN_QUEUEQDS_SHUTDOWN_QUEUE 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_STMTQDS_STMT 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_STMT_DISKQDS_STMT_DISK 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_TASK_SHUTDOWNQDS_TASK_SHUTDOWN 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QDS_TASK_STARTQDS_TASK_START 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
QE_WARN_LIST_SYNCQE_WARN_LIST_SYNC 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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. 如果未释放互斥体,则所有占用内存的新查询都将停止响应。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
QRY_PROFILE_LIST_MUTEXQRY_PROFILE_LIST_MUTEX 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
QUERY_ERRHDL_SERVICE_DONEQUERY_ERRHDL_SERVICE_DONE 标识为仅供参考。Identified for informational purposes only. 不提供支持。Not supported.
适用于:SQL Server 2008 R2SQL Server 2008 R2仅。Applies 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 R2仅。Applies 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
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 数据库的超大规模。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 数据库的超大规模。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 数据库的超大规模。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 数据库的超大规模。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
REDO_THREAD_PENDING_WORKREDO_THREAD_PENDING_WORK 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
REDO_THREAD_SYNCREDO_THREAD_SYNC 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
REMOTE_BLOCK_IOREMOTE_BLOCK_IO 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
REMOTE_DATA_ARCHIVE_MIGRATION_DMVREMOTE_DATA_ARCHIVE_MIGRATION_DMV 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
REMOTE_DATA_ARCHIVE_SCHEMA_DMVREMOTE_DATA_ARCHIVE_SCHEMA_DMV 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
REMOTE_DATA_ARCHIVE_SCHEMA_TASK_QUEUEREMOTE_DATA_ARCHIVE_SCHEMA_TASK_QUEUE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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 R2仅。Applies 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
RESTORE_FILEHANDLECACHE_LOCKRESTORE_FILEHANDLECACHE_LOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
RG_RECONFIGRG_RECONFIG 仅限内部使用。Internal use only.
ROWGROUP_OP_STATSROWGROUP_OP_STATS 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
ROWGROUP_VERSIONROWGROUP_VERSION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
RTDATA_LISTRTDATA_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
SATELLITE_CARGOSATELLITE_CARGO 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
SATELLITE_SERVICE_SETUPSATELLITE_SERVICE_SETUP 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
SATELLITE_TASKSATELLITE_TASK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
SBS_DISPATCHSBS_DISPATCH 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
SBS_RECEIVE_TRANSPORTSBS_RECEIVE_TRANSPORT 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
SBS_TRANSPORTSBS_TRANSPORT 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
SCAN_CHAR_HASH_ARRAY_INITIALIZATIONSCAN_CHAR_HASH_ARRAY_INITIALIZATION 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
SECURITY_CRYPTO_CONTEXT_MUTEXSECURITY_CRYPTO_CONTEXT_MUTEX 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SECURITY_DBE_STATE_MUTEXSECURITY_DBE_STATE_MUTEX 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
SECURITY_KEYRING_RWLOCKSECURITY_KEYRING_RWLOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SECURITY_MUTEXSECURITY_MUTEX 当等待互斥体时出现,这些互斥体控制对可扩展的密钥管理 (EKM) 加密提供程序的全局列表以及 EKM 会话的会话作用域列表的访问。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SEMPLAT_DSI_BUILDSEMPLAT_DSI_BUILD 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SEQUENCE_GENERATIONSEQUENCE_GENERATION 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SESSION_WAIT_STATS_CHILDRENSESSION_WAIT_STATS_CHILDREN 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
SHARED_DELTASTORE_CREATIONSHARED_DELTASTORE_CREATION 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SLEEP_MASTERMDREADYSLEEP_MASTERMDREADY 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SLEEP_MASTERUPGRADEDSLEEP_MASTERUPGRADED 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SLEEP_MEMORYPOOL_ALLOCATEPAGESSLEEP_MEMORYPOOL_ALLOCATEPAGES 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
SLO_UPDATESLO_UPDATE 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
SMSYNCSMSYNC 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
SNI_CONN_DUPSNI_CONN_DUP 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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 R2仅。Applies 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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 考虑到线程等待获得互斥体的时间,它必须在分配物理页前或将这些页返回操作系统前获得。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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 R2仅。Applies 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 的互斥体同步对象时发生。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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SP_SERVER_DIAGNOSTICS_BUFFER_ACCESSSP_SERVER_DIAGNOSTICS_BUFFER_ACCESS 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SP_SERVER_DIAGNOSTICS_INIT_MUTEXSP_SERVER_DIAGNOSTICS_INIT_MUTEX 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SP_SERVER_DIAGNOSTICS_SLEEPSP_SERVER_DIAGNOSTICS_SLEEP 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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 R2仅。Applies 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SQLTRACE_FILE_READ_IO_COMPLETIONSQLTRACE_FILE_READ_IO_COMPLETION 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SQLTRACE_FILE_WRITE_IO_COMPLETIONSQLTRACE_FILE_WRITE_IO_COMPLETION 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SQLTRACE_INCREMENTAL_FLUSH_SLEEPSQLTRACE_INCREMENTAL_FLUSH_SLEEP 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
SQLTRACE_LOCKSQLTRACE_LOCK 仅限内部使用。Internal use only.
适用于:SQL Server 2008 R2SQL Server 2008 R2仅。APPLIES 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
TDS_BANDWIDTH_STATETDS_BANDWIDTH_STATE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
TDS_INITTDS_INIT 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
TDS_PROXY_CONTAINERTDS_PROXY_CONTAINER 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
TERMINATE_LISTENERTERMINATE_LISTENER 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
UCS_MANAGERUCS_MANAGER 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
UCS_MEMORY_NOTIFICATIONUCS_MEMORY_NOTIFICATION 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
UCS_SESSION_REGISTRATIONUCS_SESSION_REGISTRATION 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
UCS_TRANSPORTUCS_TRANSPORT 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
UCS_TRANSPORT_STREAM_CHANGEUCS_TRANSPORT_STREAM_CHANGE 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
VDI_CLIENT_GETCOMMANDVDI_CLIENT_GETCOMMAND 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
VDI_CLIENT_OPERATIONVDI_CLIENT_OPERATION 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
VDI_CLIENT_OTHERVDI_CLIENT_OTHER 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
VERSIONING_COMMITTINGVERSIONING_COMMITTING 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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(预览版)SQL Server 2019 previewApplies to: Starting with SQL Server 2019(预览版)SQL Server 2019 preview
WAIT_SCRIPTDEPLOYMENT_REQUESTWAIT_SCRIPTDEPLOYMENT_REQUEST 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WAIT_SCRIPTDEPLOYMENT_WORKERWAIT_SCRIPTDEPLOYMENT_WORKER 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WAIT_XLOGREAD_SIGNALWAIT_XLOGREAD_SIGNAL 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
WAIT_XTP_ASYNC_TX_COMPLETIONWAIT_XTP_ASYNC_TX_COMPLETION 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WAIT_XTP_CKPT_AGENT_WAKEUPWAIT_XTP_CKPT_AGENT_WAKEUP 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WAIT_XTP_COMPILE_WAITWAIT_XTP_COMPILE_WAIT 仅限内部使用。Internal use only.
适用范围:SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017APPLIES TO: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WAIT_XTP_OFFLINE_CKPT_BEFORE_REDOWAIT_XTP_OFFLINE_CKPT_BEFORE_REDO 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WAIT_XTP_PROCEDURE_ENTRYWAIT_XTP_PROCEDURE_ENTRY 当删除过程等待要完成该过程的所有当前执行时出现。,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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WAIT_XTP_SERIAL_RECOVERYWAIT_XTP_SERIAL_RECOVERY 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
WAIT_XTP_SWITCH_TO_INACTIVEWAIT_XTP_SWITCH_TO_INACTIVE 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
WAIT_XTP_TRAN_DEPENDENCYWAIT_XTP_TRAN_DEPENDENCY 当等待事务依赖关系时出现。,Occurs when waiting for transaction dependencies.,
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
WINFAB_API_CALLWINFAB_API_CALL 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WINFAB_REPLICA_BUILD_OPERATIONWINFAB_REPLICA_BUILD_OPERATION 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
WINFAB_REPORT_FAULTWINFAB_REPORT_FAULT 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
XDES_HISTORYXDES_HISTORY 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
XDES_OUT_OF_ORDER_LISTXDES_OUT_OF_ORDER_LIST 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
XDES_SNAPSHOTXDES_SNAPSHOT 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
XDESTSVERMGRXDESTSVERMGR 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
XE_CX_FILE_READXE_CX_FILE_READ 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
XE_LIVE_TARGET_TVFXE_LIVE_TARGET_TVF 仅限内部使用。Internal use only.
适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.
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 R2仅。Applies 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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
XIO_CREDENTIAL_RWLOCKXIO_CREDENTIAL_RWLOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
XIO_EDS_MGR_RWLOCKXIO_EDS_MGR_RWLOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
XIO_EDS_RWLOCKXIO_EDS_RWLOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
XIO_IOSTATS_BLOBLIST_RWLOCKXIO_IOSTATS_BLOBLIST_RWLOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
XIO_IOSTATS_FCBLIST_RWLOCKXIO_IOSTATS_FCBLIST_RWLOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2017 (14.x)SQL Server 2017 (14.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2017 (14.x)SQL Server 2017 (14.x) through SQL Server 2017SQL Server 2017.
XIO_LEASE_RENEW_MGR_RWLOCKXIO_LEASE_RENEW_MGR_RWLOCK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
XTP_HOST_DB_COLLECTIONXTP_HOST_DB_COLLECTION 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
XTP_HOST_LOG_ACTIVITYXTP_HOST_LOG_ACTIVITY 仅限内部使用。Internal use only.
适用范围SQL Server 2014 (12.x)SQL Server 2014 (12.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
XTP_HOST_PARALLEL_RECOVERYXTP_HOST_PARALLEL_RECOVERY 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
XTP_PREEMPTIVE_TASKXTP_PREEMPTIVE_TASK 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
XTP_TRUNCATION_LSNXTP_TRUNCATION_LSN 仅限内部使用。Internal use only.
适用范围SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2016 (13.x)SQL Server 2016 (13.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2014 (12.x)SQL Server 2014 (12.x) through SQL Server 2017SQL Server 2017.
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)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.

以下 Xevent 与分区相关交换机和联机索引重新生成。The following XEvents are related to partition SWITCH and online index rebuild. 有关语法的信息,请参阅ALTER TABLE (TRANSACT-SQL) ALTER INDEX (-)For 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.dm_tran_locks (TRANSACT-SQL)For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).

请参阅See also

与 SQL Server 操作系统相关的动态管理视图(Transact SQL) SQL Server Operating System Related Dynamic Management Views (Transact-SQL)
sys.dm_exec_session_wait_stats (TRANSACT-SQL) sys.dm_exec_session_wait_stats (Transact-SQL)
sys.dm_db_wait_stats (Azure SQL 数据库)sys.dm_db_wait_stats (Azure SQL Database)