Index Usage — ACME-203-0-113-155

Index reportsACME-203-0-113-170 ACME-198-51-100-45 ACME-192-0-2-15-MSSQL25-1433 ACME-198-51-100-66 ACME-198-51-100-210 ACME-198-51-100-60 ACME-192-0-2-243 ACME-203-0-113-99 ACME-198-51-100-92 ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242ACME-203-0-113-155

Index Usage Report — ACME-203-0-113-155

Host: 203.0.113.155

Collected: 2026-09-15T18:01:19Z

Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-203-0-113-155

Fleet inventory: http://192.0.2.15:8080/report_dba/database-inventory.html

They are zeroed by a restart, so user_seeks = 0 means "not used since that instant", not "never used". last_stats_update is a different clock again: it is set by UPDATE STATISTICS / auto-update, not by usage, so a heavily used index can still carry statistics from months ago.

Metric	Count	Meaning
indexes_total	61	every index on a CatalogHistory table
used	2	had a seek, scan or lookup
unused	0	written but never read
cold	59	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	29	nonclustered, not unique, no constraint, never read

By database

Database	Total	Cold	Disabled	Droppable	Recommend action
host-705	59	59	0	29	review the drop candidates above

Drop candidates (29)

Nonclustered, not unique, not enforcing a constraint, never read. Highest write cost first — that is what the index is charging for.

Index	last_read	State	Recommend action
host-705.dbo.ShipmentLine.ShipmentLine$UserMachineID	never	COLD	review, then DROP
host-705.dbo.AssetArchive.AssetArchive$IX_BillingLog	never	COLD	review, then DROP
host-705.dbo.AssetArchive.AssetArchive$id	never	COLD	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODEDETAIL	never	COLD	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODENAME	never	COLD	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODEBANK	never	COLD	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODENUMBER	never	COLD	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODESOCIAL	never	COLD	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODETAX	never	COLD	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$COMID	never	COLD	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$DEPTNAME	never	COLD	review, then DROP
host-705.dbo.TicketSnapshot.TicketSnapshot$UMS_ID	never	COLD	review, then DROP
host-705.dbo.BillingLine.BillingLine$UMS_ID	never	COLD	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_GroupID	never	COLD	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_TranferID	never	COLD	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$Leaveid	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$HOLIDAYID	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$Leaveid	never	COLD	review, then DROP
host-705.dbo.PayrollDaily.PayrollDaily$DeptID	never	COLD	review, then DROP
host-705.dbo.SalesLine.SalesLine$Idle	never	COLD	review, then DROP
host-705.dbo.SalesLine.SalesLine$Series_ID	never	COLD	review, then DROP
host-705.dbo.MODE.IX_PayrollMonthly	never	COLD	review, then DROP
host-705.dbo.PolicyHistory.PolicyHistory$USERID	never	COLD	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$ID	never	COLD	review, then DROP
host-705.dbo.MeterQueue.MeterQueue$ID	never	COLD	review, then DROP
host-705.dbo.PolicyDetail.PolicyDetail$USERID	never	COLD	review, then DROP
host-705.dbo.CampaignSnapshot.CampaignSnapshot$M_ID	never	COLD	review, then DROP
host-705.dbo.CampaignSnapshot.CampaignSnapshot$UMI_ID	never	COLD	review, then DROP
host-705.dbo.ShipmentLine.ShipmentLine$UI_ID	never	COLD	review, then DROP

All indexes (61)

Every index on the instance, including the healthy ones — the answer to "is THIS index used?" has to be here, not only the problems.

Index	id	Type	Uniq	PK	seeks	scans	updates	last_read	last_stats_update	State	Recommend action
CAMPAIGN.dbo.RosterEntry.PK_ReconcileLog	1	CLUSTERED	Y	Y	65127	67592	73360	2026-09-16 01:00:01	2026-09-15 22:00:00	USED	KEEP — primary key
CAMPAIGN.dbo.CampaignStaging.PK_SalesDetail	1	CLUSTERED	Y	Y	14	78	1	2026-09-15 12:00:50	2026-09-12 22:00:01	USED	KEEP — primary key
host-705.dbo.InvoiceDetail.InvoiceDetail$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.StaffingHeader.StaffingHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.AssetArchive.AssetArchive$IX_BillingLog	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.AssetArchive.AssetArchive$IX_SupplierDaily	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.AssetArchive.AssetArchive$id	3	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODEDETAIL	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODENAME	3	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.BatchDaily.BatchDaily$CODEBANK	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODENUMBER	3	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODESOCIAL	4	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODETAX	5	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	2026-01-13 15:36:17	COLD	KEEP — primary key
host-705.dbo.MeterMonthly.MeterMonthly$COMID	2	NONCLUSTERED			0	0	0	never	2026-01-13 15:36:17	COLD	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$DEPTID	1	CLUSTERED	Y	Y	0	0	0	never	2026-01-13 15:36:17	COLD	KEEP — primary key
host-705.dbo.MeterMonthly.MeterMonthly$DEPTNAME	3	NONCLUSTERED			0	0	0	never	2026-01-13 15:36:17	COLD	review, then DROP
host-705.dbo.TicketSnapshot.TicketSnapshot$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.TicketSnapshot.TicketSnapshot$UMS_ID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.BillingLine.BillingLine$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.BillingLine.BillingLine$UMS_ID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.CampaignLog.CampaignLog$S_GroupID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_TranferID	3	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$Leaveid	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollHeader.PayrollHeader$HOLIDAYID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$Leaveid	3	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollDaily.PayrollDaily$DeptID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollDaily.PayrollDaily$IX_InvoiceStaging	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollDaily.PayrollDaily$IX_CatalogDetail	3	NONCLUSTERED	Y		0	0	0	never	never	COLD	review carefully — unique
host-705.dbo.QuotaHeader.QuotaHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.CustomerHistory.CustomerHistory$Index_A53BD582_2B04_434C	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.MODE.IX_PayrollMonthly	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.MODE.IX_CustomerLine	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.SalesLine.SalesLine$Idle	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.SalesLine.SalesLine$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	2026-01-14 07:36:50	COLD	KEEP — primary key
host-705.dbo.SalesLine.SalesLine$Series_ID	3	NONCLUSTERED			0	0	0	never	2026-01-14 07:35:30	COLD	review, then DROP
host-705.dbo.CatalogAudit.CatalogAudit$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.BillingDetail.BillingDetail$IX_ClaimHistory	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.InvoiceDaily.InvoiceDaily$IX_RouteHistory	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.ShiftDaily.ShiftDaily$Index_599AC926_12D6_44BA	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.CustomerStatus.CustomerStatus$IX_BatchArchive	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollHistory.PayrollHistory$IX_PricingStatus	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PolicyHistory.PolicyHistory$Index_37D84771_AECE_4899	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PolicyHistory.PolicyHistory$USERID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ForecastQueue.ForecastQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PolicyDetail.PolicyDetail$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PolicyDetail.PolicyDetail$USERID	2	NONCLUSTERED			0	0	0	never	2026-01-13 16:00:00	COLD	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$ID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$IX_ShiftDaily	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.MeterQueue.MeterQueue$ID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.MeterQueue.MeterQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.CampaignSnapshot.CampaignSnapshot$M_ID	2	NONCLUSTERED			0	0	0	never	2026-01-13 15:44:15	COLD	review, then DROP
host-705.dbo.CampaignSnapshot.CampaignSnapshot$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.CampaignSnapshot.CampaignSnapshot$UMI_ID	3	NONCLUSTERED			0	0	0	never	2026-01-13 15:44:15	COLD	review, then DROP
host-705.dbo.ShipmentLine.ShipmentLine$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	never	2026-01-13 15:44:15	COLD	KEEP — primary key
host-705.dbo.ShipmentLine.ShipmentLine$UI_ID	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ShipmentLine.ShipmentLine$UserMachineID	3	NONCLUSTERED			0	0	0	never	2026-01-13 15:44:15	COLD	review, then DROP