1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
DECLARE @db_name SYSNAME;
SET @db_name = N'<databaseName>';
DECLARE @extentinfo TABLE
(
[file_id] INT,
[page_id] INT,
pg_alloc INT,
ext_size INT,
[object_id] INT,
index_id INT,
partition_number INT,
partition_id BIGINT,
iam_chain_type VARCHAR(50),
pfs_bytes VARCHAR(100)
);
INSERT INTO @extentinfo
EXEC('DBCC EXTENTINFO(' + @db_name + ')');
SELECT
[file_id],
SUM(page_alloc) AS page_count,
MIN([page_id]) AS page_id_min,
MAX([page_id]) AS page_id_max
FROM @extentinfo
GROUP BY [file_id]; |
Partager