Hi all,
In our SolarWinds Database, I notice that the space of the table "NetFlowFastBitStringHeap" is more than 13GB, why other tables are no more than 800MB. Can someone tell me what the "NetFlowFastBitStringHeap" is used for and can we reduce/truncate it? Is its size normal or abnormal?
Top 10 Tables by Size
Name | Size | % Size Used By Index | Total Row Count |
NetFlowFastBitStringHeap | 13.38 GB | 46.9 % | 150.63 M |
InterfaceTraffic_Hourly_20160228 | 827.38 MB | 24.2 % | 5.00 M |
AlertHistory | 583.04 MB | 14.2 % | 1.49 M |
Events | 511.84 MB | 20.7 % | 1.23 M |
APM_PortEvidence_Detail | 449.24 MB | 8.3 % | 2.00 M |
InterfaceTraffic_Daily_20160228 | 373.43 MB | 25.9 % | 2.42 M |
InterfaceErrors_Hourly_20160228 | 337.53 MB | 21.5 % | 4.95 M |
AlertLog | 329.22 MB | 7.4 % | 1.31 M |
InterfaceTraffic_Detail_20160305 | 274.63 MB | 20.8 % | 1.43 M |
InterfaceTraffic_Detail_20160304 | 269.89 MB | 21.7 % | 1.46 M |
Thanks,