Results 1 to 2 of 2

Thread: High CPU!

  1. #1
    Join Date
    Aug 2011

    Unanswered: High CPU!

    Does adding 200 columns to the database increase the CPU utilization even though these newly added columns are not used in 'WHERE' clause in any queries?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    My guess is that adding the 200 columns caused page overflows on just about every row. Accessing tables with lots of page overflows can cause high cpu. You should look at doing a reorg.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts