9 lines
370 B
SQL
9 lines
370 B
SQL
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
|
|
|