maximum usage of cpu time.

  • HI,

     

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

  • 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/

  • 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