Hallo,
Siehe MSDN sys.allocation_units (Transact-SQL)
:
total_pages = Gesamtanzahl der Seiten, die von dieser Zuordnungseinheit zugeordnet oder reserviert wurden.
used_pages = Gesamtanzahl der tatsächlich verwendeten Seiten
Bei mir ist immer "total_pages" größer als "user_pages". Man kann die Seitenzahl auch über sys.dm_db_partition_stats (Transact-SQL) ermitteln, was liefert das als Ergebnis?
SELECT SCH.name AS SchemaName,
OBJ.name AS ObjName, OBJ.type_desc AS ObjType,
INDX.name AS IndexName, INDX.type_desc AS IndexType,
PART.partition_number AS PartitionNumber,
PART.rows AS PartitionRows,
STAT.row_count AS StatRowCount,
STAT.used_page_count * 8 AS UsedSizeKB,
STAT.reserved_page_count * 8 AS RevervedSizeKB
FROM sys.partitions AS PART
INNER JOIN sys.dm_db_partition_stats AS STAT
ON PART.partition_id = STAT.partition_id
AND PART.partition_number = STAT.partition_number
INNER JOIN sys.objects AS OBJ
ON STAT.object_id = OBJ.object_id
INNER JOIN sys.schemas AS SCH
ON OBJ.schema_id = SCH.schema_id
INNER JOIN sys.indexes AS INDX
ON STAT.object_id = INDX.object_id
AND STAT.index_id = INDX.index_id
ORDER BY SCH.name, OBJ.name, INDX.name, PART.partition_number
Olaf Helper
[
Blog] [
Xing] [
MVP]
