Post reply

Boost SQl Server priority on Windows

  • June 14, 2004 at 8:24 am

    #108387

    In SQL Server 2000 Properties/Processor

    there is an option

    "Boost SQl Server priority on Windows"

    Shall I turn this feature on?

  • June 14, 2004 at 8:51 am

    #510303

    Yes.

  • June 14, 2004 at 8:53 am

    #510305

    But what exactly this thing does?

    Details please.

  • June 14, 2004 at 10:57 am

    #510321

    It makes the SQL Server process run with a higher priority than other processes on the computer. This will make the OS to prioretize (give more time) to SQL Server when several processes compete for the resources.

    See "priority boost option" in BOL.

    /rockmoose


    You must unlearn what You have learnt

  • June 15, 2004 at 3:18 am

    #510401

    Boost priority should only be used when the server is being used for multiple purposes (such as a web server and SQL server)

    The boost priority will only affect the SQL server when CPU usage is high, so should only be used if the server is running low on processing power.

    Chosing this option whe CPU usage is low or when there are no other services may cause SQL server to consume resources required by the operating system resulting in poor network performance, poor disk performance and difficulty shutting down applications and services.

    MVDBA

  • June 15, 2004 at 3:51 am

    #510410

    It is recommended that you run your SQL Server on a dedicated server. If so there is no reason for boosting the SQL Server processes..

  • June 19, 2004 at 12:48 pm

    #511148

    I used both options .I couldn't find great differences between checking the options or not.So I think it's safe to experiment with the option and decide what is best for you .

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

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