Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computing > Windows 64bit > poor cpu performance and little memory use in W2003x64

Reply
Thread Tools

poor cpu performance and little memory use in W2003x64

 
 
=?Utf-8?B?ZGVib3JhaA==?=
Guest
Posts: n/a
 
      06-22-2006
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?
 
Reply With Quote
 
 
 
 
Admiral Q
Guest
Posts: n/a
 
      06-23-2006
"deborah" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
: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


 
Reply With Quote
 
 
 
 
=?Utf-8?B?ZGVib3JhaA==?=
Guest
Posts: n/a
 
      06-23-2006
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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> :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
>
>
>

 
Reply With Quote
 
Darrell Gorter[MSFT]
Guest
Posts: n/a
 
      06-25-2006
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==?= <(E-Mail Removed)>
<References: <(E-Mail Removed)>
<(E-Mail Removed)>
<Subject: Re: poor cpu performance and little memory use in W2003x64
<Date: Fri, 23 Jun 2006 04:31:01 -0700
<Lines: 36
<Message-ID: <(E-Mail Removed)>
<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" <(E-Mail Removed)> wrote in message
<> news:(E-Mail Removed)...
<> :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
<>
<>
<>
<

 
Reply With Quote
 
Admiral Q
Guest
Posts: n/a
 
      06-27-2006
"deborah" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
: 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" <(E-Mail Removed)> wrote in message
: > news:(E-Mail Removed)...
: > :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


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How CPU Features Affect CPU Performance Ian Front Page News 0 02-18-2010 03:28 PM
Poor, poor P&S owner learns too late... Rich Digital Photography 66 06-11-2009 04:48 AM
1 little 2 little 3 little Kennedys dale Digital Photography 0 03-23-2008 01:03 PM
Over 4GB Memory on Intel D965PLT motherboard and poor performance =?Utf-8?B?SlRURklO?= Windows 64bit 3 07-24-2007 08:04 AM
Poor reception, poor connection, and dropped signal =?Utf-8?B?dW51c3VhbHBzeWNobw==?= Wireless Networking 2 06-07-2006 12:54 AM



Advertisments