Post reply

CPU allocation for SQL Server 2005

  • January 2, 2012 at 9:19 am

    #248379

    Hi,

    How can I check the CPU allocation for SQL Server process?

    Thanks in advance.

  • January 2, 2012 at 9:29 am

    #1427448

    Performance monitor. Process(sqlservr.exe) %processor time.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 2, 2012 at 9:42 am

    #1427452

    Hi Gail,

    If check %processortime for SQL Server instance it shows average 80-90 but at the same time if I check %processortime for total is shows average 40-50. If one process like sqlserver showing 80-90% of processor then how total %processorTime can be 40-50%

    I am surprised please correct me if I am wrong.

    Thanks in advance

  • January 2, 2012 at 9:47 am

    #1427453

    Your server has either two single core processors or a single dual core and you're using Windows Server 2003 or below?

    Depending on the version of windows, the % processor under process can be the percentage of one processor, but the Processor(_Total)\% Processor Time is the percentage of the total

    http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/70f48b01-9f41-42c6-8221-946e2513e4b4/

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 2, 2012 at 9:59 am

    #1427456

    Hi Gail, My OS is 64bit Windows server 2008 R2 Ent. it means If I have 2 processors this 80-90 value should be devided by 2. And final value would be 40-45.

    Please correct me if I am wrong.

    Thanks in advance.

  • January 2, 2012 at 10:14 am

    #1427460

    Have a read through that thread. I can't remember how it is calculated/displayed on 2008 R2.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 2, 2012 at 10:17 am

    #1427461

    Ok, Thanks for help.

Viewing 7 posts - 1 through 6 (of 6 total)

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