Professional Web Applications Themes

CPU Spin on dual Xeon CPU's. - Microsoft SQL / MS SQL Server

Hi all, I have installed Windows 2000 and SQL Server 2000 (both fully updated) on a dual-CPU Xeon Dell 2650, but I am getting very strange behaviour from SQL Server. When SQL Server starts CPU utilization jumps straight to 100%, albeit SQL is under no load whatsoever -- if I stop SQL Server or set it to run in a single CPU utilization comes back to normal again. I have looked on Google and there are some sugestions I need to update my ACPI driver with a Dell provided one, but Dell support does not seem to agree! Any sugestions ...

  1. #1

    Default CPU Spin on dual Xeon CPU's.

    Hi all,

    I have installed Windows 2000 and SQL Server 2000 (both fully
    updated) on a dual-CPU Xeon Dell 2650, but I am getting very strange
    behaviour from SQL Server.

    When SQL Server starts CPU utilization jumps straight to 100%,
    albeit SQL is under no load whatsoever -- if I stop SQL Server or set
    it to run in a single CPU utilization comes back to normal again.

    I have looked on Google and there are some sugestions I need to
    update my ACPI driver with a Dell provided one, but Dell support does
    not seem to agree!

    Any sugestions will be most welcome since I am kind of stuck...

    Thanks!

    Best Regards,

    --Nuno.
    Nuno Guest

  2. #2

    Default Re: CPU Spin on dual Xeon CPU's.

    Sounds like the slammer virus: http://www.aspfaq.com/show.asp?id=2440 SQL
    Slammer info

    --

    Andrew J. Kelly
    SQL Server MVP


    "Nuno Leitao" <co.uk> wrote in message
    news:google.com... 


    Andrew Guest

  3. #3

    Default Re: CPU Spin on dual Xeon CPU's.

    Hi,
     

    Yes -- I'm on SQL Server SP3a and Windows 2000 SP4.

    Thanks.

    --Nuno.
    Nuno Guest

  4. #4

    Default Re: CPU Spin on dual Xeon CPU's.

    Sorry I missed the part where you stated it goes back to normal when you
    only use 1 processor. While I have not seen any issues such as this with
    multiple processors you may consider giving MS PSS a call if you can't find
    anyone with a fix. They can at least help to track it down and if it is a
    driver they can give you some backup for when Dell say's no<g>

    http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
    http://www.mssqlserver.com/faq/general-pss.asp MS PSS

    --

    Andrew J. Kelly
    SQL Server MVP


    "Nuno Leitao" <co.uk> wrote in message
    news:google.com... 
    >
    > Yes -- I'm on SQL Server SP3a and Windows 2000 SP4.
    >
    > Thanks.
    >
    > --Nuno.[/ref]


    Andrew Guest

Similar Threads

  1. flashpaper with the new pro mac dual-core Xeon
    By skowhegan in forum Macromedia Contribute General Discussion
    Replies: 2
    Last Post: January 25th, 09:19 PM
  2. Dual mail delivery from scheduled task on dual-instanceCFMX7 Enterprise system
    By imag_je in forum Coldfusion Server Administration
    Replies: 2
    Last Post: November 17th, 10:59 AM
  3. HOWTO spin in a hexagon button
    By Stolle in forum Macromedia Flash
    Replies: 3
    Last Post: October 5th, 02:50 PM
  4. x86 Hardware-Single P4/800 FSB or Dual Xeon 533 FSB?
    By FSICorporate in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 11
    Last Post: August 15th, 10:04 PM
  5. Dual Xeon Linux vs. dual G5 : Where can I find direct speed comparison?
    By Jim Kroger in forum Mac Applications & Software
    Replies: 75
    Last Post: August 6th, 06:46 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139