Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002

    Unanswered: Intel Xeon Processor Vs. INTEL Pentium III

    Hi ,
    I would like to know if some have experience with upgrade INTEL CPU on SQL 2000 DB server .

    I have SQL 2000 2* 1233 INTEL Pentium III CPU with 4 GB RAM .

    The server main task is log processing from temporary table to Fact table.

    I would like to upgrade the CPU to Intel Xeon Processor 1MB cache ~2.4 GHz .

    Intel report on ~ 100 performance improvement.

    Can someone let me know from his CPU experience what should I expect?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    It depends. You will have to run some performance monitors on your current box, to see if it is getting bogged down by a lack of CPU. If it is, then yes, the faster CPU could help. If you are more bogged down by disk access, you will see very little performance increase with the new CPUs.

    For example, suppose a process takes 10ms of cpu time, and 100ms of disk I/O time. The whole process takes 110 ms. If you get a processor that runs twice as fast, you will end up with a process that runs in 105 ms. Just under a 5% increase in performance.

    In general, if your CPU is staying up around 70 - 80%, I would go with the CPU upgrade. If it is consistently less than that, I would not bother.

  3. #3
    Join Date
    Jul 2002
    Thanks !,
    Thank , I have peeks of ~ 20 minute each hour of ~ 80-100% CPU but , I am afraid that it is caused by the SQL server processing (lock management locks for example or other ) so any better CPU will not help ??

Posting Permissions

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