Post reply

W2K3 EE German x64 and SQL Server 2005 Standard x64 as single Instance in an Cluster

  • January 20, 2009 at 11:42 am

    #929868

    I may not be the right person to answer this, but the first thing that comes to my mind is: Do you mean that all queries are running on one CPU, or just that the service itself is only running on one CPU?

    If it's everything on one CPU, service and queries, then it's almost certainly a problem with the CPU affinity settings. Not sure what they should be on your machine, but that's what I'd look at first.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • January 20, 2009 at 12:06 pm

    #929881

    Let's clarify something: The parallelism setting has absolutley no bearing on cpu use, all it does is allow or limit parallel plan generation.

    I seem to remember we had a post about sql server appearing to run on one core before - can't remember what the issue was. I'd check out the cpu affinity and any windows resource settings.

    The other point of course is how you are actually monitoring :- I'd be interested to know how you know which core/cpu sql server is using?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 22, 2009 at 7:58 am

    #931184

    Hello,

    with the taskmanager i can see all 16 cores of the server. Only one of them is busy nearly 100 % . Under processes in the taskmanger the highest cpu use is by the sqlserver.exe. So i think that the SQL server process is not able to use the other cores.

    Best regards

    Franz

  • January 22, 2009 at 8:02 am

    #931188

    That's definitely a CPU Affinity issue. Check your settings on that.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply