Friday, February 10, 2012

Boosting SQL Server Priority on Windows

If I dedicate a Win 2003 box to only SQL Server, does it make sense to boost
sql server priority on the box?
John
If it is the only thing on the box then you shouldn't need it. I have seen
this setting hurt more than help in most cases. I would leave it at the
default unless you know for sure you need it.
Andrew J. Kelly SQL MVP
"JT" <Jthayer@.online.nospam> wrote in message
news:1FDFA76C-D8C8-4C48-BDD3-C8165DC0752D@.microsoft.com...
> If I dedicate a Win 2003 box to only SQL Server, does it make sense to
> boost
> sql server priority on the box?
> --
> John

No comments:

Post a Comment