Below you will find the code to get information about forwarded records. Simply select the text and copy to the Clipboard.
SELECT *
FROM sys.dm_os_performance_counters
WHERE counter_name = ‘Forwarded Records/sec’
SELECT OBJECT_NAME(object_id) AS ‘Table’
, forwarded_record_count
, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats
(DB_ID(), NULL, NULL, NULL, ‘DETAILED’)
WHERE forwarded_record_count IS NOT NULL
This code was written using the Microsoft SQL Server documentation. If you find that this code was copied from else where, please let me know so I can give proper credit.