Index Usage — ACME-192-0-2-242

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-97ACME-192-0-2-242ACME-203-0-113-155

Index Usage Report — ACME-192-0-2-242

Host: 192.0.2.242

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

Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-192-0-2-242

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	59	every index on a CatalogHistory table
used	10	had a seek, scan or lookup
unused	26	written but never read
cold	23	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	26	nonclustered, not unique, no constraint, never read

By database

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

Drop candidates (26)

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

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

All indexes (59)

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	lookups	updates	last_read	last_stats_update	State	Recommend action
host-705.dbo.InvoiceDetail.InvoiceDetail$PrimaryKey	1	CLUSTERED	Y	Y	0	10	0	3	2026-01-23 16:00:13	2026-09-12 22:00:03	USED	KEEP — primary key
host-705.dbo.StaffingHeader.StaffingHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	11	0	14	2026-01-23 16:00:13	2026-09-12 22:00:03	USED	KEEP — primary key
host-705.dbo.AssetArchive.AssetArchive$IX_BillingLog	2	NONCLUSTERED			0	0	0	42425	never	2026-09-15 22:00:03	UNUSED	review, then DROP
host-705.dbo.AssetArchive.AssetArchive$IX_SupplierDaily	1	CLUSTERED	Y	Y	0	1419	0	42425	2026-09-15 20:00:01	2026-09-15 22:00:03	USED	KEEP — primary key
host-705.dbo.AssetArchive.AssetArchive$id	3	NONCLUSTERED			0	1881	0	42425	2026-09-16 00:35:11	2026-09-15 22:00:03	USED	keep — in use
host-705.dbo.ShipmentArchive.ShipmentArchive$CODEDETAIL	2	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODENAME	3	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-12 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.BatchDaily.BatchDaily$CODEBANK	2	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODENUMBER	3	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODESOCIAL	4	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$CODETAX	5	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.BatchDaily.BatchDaily$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-12 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.MeterMonthly.MeterMonthly$COMID	2	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$DEPTID	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-12 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.MeterMonthly.MeterMonthly$DEPTNAME	3	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.TicketSnapshot.TicketSnapshot$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.TicketSnapshot.TicketSnapshot$UMS_ID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.BillingLine.BillingLine$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-12 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.BillingLine.BillingLine$UMS_ID	2	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-12 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.CampaignLog.CampaignLog$S_GroupID	2	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_TranferID	3	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$Leaveid	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollHeader.PayrollHeader$HOLIDAYID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$Leaveid	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollDaily.PayrollDaily$DeptID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollDaily.PayrollDaily$IX_InvoiceStaging	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollDaily.PayrollDaily$IX_CatalogDetail	3	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
host-705.dbo.QuotaHeader.QuotaHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	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	2	never	2026-09-12 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.MODE.IX_PayrollMonthly	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.MODE.IX_CustomerLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.SalesLine.SalesLine$Idle	2	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.SalesLine.SalesLine$PrimaryKey	1	CLUSTERED	Y	Y	43686	1540	0	1	2026-09-15 20:00:02	2026-09-12 22:00:03	USED	KEEP — primary key
host-705.dbo.SalesLine.SalesLine$Series_ID	3	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.CatalogAudit.CatalogAudit$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.BillingDetail.BillingDetail$IX_ClaimHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.InvoiceDaily.InvoiceDaily$IX_RouteHistory	1	CLUSTERED	Y	Y	0	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	4	never	2026-09-12 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.CustomerStatus.CustomerStatus$IX_BatchArchive	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollHistory.PayrollHistory$IX_PricingStatus	1	CLUSTERED	Y	Y	0	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	1	never	2026-09-12 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.PolicyHistory.PolicyHistory$USERID	2	NONCLUSTERED			0	0	0	1	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.ForecastQueue.ForecastQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PolicyDetail.PolicyDetail$PrimaryKey	1	CLUSTERED	Y	Y	43687	10	0	127	2026-09-15 20:00:02	2026-09-12 22:00:03	USED	KEEP — primary key
host-705.dbo.PolicyDetail.PolicyDetail$USERID	2	NONCLUSTERED			0	0	0	127	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$ID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$IX_ShiftDaily	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.MeterQueue.MeterQueue$ID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.MeterQueue.MeterQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.CampaignSnapshot.CampaignSnapshot$M_ID	2	NONCLUSTERED			0	0	0	127	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.CampaignSnapshot.CampaignSnapshot$PrimaryKey	1	CLUSTERED	Y	Y	0	19593	24197	127	2026-09-15 20:00:02	2026-09-12 22:00:03	USED	KEEP — primary key
host-705.dbo.CampaignSnapshot.CampaignSnapshot$UMI_ID	3	NONCLUSTERED			24198	22	0	127	2026-09-15 20:00:02	2026-09-12 22:00:03	USED	keep — in use
host-705.dbo.ShipmentLine.ShipmentLine$PrimaryKey	1	CLUSTERED	Y	Y	0	22	0	127	2026-09-02 09:00:02	2026-09-12 22:00:03	USED	KEEP — primary key
host-705.dbo.ShipmentLine.ShipmentLine$UI_ID	2	NONCLUSTERED			0	0	0	127	never	2026-09-12 22:00:03	UNUSED	review, then DROP
host-705.dbo.ShipmentLine.ShipmentLine$UserMachineID	3	NONCLUSTERED			43686	105	0	127	2026-09-15 20:00:02	2026-09-12 22:00:03	USED	keep — in use