Get Live Help
The amount of virtual memory that the SQL Server process has reserved for use in the paging file (s).
Time spent by the various sessions waiting for tasks started synchronously (most SQL Server processes are started asynchronously).
Lock escalation takes place when a specific query, which obtains a large number of locks at the row or page level, is automatically upgraded to a table lock level. This upgrade is being carried out as granting a single lock at this level; this is deemed more effective than creating and granting a many locks at lower levels.