This collection provides a summary of all data and log files within a SQL Server instance.
Total space (in megabytes) used by SQL Server files on all drives. |
This collection provides general details of full text indexes.
The collection shows amount of InMemory OLTP (XTP) Memory usage.
The total amount of memory used by the tables, including row versions. | |
The total amount of memory used by the indices, including row versions. | |
The total amount of memory used by the system, including row versions. |
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center