Post reply

CPU usage value in SqlAgent

  • November 9, 2006 at 4:54 am

    #175348

    Hi,

    when we specify the CPU usage value as 10% in SqlAgent properties to define the CPU idle condition.

    when we schedule the job to run when the CPU is idle,it is running fine.

    Can any one tell me how the Sql Serer is finding the CPU usage value(which SP or function is doing that) ? based on above condition

     

    Thanks in advance

     

     

     

     

  • November 9, 2006 at 5:38 am

    #670809

    I've never used this and can't see any good reason to use this, on the assumption that firing off jobs etc. on a period of low cpu might not actually be a good idea, imagine if it's a reindex job and a couple of minutes silence in the office for instance suddenly kicks off your jobs!!!

    I would assume it uses perfmon counters and/or the internal cpu counters

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

Viewing 2 posts - 1 through 1 (of 1 total)

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