Max number parallellisme:
default: use all processors, othtewise fill in the number of processors to be used.

Affinity mask:
Default: 0. Windows regelt the assignment over the different CPU's.
When a number is filled in SQL uses this processor for his threads.

AWE memory:
switched large memory amounts between SQL-server and the OS.

Query Governor:
specify the max period an query can run.

Compress Backup:
default is off

Optimize for Ad_Hoc workloads:
If you use the functions openrowset or opendatasource to open a remote OLEDB datasource
this option must be enabled





Saving your comment....

Naam is verplicht!
Email is verplicht!
Opmerking is verplicht!