«

I have windows 2003 Ent x64 on a server with 2 Xeon 64-bit single core MPs.
SQL Server is installed. Anything I do on the server, CPU spikes and no
memory is being used. 16Gb of memory is installed, no spike in I/O or disk
activity. I set SQL to use minimum 4Gb and nothing happened. AWE is off, PAE
is off.

Are there specific memory settings or CPU settings needed to optimize the
server?

"deborah" <> wrote in message
news:8B3C89D4-1528-45AE-8F7B-...
:I have windows 2003 Ent x64 on a server with 2 Xeon 64-bit single
core MPs.
: SQL Server is installed. Anything I do on the server, CPU spikes
and no
: memory is being used. 16Gb of memory is installed, no spike in I/O
or disk
: activity. I set SQL to use minimum 4Gb and nothing happened. AWE
is off, PAE
: is off.
:
: Are there specific memory settings or CPU settings needed to
optimize the
: server?


SQL ???? - 2k or 2k5? Do you have the x86 (32-bit) or x64 (64-bit)
version of the SQL server installed? On the processors, is
Hyperthreading on or off.

--


Star Fleet Admiral Q @ your service!

Google is your friend!
http://www.google.com

SQL 2005 Ent 64 bit. Hyperthreading off. This behavior happens even when SQL
service is stopped and I run just about anything.

"Admiral Q" wrote:

> "deborah" <> wrote in message
> news:8B3C89D4-1528-45AE-8F7B-...
> :I have windows 2003 Ent x64 on a server with 2 Xeon 64-bit single
> core MPs.
> : SQL Server is installed. Anything I do on the server, CPU spikes
> and no
> : memory is being used. 16Gb of memory is installed, no spike in I/O
> or disk
> : activity. I set SQL to use minimum 4Gb and nothing happened. AWE
> is off, PAE
> : is off.
> :
> : Are there specific memory settings or CPU settings needed to
> optimize the
> : server?
>
>
> SQL ???? - 2k or 2k5? Do you have the x86 (32-bit) or x64 (64-bit)
> version of the SQL server installed? On the processors, is
> Hyperthreading on or off.
>
> --
>
>
> Star Fleet Admiral Q @ your service!
>
> Google is your friend!
> http://www.google.com
>
>
>

Hello Deborah,
Run taskmgr.
Look under processes.
Sort by CPU and see what processes are taking the most CPU.
Thanks,
Darrell Gorter[MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
<Thread-Topic: poor cpu performance and little memory use in W2003x64
<thread-index: AcaWuIGOy1sSfzmuSn6UZtpjofLOiA==
<X-WBNR-Posting-Host: 65.6.146.147
<From: =?Utf-8?B?ZGVib3JhaA==?= <>
<References: <8B3C89D4-1528-45AE-8F7B->
<>
<Subject: Re: poor cpu performance and little memory use in W2003x64
<Date: Fri, 23 Jun 2006 04:31:01 -0700
<Lines: 36
<Message-ID: <61623065-01A3-4DAD-9D73->
<MIME-Version: 1.0
<Content-Type: text/plain;
< charset="Utf-8"
<Content-Transfer-Encoding: 7bit
<X-Newsreader: Microsoft CDO for Windows 2000
<Content-Class: urn:content-classes:message
<Importance: normal
<Priority: normal
<X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
<Newsgroups: microsoft.public.windows.64bit.general
<Path: TK2MSFTNGXA01.phx.gbl
<Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.64bit.general:36461
<NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
<X-Tomcat-NG: microsoft.public.windows.64bit.general
<
<SQL 2005 Ent 64 bit. Hyperthreading off. This behavior happens even when
SQL
<service is stopped and I run just about anything.
<
<"Admiral Q" wrote:
<
<> "deborah" <> wrote in message
<> news:8B3C89D4-1528-45AE-8F7B-...
<> :I have windows 2003 Ent x64 on a server with 2 Xeon 64-bit single
<> core MPs.
<> : SQL Server is installed. Anything I do on the server, CPU spikes
<> and no
<> : memory is being used. 16Gb of memory is installed, no spike in I/O
<> or disk
<> : activity. I set SQL to use minimum 4Gb and nothing happened. AWE
<> is off, PAE
<> : is off.
<> :
<> : Are there specific memory settings or CPU settings needed to
<> optimize the
<> : server?
<>
<>
<> SQL ???? - 2k or 2k5? Do you have the x86 (32-bit) or x64 (64-bit)
<> version of the SQL server installed? On the processors, is
<> Hyperthreading on or off.
<>
<> --
<>
<>
<> Star Fleet Admiral Q @ your service!
<>
<> Google is your friend!
<> http://www.google.com
<>
<>
<>
<

"deborah" <> wrote in message
news:61623065-01A3-4DAD-9D73-...
: SQL 2005 Ent 64 bit. Hyperthreading off. This behavior happens
even when SQL
: service is stopped and I run just about anything.
:
: "Admiral Q" wrote:
:
: > "deborah" <> wrote in message
: > news:8B3C89D4-1528-45AE-8F7B-...
: > :I have windows 2003 Ent x64 on a server with 2 Xeon 64-bit
single
: > core MPs.
: > : SQL Server is installed. Anything I do on the server, CPU
spikes
: > and no
: > : memory is being used. 16Gb of memory is installed, no spike in
I/O
: > or disk
: > : activity. I set SQL to use minimum 4Gb and nothing happened.
AWE
: > is off, PAE
: > : is off.
: > :
: > : Are there specific memory settings or CPU settings needed to
: > optimize the
: > : server?
: >
: >
: > SQL ???? - 2k or 2k5? Do you have the x86 (32-bit) or x64
(64-bit)
: > version of the SQL server installed? On the processors, is
: > Hyperthreading on or off.
: >
: > --
: >
: >
: > Star Fleet Admiral Q @ your service!
: >
: > Google is your friend!
: > http://www.google.com
: >
: >
: >

In addition to what Darrell mentions to check out, additionally
(although it may not apply), when I rolled out a new virus package
with a resident virus shield/scanner, initially I had it set to scan
every file, all the fine, regardless of whether the file checksum
had changed or not - thus a lot of my CPU was spent scanning all
files, until I reduced it to files where only they had been
changed/updated or new. Then things simmered down to normal.

--


Star Fleet Admiral Q @ your service!

Google is your friend!
http://www.google.com