34,587
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('DBCCResult') IS NOT NULL
DROP TABLE DBCCResult
GO
CREATE TABLE DBCCResult (
PageFID NVARCHAR(200),
PagePID NVARCHAR(200),
IAMFID NVARCHAR(200),
IAMPID NVARCHAR(200),
ObjectID NVARCHAR(200),
IndexID NVARCHAR(200),
PartitionNumber NVARCHAR(200),
PartitionID NVARCHAR(200),
iam_chain_type NVARCHAR(200),
PageType NVARCHAR(200),
IndexLevel NVARCHAR(200),
NextPageFID NVARCHAR(200),
NextPagePID NVARCHAR(200),
PrevPageFID NVARCHAR(200),
PrevPagePID NVARCHAR(200)
)
IF OBJECT_ID('spaces') IS NOT NULL
DROP TABLE spaces
GO
create table spaces(
Id int identity(1,1) primary key,
s1 Varchar(20),
s2 char(30),
Ids int
)
insert into spaces(s1,s2,Ids) values(null,null,null)
insert into spaces(s1,s2,Ids) values(1,null,1)
insert into spaces(s1,s2,Ids) values(null,2,1)
insert into spaces(s1,s2,Ids) values(3,3,1)
SELECT [index_id], [index_type_desc], [alloc_unit_type_desc], [index_depth],
[index_level], [avg_fragmentation_in_percent], [fragment_count],
[page_count]
FROM [sys].[dm_db_index_physical_stats](DB_ID('test'),
OBJECT_ID('test.dbo.spaces'),
NULL, NULL, NULL)
INSERT INTO DBCCResult EXEC ('DBCC IND(test, spaces,-1) ')
--PageType Page type: 1 = data page, 2 = index page, 3 = LOB_MIXED_PAGE, 4 = LOB_TREE_PAGE, 10 = IAM page
SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
DBCC TRACEON(3604,-1)
GO
DBCC PAGE(test,1,16136023,3)