Updating table causes high processor utlization

Rated 4.34/5 based on 785 customer reviews

(You can click the CPU column header to sort the list of processes by their CPU utilization.) Make a note of which process is monopolizing the CPU time.

The information is from the February 2002 issue of Windows Web Solutions.Hello, There is no particular setting in the database that can cause CPU overload.It all depends on the hardware and also the configuration of the database.If the statistics are not collected, then basically the DB is unable to choose the right index for every execution or none, hence putting extra load on the system for full table scan.After the patchset update your DB cache is empty and collecting statistics will help in running the database to run in the way it is designed.

Leave a Reply