Re: Dual Processors Xeon Support

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 00:21:07 -0500

What kind of information? Standard edition or above will use multiple
processors by default. You don't have to do anything. 

-- 
Andrew J. Kelly  SQL MVP
"Charles Tam" <CharlesTam@discussions.microsoft.com> wrote in message 
news:2594534E-DF3A-448A-98DA-5D8325AEBC0C@microsoft.com...
> Hi Rgn,
>
> Could you point me to further information on Sql Server for DUAL CPU
> environment?
>
> Kind Regards
> Charles
>
> "rgn" wrote:
>
>> By default, the installation chooses all the CPUs. You can change it to 
>> use
>> only 1 CPU later.
>>
>> Gopi
>>
>> "Charles Tam" <CharlesTam@discussions.microsoft.com> wrote in message
>> news:67E77C3C-899A-47E9-AE60-EE98D32C48BC@microsoft.com...
>> > Dear SQL Server Users,
>> >
>> > How do I configure Sql Server 2000 to supports dual cpu (Xeon)?
>> >
>> > Kind Regards
>> > Charles
>>
>>
>>

Relevant Pages

  • 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)
  • Re: aspnet_wp.exe Grabs All CPU
    ... The App is a simple Get Data from SQL server (code defined, ... DS and Adaptors, using the Higher performance SQL db classes, and Stored ... Server timed out the last request, but still very high CPU usage. ... the SPROC 's name to call, with slight business rule logic where required. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: resource utilization / hardware selection
    ... SQL> set autotrace on ... Parallel query utilized the disks 100 ...
    (comp.databases.oracle.server)
  • Competition for OraPerf
    ... You are performing more than 63 SQL parses per second. ... Solid state disks help to increase the CPU time by reducing ...
    (comp.databases.oracle.server)
  • Re: High CPU Utilization on Periodic basis
    ... scheduled task) but you should leave auto grow on just in case. ... SQL Server MVP ... the total cpu utilization suddenly shoots ... >> type, since the graphs show a sudden spike, not a ramp up. ...
    (microsoft.public.sqlserver.server)