-------------------------------------------------
NOTE: Extended stored procedure xp_memory_size has been marked as deprecated. It will be removed from the product in version 9.0.
-------------------------------------------------
Extended stored procedure to return the contiguous memory availability of the system within the SQL Server process space. This is the space to be utilized for the transfer buffer for backup and restore operations.
EXEC master.dbo.xp_memory_size
Column Name |
Data Type |
Description |
---|---|---|
ContiguousSize |
Int |
Available contiguous memory in the SQL Server process space in bytes. |
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center