Table Size
245.8 GB
+15.2% vs Last Month
Deadlocks
12
Last 30 Days execution window
Slow Queries
58
Averaging 2.4s execution time
Usage Frequency
Low
High Archival Priority
Table Storage Growth (GB)
Historical data size progression over the last 6 months.
Missing Indexes
[transaction_id]
CRITICAL
Missing non-clustered index detected on primary lookup field.
[created_at, status]
WARNING
Composite index recommended to improve archival query scans.
Slow Query Logs
SELECT TOP 100 * FROM...10 min ago
4.8sUPDATE transactions SET...45 min ago
3.2sDELETE FROM transactions WHERE...2 hours ago
12.5s