Configuration

Configuration Instance Configuration

sql Copy

-- Memory Configuration

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'max server memory (MB)', 8192;
EXEC sp_configure 'min server memory (MB)', 2048;
RECONFIGURE;

-- Max Degree of Parallelism

EXEC sp_configure 'max degree of parallelism', 4;
RECONFIGURE;

Database Settings

sql Copy

ALTER DATABASE [YourDB]
SET RECOVERY FULL;
ALTER DATABASE [YourDB]
SET AUTO_SHRINK OFF;
ALTER DATABASE [YourDB]
SET AUTO_CREATE_STATISTICS ON;

Security Configuration

sql Copy

-- Enable SQL Authentication
USE [master]
GO
EXEC xp_instance_regwrite 
    N'HKEY_LOCAL_MACHINE',
    N'Software\Microsoft\MSSQLServer\MSSQLServer',
    N'LoginMode',
    REG_DWORD,
    2;
GO