Informational request: for 0_database_server_options memory configuration

[sm8680]

Hi TigerTeam,

For SQL Server 2008 which doesn’t have DMV sys.dm_os_windows_info DMV should @arch then default to 32 or it depends scenario for @@VERSION shows the following Microsoft SQL Server 2008 (SP4) - 10.0.6000.29 (X64) Sep 3 2014 04:11:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)

SELECT @arch = CASE WHEN @@VERSION LIKE '%<X64>%' THEN 64 WHEN @@VERSION LIKE '%<IA64>%' THEN 128 ELSE 32 END FROM sys.dm_os_windows_info WITH (NOLOCK);

I have a number of SQL Server 2008 that we have to support until we migrate off of them. I currently have an algorithm that closely matches Tibor’s from here http://sqlblog.karaszi.com/setting-max-server-memory/ I’m hoping to have 1 algorithm slightly tweaked as opposed to 2 algorithms. Please let me know your thoughts and as always I’m very appreciative.

Thanks Steven

[sm8680]

Would it make sense to add the if statement for systems that don't have sys.dm_os_windows_info

IF OBJECT_ID(N'sys.dm_os_windows_info', N'V') IS NOT NULL SELECT @arch = CASE WHEN @@VERSION LIKE '%<X64>%' THEN 64 WHEN @@VERSION LIKE '%<IA64>%' THEN 128 ELSE 32 END FROM sys.dm_os_windows_info WITH (NOLOCK); ELSE SET @arch = 32