SQL Server · index usage
Host: 192.0.2.136
Collected: 2026-10-19T18:00:31Z
Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-192-0-2-136-MSSQLLAB-1433
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 | 3 | every index on a user table |
| used | 3 | had a seek, scan or lookup |
| unused | 0 | written but never read |
| cold | 0 | never read AND never written since restart |
| disabled | 0 | ALTER INDEX ... DISABLE was run |
| droppable | 0 | nonclustered, not unique, no constraint, never read |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| QUOTATest.dbo.RouteStatus.PK_PolicySummary | 1 | CLUSTERED | Y | Y | 0 | 1338 | 0 | 1347 | 2026-10-07 10:20:34 | never | USED | KEEP — primary key | |||
| QUOTATest.dbo.PolicyStaging.PK_BookingDetail | 1 | CLUSTERED | Y | Y | 0 | 12883 | 0 | 12891 | 2026-10-07 10:29:29 | never | USED | KEEP — primary key | |||
| QUOTATest.dbo.SettlementStatus.PK_SalesArchive | 1 | CLUSTERED | Y | Y | 0 | 2660 | 0 | 2670 | 2026-10-07 10:27:55 | never | USED | KEEP — primary key |
No disabled indexes, no drop candidates and nothing fragmented.