I am using SolarWinds Orion Monitor - SQL Performance Counter > Forwarded Records/Batch Requests. I have received an alert that is indicating that we have exceeded the warning threshold. When I run the following query on the database involved
SELECT
OBJECT_NAME(ps.object_id) as TableName,
i.name as IndexName,
ps.index_type_desc,
ps.page_count,
ps.avg_fragmentation_in_percent,
ps.forwarded_record_count
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'DETAILED') AS ps
INNER JOIN sys.indexes AS i
ON ps.OBJECT_ID = i.OBJECT_ID
AND ps.index_id = i.index_id
I receive the following results:
My question is this, if the index_type_desc with a value of "HEAP" represents the tables without a CLUSTERED INDEX, and the avg_fragmentation_in_percent and forwarded_record_count are both at zero, how can I identify the culprit for this specific alert? My goal is to identify where the HEAP is located and eliminate the issue by introducing a CLUSTERED INDEX.
I am new to THWACK and SolarWinds so please be very specific with any advice or recommendations.
