USE AdventureWorks; GO EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE WITH OVERRIDE; GO EXEC sp_configure 'max degree of parallelism', 12; GO RECONFIGURE WITH OVERRIDE; GO
Change
Change Modes Database Mirroring SQL Server 2008
Incase you want to change the mode of the mirroring from High Performance to High Safety. You can do it from the command line. ALTER DATABASE SET PARTNER SAFETY OFF; Please note that SQL Server 2008 Standard Edition does not allow changing the safety level. It will throw the below error "Msg 1473, Level 16, … Continue reading Change Modes Database Mirroring SQL Server 2008