Collections:
What Is sys.allocation_units
What Is sys.allocation_units view in SQL Server?
✍: FYIcenter.com
sys.allocation_units is a system view in a SQL Server Database that contains information about each allocation unit of a data partition to a physical file.
Each record in the sys.allocation_units table represents a single allocation of a data partition with the following key fields:
Here is a list of records from sys.allocation_units showing data allocation units used in a SQL Server database:
SELECT * FROM sys.allocation_units allocation_unit_id type container_id data_space_id total_pages used_pages ... 397632 1 397632 1 166 125 ... 463168 1 463168 1 64 36 ... 528704 1 528704 1 74 54 ... 594240 1 594240 1 4 4 ...
sys.allocation_units contains key information to map the data partition to logical filegroup, and tracks the storage usage in units of pages (also called blocks). By the way, the page size is fixed to 8 KB.
⇒ Find the File IDs of a Given Table
2019-06-29, 4180🔥, 0💬
Popular Posts:
Where to find tutorials on UFT (Unified Functional Testing) tool? I want to know how to use UFT. Her...
How to find out my browser's identification information? To help you to see your browser identificat...
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing ...
Where to find tutorials on UFT (Unified Functional Testing) tool? I want to know how to use UFT. Her...