Post reply

maximum usage of cpu time.

  • May 19, 2006 at 3:35 am

    #168203

    HI,

     

    How can we use the maximum usage of cpu time for query or for a perticular task.

  • May 19, 2006 at 9:28 am

    #639037

    you can't allocate processor time. However if you work on producing a poor query without indexes I'm sure sql server will attempt to use 100% cpu

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

  • May 19, 2006 at 12:44 pm

    #639078

    You can Boost SQL Server Priority on Windows on the Processor tab in the Server Properties dialog via SEM.  Changing this setting is not usually necessary and will affect other applications, if any, on the system.

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

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