vicky
SSC Enthusiast
Points: 187
More actions
January 28, 2020 at 3:57 am
#3720816
Hello Team,
I am using DMV dm_db_index_physical_status to replace the DBCC is sql server 2016.
Anybody have any sample code to see how this can be done to get the below
ObjectName CHAR (255),
ObjectId INT,
IndexName CHAR (255),
IndexId INT,
Level INT,
CountPages INT,
CountRows INT,
MinRecSize INT,
MaxRecSize INT,
AvgRecSize INT,
ForRecCount INT,
Extents INT,
ExtentSwitches INT,
AvgFreeBytes INT,
AvgPageDensity INT,
ScanDensity DECIMAL,
BestCount INT,
ActualCount INT,
LogicalFrag DECIMAL,
ExtentFrag DECIMAL
Thanks.
Site Owners
SSC Guru
Points: 80320
January 29, 2020 at 4:10 am
#3721086
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply