This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- FlexNet Operations
- :
- FlexNet Operations Knowledge Base
- :
- High CPU Usage during Data Transformation Job
Subscribe
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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.
No ratings