Index Usage Report — ACME-192-0-2-242
Host: 192.0.2.242
Collected: 2026-09-11T18:01:17Z
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 |
| Database | Total | Cold | Disabled | Droppable | Recommend action |
|---|---|---|---|---|---|
| METER | 59 | 23 | 0 | 26 | review the drop candidates above |
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 |
|---|---|---|---|---|
| METER.dbo.AssetArchive.AssetArchive$IX_BillingLog | 42335 | never | UNUSED | review, then DROP |
| METER.dbo.PolicyDetail.PolicyDetail$USERID | 127 | never | UNUSED | review, then DROP |
| METER.dbo.CampaignSnapshot.CampaignSnapshot$M_ID | 127 | never | UNUSED | review, then DROP |
| METER.dbo.ShipmentLine.ShipmentLine$UI_ID | 127 | never | UNUSED | review, then DROP |
| METER.dbo.ShipmentArchive.ShipmentArchive$CODEDETAIL | 1 | never | UNUSED | review, then DROP |
| METER.dbo.ShipmentArchive.ShipmentArchive$CODENAME | 1 | never | UNUSED | review, then DROP |
| METER.dbo.BatchDaily.BatchDaily$CODEBANK | 1 | never | UNUSED | review, then DROP |
| METER.dbo.BatchDaily.BatchDaily$CODENUMBER | 1 | never | UNUSED | review, then DROP |
| METER.dbo.BatchDaily.BatchDaily$CODESOCIAL | 1 | never | UNUSED | review, then DROP |
| METER.dbo.BatchDaily.BatchDaily$CODETAX | 1 | never | UNUSED | review, then DROP |
| METER.dbo.MeterMonthly.MeterMonthly$COMID | 1 | never | UNUSED | review, then DROP |
| METER.dbo.MeterMonthly.MeterMonthly$DEPTNAME | 1 | never | UNUSED | review, then DROP |
| METER.dbo.BillingLine.BillingLine$UMS_ID | 1 | never | UNUSED | review, then DROP |
| METER.dbo.CampaignLog.CampaignLog$S_GroupID | 1 | never | UNUSED | review, then DROP |
| METER.dbo.CampaignLog.CampaignLog$S_TranferID | 1 | never | UNUSED | review, then DROP |
| METER.dbo.SalesLine.SalesLine$Idle | 1 | never | UNUSED | review, then DROP |
| METER.dbo.SalesLine.SalesLine$Series_ID | 1 | never | UNUSED | review, then DROP |
| METER.dbo.PolicyHistory.PolicyHistory$USERID | 1 | never | UNUSED | review, then DROP |
| METER.dbo.TicketSnapshot.TicketSnapshot$UMS_ID | 0 | never | COLD | review, then DROP |
| METER.dbo.ShipmentQueue.ShipmentQueue$Leaveid | 0 | never | COLD | review, then DROP |
| METER.dbo.PayrollHeader.PayrollHeader$HOLIDAYID | 0 | never | COLD | review, then DROP |
| METER.dbo.PayrollHeader.PayrollHeader$Leaveid | 0 | never | COLD | review, then DROP |
| METER.dbo.PayrollDaily.PayrollDaily$DeptID | 0 | never | COLD | review, then DROP |
| METER.dbo.MODE.IX_PayrollMonthly | 0 | never | COLD | review, then DROP |
| METER.dbo.ReconcileQueue.ReconcileQueue$ID | 0 | never | COLD | review, then DROP |
| METER.dbo.MeterQueue.MeterQueue$ID | 0 | never | COLD | review, then DROP |
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 | Constr | Filt | Disabled | seeks | scans | lookups | updates | last_read | last_stats_update | State | Recommend action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| METER.dbo.InvoiceDetail.InvoiceDetail$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 10 | 0 | 3 | 2026-01-23 16:00:13 | 2026-09-05 22:00:03 | USED | KEEP — primary key | |||
| METER.dbo.StaffingHeader.StaffingHeader$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 11 | 0 | 14 | 2026-01-23 16:00:13 | 2026-09-05 22:00:03 | USED | KEEP — primary key | |||
| METER.dbo.AssetArchive.AssetArchive$IX_BillingLog | 2 | NONCLUSTERED | 0 | 0 | 0 | 42335 | never | 2026-09-11 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.AssetArchive.AssetArchive$IX_SupplierDaily | 1 | CLUSTERED | Y | Y | 0 | 1395 | 0 | 42335 | 2026-09-11 20:00:00 | 2026-09-11 22:00:03 | USED | KEEP — primary key | |||
| METER.dbo.AssetArchive.AssetArchive$id | 3 | NONCLUSTERED | 0 | 1845 | 0 | 42335 | 2026-09-12 00:35:03 | 2026-09-11 22:00:03 | USED | keep — in use | |||||
| METER.dbo.ShipmentArchive.ShipmentArchive$CODEDETAIL | 2 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.ShipmentArchive.ShipmentArchive$CODENAME | 3 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.ShipmentArchive.ShipmentArchive$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | KEEP — primary key | |||
| METER.dbo.BatchDaily.BatchDaily$CODEBANK | 2 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.BatchDaily.BatchDaily$CODENUMBER | 3 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.BatchDaily.BatchDaily$CODESOCIAL | 4 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.BatchDaily.BatchDaily$CODETAX | 5 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.BatchDaily.BatchDaily$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | KEEP — primary key | |||
| METER.dbo.MeterMonthly.MeterMonthly$COMID | 2 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.MeterMonthly.MeterMonthly$DEPTID | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | KEEP — primary key | |||
| METER.dbo.MeterMonthly.MeterMonthly$DEPTNAME | 3 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.TicketSnapshot.TicketSnapshot$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.TicketSnapshot.TicketSnapshot$UMS_ID | 2 | NONCLUSTERED | 0 | 0 | 0 | 0 | never | never | COLD | review, then DROP | |||||
| METER.dbo.BillingLine.BillingLine$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | KEEP — primary key | |||
| METER.dbo.BillingLine.BillingLine$UMS_ID | 2 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.CampaignLog.CampaignLog$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | KEEP — primary key | |||
| METER.dbo.CampaignLog.CampaignLog$S_GroupID | 2 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.CampaignLog.CampaignLog$S_TranferID | 3 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.ShipmentQueue.ShipmentQueue$Leaveid | 2 | NONCLUSTERED | 0 | 0 | 0 | 0 | never | never | COLD | review, then DROP | |||||
| METER.dbo.ShipmentQueue.ShipmentQueue$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.PayrollHeader.PayrollHeader$HOLIDAYID | 2 | NONCLUSTERED | 0 | 0 | 0 | 0 | never | never | COLD | review, then DROP | |||||
| METER.dbo.PayrollHeader.PayrollHeader$Leaveid | 3 | NONCLUSTERED | 0 | 0 | 0 | 0 | never | never | COLD | review, then DROP | |||||
| METER.dbo.PayrollHeader.PayrollHeader$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.PayrollDaily.PayrollDaily$DeptID | 2 | NONCLUSTERED | 0 | 0 | 0 | 0 | never | never | COLD | review, then DROP | |||||
| METER.dbo.PayrollDaily.PayrollDaily$IX_InvoiceStaging | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.PayrollDaily.PayrollDaily$IX_CatalogDetail | 3 | NONCLUSTERED | Y | 0 | 0 | 0 | 0 | never | never | COLD | review carefully — unique | ||||
| METER.dbo.QuotaHeader.QuotaHeader$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.CustomerHistory.CustomerHistory$Index_A53BD582_2B04_434C | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 2 | never | 2026-09-05 22:00:03 | UNUSED | KEEP — primary key | |||
| METER.dbo.MODE.IX_PayrollMonthly | 2 | NONCLUSTERED | 0 | 0 | 0 | 0 | never | never | COLD | review, then DROP | |||||
| METER.dbo.MODE.IX_CustomerLine | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.SalesLine.SalesLine$Idle | 2 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.SalesLine.SalesLine$PrimaryKey | 1 | CLUSTERED | Y | Y | 43596 | 1516 | 0 | 1 | 2026-09-11 20:00:02 | 2026-09-05 22:00:03 | USED | KEEP — primary key | |||
| METER.dbo.SalesLine.SalesLine$Series_ID | 3 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.CatalogAudit.CatalogAudit$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.BillingDetail.BillingDetail$IX_ClaimHistory | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.InvoiceDaily.InvoiceDaily$IX_RouteHistory | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.ShiftDaily.ShiftDaily$Index_599AC926_12D6_44BA | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 4 | never | 2026-09-05 22:00:03 | UNUSED | KEEP — primary key | |||
| METER.dbo.CustomerStatus.CustomerStatus$IX_BatchArchive | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.PayrollHistory.PayrollHistory$IX_PricingStatus | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.PolicyHistory.PolicyHistory$Index_37D84771_AECE_4899 | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | KEEP — primary key | |||
| METER.dbo.PolicyHistory.PolicyHistory$USERID | 2 | NONCLUSTERED | 0 | 0 | 0 | 1 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.ForecastQueue.ForecastQueue$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.PolicyDetail.PolicyDetail$PrimaryKey | 1 | CLUSTERED | Y | Y | 43597 | 10 | 0 | 127 | 2026-09-11 20:00:02 | 2026-09-05 22:00:03 | USED | KEEP — primary key | |||
| METER.dbo.PolicyDetail.PolicyDetail$USERID | 2 | NONCLUSTERED | 0 | 0 | 0 | 127 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.ReconcileQueue.ReconcileQueue$ID | 2 | NONCLUSTERED | 0 | 0 | 0 | 0 | never | never | COLD | review, then DROP | |||||
| METER.dbo.ReconcileQueue.ReconcileQueue$IX_ShiftDaily | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.MeterQueue.MeterQueue$ID | 2 | NONCLUSTERED | 0 | 0 | 0 | 0 | never | never | COLD | review, then DROP | |||||
| METER.dbo.MeterQueue.MeterQueue$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 0 | 0 | 0 | never | never | COLD | KEEP — primary key | |||
| METER.dbo.CampaignSnapshot.CampaignSnapshot$M_ID | 2 | NONCLUSTERED | 0 | 0 | 0 | 127 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.CampaignSnapshot.CampaignSnapshot$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 19593 | 24107 | 127 | 2026-09-11 20:00:02 | 2026-09-05 22:00:03 | USED | KEEP — primary key | |||
| METER.dbo.CampaignSnapshot.CampaignSnapshot$UMI_ID | 3 | NONCLUSTERED | 24108 | 22 | 0 | 127 | 2026-09-11 20:00:02 | 2026-09-05 22:00:03 | USED | keep — in use | |||||
| METER.dbo.ShipmentLine.ShipmentLine$PrimaryKey | 1 | CLUSTERED | Y | Y | 0 | 22 | 0 | 127 | 2026-09-02 09:00:02 | 2026-09-05 22:00:03 | USED | KEEP — primary key | |||
| METER.dbo.ShipmentLine.ShipmentLine$UI_ID | 2 | NONCLUSTERED | 0 | 0 | 0 | 127 | never | 2026-09-05 22:00:03 | UNUSED | review, then DROP | |||||
| METER.dbo.ShipmentLine.ShipmentLine$UserMachineID | 3 | NONCLUSTERED | 43596 | 105 | 0 | 127 | 2026-09-11 20:00:02 | 2026-09-05 22:00:03 | USED | keep — in use |