This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In the previous post, I shared basic about Forwarded Records in Heap table of SQL Server.
In this post, I am sharing a script to check the count of Forwarded Records of a Table.
In the below script, you can add a filter of your database and table for getting the number of Forwarding Records.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SELECT OBJECT_NAME(object_id) as TableName ,index_type_desc ,page_count ,avg_page_space_used_in_percent ,avg_record_size_in_bytes ,forwarded_record_count FROM sys.dm_db_index_physical_stats ( DB_ID('database_name') ,OBJECT_ID('table_name') ,NULL ,NULL ,'DETAILED' ) GO |
Leave a Reply