cancel
Showing results for 
Search instead for 
Did you mean: 

High CPU Usage during Data Transformation Job

High CPU Usage during Data Transformation Job

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.
Labels (2)
Was this article helpful? Yes No
No ratings