Posted by John Bell on 06/20/99 11:57

Hi

These setting will depend on what your system is doing. If you are solely
using it for SQL Server then there is little point in saving a large amount
of memory or processor for other tasks other than the OS, or if you have DTS
packages or other batch processes you would need to watch them. The exact
settings would need to be gained iteratively and monitored. Using the boost
priority for background services should have little effect if you are solely
using the system for SQL server, if it is a shared system then you could set
it, although it may have an impact when you need to access the system
quickly in an emergency. It would not only be SQL Server that gains from
setting background service priority. Depending on how many CPUs you have,
may allow you to set processor affinity, again this will depend on what your
system is doing and you could see an overall improvement in performance if
not all the CPUs are being used by SQL Server.

You may want to check out the articles and check lists on
http://www.sql-server-performance.com/articles_audit.asp

John

"dunleav1" <jmd@dunleavyenterprises.com> wrote in message
news:1157481939.310508.197940@m79g2000cwm.googlegroups.com...
> Does enabling/disabling Data Execution Prevention have a performance
> impact on SQL 2000 or SQL 2005?
>
>
> For SQL best performance - how should I configure for:
> Processor Scheduling:
> Programs or Background services
>
> Memory Usage:
> Programs or System Cache
>

[Back to original message]