Dynamic Management Views and Dynamic Management Functions - Microsoft SQL Server 2012 Performance Tuning - page 164

Column name Description

user_objects_dealloc_page_count This column represents the total number

of pages that have been deallocated or/
and are no longer reserved for user-defined
objects by the session.

internal_objects_alloc_page_count This column represents the total number

of pages that have been allocated to or
reserved for internal objects by the session.

This column represents the total number of
pages that have been deallocated or/and
are no longer reserved for internal objects
by the session.

internal_objects_dealloc_page_
count

sys.dm_db_file_space_usage (DMV)
sys.dm_db_file_space_usage is a dynamic management view. This DMV returns space
usage details by providing page allocation and deallocation details for each TempDB file.
This DMV can be used to monitor the number of unallocated, allocated, or reserved pages
in TempDB database. The following are some of the useful columns of this DMV:

Column name Description
file_id This column represents the internal ID of the
file assigned by SQL Server. This file_id
can be associated and used in Joins with
sys.master_files system catalog view
along with database_id .
unallocated_extent_page_count This column represents the total number of
pages in unallocated extents. This column
can be used to calculate free space in
TempDB database.
version_store_reserved_page_count This column represents the total number
of pages in uniform extents that have been
allocated or reserved for version store
mechanism.

user_object_reserved_page_count This column represents the total number

of pages in uniform extents that have been
allocated or reserved for user-defined objects.

internal_object_reserved_page_
count

This column represents the total number
of pages in uniform extent that have been
allocated or reserved for internal objects.