August 12, 2010 at 6:56 am
Hi this is interesting.
I looked at a database today, the DB is around 4gb in size, running on a physical box.
It has a single database, 8 CPU and 16Gb of memory.
Only 1 cpu is being used by SQL Server. performance is pegged at 13% ie 1 cpu in use.
This sounds like your problem, if memory was reduced the other cpus might be used.
April 6, 2011 at 1:35 am
Hi...
I'm having similiar problem with this...
My server using 4 core CPU & 8 GB memory
using windows server 2003 std edition x64
SQL Server 2005 SP 2
but why when i run long running SP, they only use 1 core CPU that peak 100%
and the other cpu is idle, max cpu usage only 25% ??
I've check the server affinity is checked & all procesor core already checked..
what's wrong with this ? why it only use 1 core procesor ?
any insight ?
April 6, 2011 at 2:16 am
Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy