Re: Adding second CPU to MS SQL Server

It will be fine and SQL will pick the second CPU once it is installed with
no changes required. When installing SQL, assuming you are using per
processor licensing just make sure you select 2 processors on the licensing
screen. However, you need to do something to Windows

HOW TO: Add Support for Multiple Processors in Windows 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q234558

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"arifi" <sfarifi@xxxxxxxxxxxx> wrote in message
news:1123342307.871181.250280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello everyone.
>
> We have recently bought a dual-CPU system and will install windows 2000
> Server + MS SQL Server 2000 on it. However, when the unit arrived, it
> came with a single CPU. And we have to wait almost a month for the
> second one.
>
> Now, we do not want to wait for the CPU before taking the system
> online, so we decided to use the server as-is, and add tbe CPU when it
> arrives.
>
> The question we have is: Does MS SQL Server install or configure itself
> differently (and so run better)when installed on a system with two CPUs
> in place ? Or is it the same with the single cpu installation and
> Windows will happily use the second CPU after it arrives ?
>
> Are there any licensing issues to look for when installing on a single
> CPU and then adding the second one ?
>
> Many thanks in advance
> -arifi
>


.

Relevant Pages

  • Re: Multiprocessor for SBS?
    ... running to use a second CPU. ... Having said that, unless you are running SQL apps, have more than 30 ... > a) It gains no performance out of that, only individual programs, that are ...
    (microsoft.public.windows.server.sbs)
  • Re: Would a 2nd processor really be a waste of time???? help
    ... > buy another processor and more ram, however this is what one supplier ... > Your server has only 1 processor. ... installation including changing the bios settings and installing the smp ... The second cpu will probably help ...somewhat. ...
    (comp.unix.sco.misc)
  • Re: Unable to reinstall SBS Monitoring
    ... Uninstall Windows SBS 2003 R2 components". ... they ask to see "Installing the Windows Small Business ... Rerun Setup, and retry installing ... B5CA-19397244DCFD})of sql setup at Software\Microsoft\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to reinstall SBS Monitoring
    ... but it's possible the MSDE instance for the monitoring database did not remove the registration from the registry and when you reinstall it it finds the key and it can't proceed. ... they ask to see "Installing the Windows Small Business ... Rerun Setup, and retry installing ... B5CA-19397244DCFD})of sql setup at Software\Microsoft\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Performance problems -- need guidance on scaling
    ... So we're now CPU ... I have read that putting the catalog and SQL table on separate RAID ... Our current server will support only a single CPU. ...
    (microsoft.public.sqlserver.fulltext)