Check SQL Server advanced settings

check_advanced_settings.sql

-- show advanced options
-- cost threshold for parallelism
-- max degree of parallelism
-- max server memory (MB)
-- optimize for ad hoc workloads

SELECT name, description, value, value_in_use
FROM sys.configurations
WHERE configuration_id IN (518,1538,1539,1544,1581)

sp_configure 'show advanced options', 1;
GO
sp_configure 'max degree of parallelism', 4;
GO
sp_configure 'cost threshold for parallelism', 50;
GO
sp_configure 'max server memory', 4096;
GO
sp_configure 'optimize for ad hoc workloads', 1
GO
RECONFIGURE WITH OVERRIDE;
GO