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

Index reportsSQL Server 13ACME-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-155Oracle 2ACME-192-0-2-120 ACME-198-51-100-125PostgreSQL 1ACME-192-0-2-15-PG-5433

Host: 203.0.113.155

Collected: 2026-10-11T18:01:02Z

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 user 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.AssetArchive.AssetArchive$id	never	COLD	review, then DROP
host-705.dbo.AssetArchive.AssetArchive$IX_BillingLog	never	COLD	review, then DROP
host-705.dbo.ShipmentLine.ShipmentLine$UserMachineID	never	COLD	review, then DROP
host-705.dbo.ShipmentLine.ShipmentLine$UI_ID	never	COLD	review, then DROP
host-705.dbo.CampaignSnapshot.CampaignSnapshot$UMI_ID	never	COLD	review, then DROP
host-705.dbo.CampaignSnapshot.CampaignSnapshot$M_ID	never	COLD	review, then DROP
host-705.dbo.PolicyDetail.PolicyDetail$USERID	never	COLD	review, then DROP
host-705.dbo.MeterQueue.MeterQueue$ID	never	COLD	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$ID	never	COLD	review, then DROP
host-705.dbo.PolicyHistory.PolicyHistory$USERID	never	COLD	review, then DROP
host-705.dbo.MODE.IX_PayrollMonthly	never	COLD	review, then DROP
host-705.dbo.Machine.IX_RouteHistory	never	COLD	review, then DROP
host-705.dbo.Machine.IX_AssetMonthly	never	COLD	review, then DROP
host-705.dbo.PayrollDaily.PayrollDaily$DeptID	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$Leaveid	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$HOLIDAYID	never	COLD	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$Leaveid	never	COLD	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_TranferID	never	COLD	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_GroupID	never	COLD	review, then DROP
host-705.dbo.BillingLine.BillingLine$UMS_ID	never	COLD	review, then DROP
host-705.dbo.TicketSnapshot.TicketSnapshot$UMS_ID	never	COLD	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$DEPTNAME	never	COLD	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$COMID	never	COLD	review, then DROP
host-705.dbo.COMPANY.IX_PolicyEntry	never	COLD	review, then DROP
host-705.dbo.COMPANY.IX_CampaignResult	never	COLD	review, then DROP
host-705.dbo.COMPANY.IX_ReconcileStaging	never	COLD	review, then DROP
host-705.dbo.COMPANY.IX_ForecastArchive	never	COLD	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODENAME	never	COLD	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODEDETAIL	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	72329	74801	81403	2026-10-12 01:00:00	2026-10-10 22:00:01	USED	KEEP — primary key
CAMPAIGN.dbo.CampaignStaging.PK_SalesDetail	1	CLUSTERED	Y	Y	17	93	1	2026-09-20 12:00:39	2026-10-10 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.COMPANY.IX_ForecastArchive	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.COMPANY.IX_ReconcileStaging	3	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.COMPANY.IX_CampaignResult	4	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.COMPANY.IX_PolicyEntry	5	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.COMPANY.IX_OrdersEntry	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.Machine.IX_AssetMonthly	2	NONCLUSTERED			0	0	0	never	never	COLD	review, then DROP
host-705.dbo.Machine.IX_ClaimEntry	1	CLUSTERED	Y	Y	0	0	0	never	2026-01-14 07:36:50	COLD	KEEP — primary key
host-705.dbo.Machine.IX_RouteHistory	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.SHIFT.SHIFT$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