Tag Info

New answers tagged

3

The DBCC WHATIF command (also see http://devondba.blogspot.co.uk/2014/03/dbcc-optimizerwhatif.html) can be used to simulate a certain hardware configuration for the current session: dbcc OPTIMIZER_WHATIF ({property/cost_number | property_name} [, {integer_value | string_value} ]) The MemoryMBs property must be set to some value. After that it appears to ...



Top 50 recent answers are included