Summary

During a reporting data transformation process, high CPU usage(100%), has been observed in certain circumstances.

Symptoms

During a reporting data transformation process, high CPU usage(100%), has been observed in certain circumstances. This sometimes leads to the FNO system becoming completely unresponsive and unable to process activations.

Cause

One cause of the issue seems to be old database statistics and indexes.

Resolution

To resolve this issue, running the following command should update all the database statistics:

'EXEC sp_updatestats'

After running this command, the data transform completes quickly and no high CPU usage is observed.