When the alarm console attempts to load the alarms it usually does not manage to load 100%. Sometimes it doesn't load any at all and you have to use the traffic light icon to hold then reload them. Sometimes it can take you 20 attempts before it eventually loads them. Alarm counts are not the same/insync in IM for total alarms, the alarm indicator subconsole window now and/or the nas Status window.
Updated nas.cfg->setup section
Added key-> get_alarms_force_wait and set the value to yes
select count(*) from nas_transaction_summary
2.6M rows
select count(*) from nas_transaction_log
17M rows
Try to configure nas so that the row count stays below 1M (moving forward).
Deactivated nas
DROP TABLE NAS_VERSION
DROP TABLE NAS_ALARMS
DROP TABLE NAS_TRANSACTION_SUMMARY
DROP TABLE NAS_TRANSACTION_LOG
DROP TABLE NAS_NOTES
DROP TABLE NAS_ALARM_NOTE
Renamed the transactionlog.db and database.db
Activated nas and alarm_enrichment
UIM database: Microsoft SQL Server 2017 Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Standard
Review and follow-> nas best practices but use judgment based on your environment
nas best practices tips and techniques
https://knowledge.broadcom.com/external/article/192089/nas-best-practices-tips-and-techniques-f.html
Guide on what probes to deactivate or delete from the Primary hub...
What probes must be running on the Primary hub post upgrade to 9.02?
https://knowledge.broadcom.com/external/article/145974/what-probes-must-be-running-on-the-prima.html
Note that the rainbow bar on the bottom of the IM window in the alarm indicator subconsole window, will not reflect the total alarm count IF rt-click 'Show invisible Alarms' is selected/enabled. If you disable it, all counts should match and in this case it did after the steps we took above.