9 lines
370 B
MySQL
9 lines
370 B
MySQL
|
EXEC sp_configure 'cost threshold for parallelism', 5 --> 12 (depuis la version 1999 !)
|
||
|
|
EXEC sp_configure 'max degree of parallelism', 0 --> 0
|
||
|
|
EXEC sp_configure 'max server memory (MB)', 64000 --> 0
|
||
|
|
EXEC sp_configure 'optimize for ad hoc workloads', 1
|
||
|
|
EXEC sp_configure 'backup compression default', 1
|
||
|
|
EXEC sp_configure 'backup checksum default', 1
|
||
|
|
RECONFIGURE
|
||
|
|
|