sys.dm_db_file_space_usage

file

#file#dmv

Description

Analytics Platform System (PDW) Returns space usage information for each data file in the database. In Azure SQL Database, the values are unique within a single database or an elastic pool, but not within a : SQL Server 2012 (11.x) and later versions. : SQL Server 2012 (11.x) and later versions. Total number of pages in the data file. : SQL Server 2012 (11.x) and later versions.

Syntax

allocated_extent_page_count

Examples

Example 1

tempdb

Example 2

sys.dm_db_file_space_usage.database_id

Example 3

file_id sys.dm_io_virtual_file_stats.database_id

Example 4

file_id

Example 5

VIEW
SERVER STATE

Example 6

##MS_ServerStateReader##

Example 7

VIEW DATABASE STATE

Example 8

##MS_ServerStateReader##