Bloated NAS_TRANSACTION_LOG table

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We had an alarm storm. After which it looks like the NAS_TRANSACTION_LOG has been enlarged drastically.

Environment

Release : 20.3

Component : UIM - DATA_ENGINE

Resolution

-run the following command in MS SQL Server Management Studio

ALTER table nas_transaction_log REBUILD