This collection provides general details of full text indexes.
Sum of all active wait events; equal to the session total activity within the specified time range. | |
Time spent by the various sessions waiting for CLR code execution to complete. | |
Percentage of time spent by the various sessions waiting for CLR code execution to complete. | |
Time spent by the various sessions consuming CPU cycles. This reading is taken directly from the operating system, rather than SQL Server wait states. | |
Percentage of time spent by the various sessions waiting for CLR code execution to complete. | |
Time spent by the various sessions waiting for cursor synchronization operations to complete. | |
Time spent by the various sessions waiting for replication synchronization events to complete. | |
Time spent by the various sessions waiting for various distributed transaction events to complete. | |
Time spent by the various sessions waiting for external procedures to end. | |
Time spent by the various sessions waiting for full text synchronization operations. | |
Time spent by the various sessions waiting for hosted components, such as, but not exclusively, CLR. | |
Time spent by the various sessions waiting for a bulk load I/O to finish. | |
Time spent by the various sessions waiting for I/O operations to complete. | |
Time spent by the various sessions waiting for physical I/O operations to complete. | |
Time spent by the various sessions waiting to latch a buffer that is not an I/O request. | |
Time spent by the various sessions waiting to synchronize commits to marked transactions. | |
Time spent waiting for internal locks (latches) to be released. | |
Time spent by the various sessions waiting to acquire bulk update locks. | |
Time spent by the various sessions waiting to acquire exclusive locks. | |
Time spent by the various sessions waiting to acquire intent locks. | |
Time spent by the various sessions waiting to acquire schema locks. | |
Time spent by the various sessions waiting to acquire shared locks. | |
Time spent by the various sessions waiting to acquire update locks. | |
Time spent by the various sessions waiting for miscellaneous logs. | |
Time spent by the various sessions waiting to see whether log truncation frees log space. | |
Time spent waiting by the various processes waiting for a Log operation to complete. | |
Time spent by the various sessions waiting for memory resources to be made available. | |
Time spent by the various sessions waiting for outstanding HTTP connections to complete and exit. | |
Time spent by the various sessions waiting for network packets. | |
Time spent by the various sessions waiting for network I/O operations to complete. | |
Percentage of time spent by the various sessions waiting for network I/O operations to complete. | |
Overall active time during the specified time range, excluding general remote provider wait time. | |
Time spent by various processes waiting for the Microsoft Full Text Engine for SQL Server. | |
Time spent by the various sessions waiting for miscellaneous database operations. | |
Time spent by the various sessions waiting for parallel coordination tasks to complete. | |
Time spent by the various sessions waiting for Service Broker event handlers and endpoints. | |
Time spent waiting for in-memory log and checkpoint related events. | |
Time spent waiting for events related to natively compiled stored procedures. |
This collection provides data for a list of SQL Server wait events, divided by wait events.
This collection is an on-demand collection, which has no pre-defined sampling intervals.
ID of any SQL Server error message, which is returned if the job failed. | |||||||||
The run status can have one of the following values:
| |||||||||
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center