SQL Server 2005 memory support vs max memory setting
I've read the information provided by this link https://technet.microsoft.com/en-us/library/ms143685(v=sql.90).aspx. According to this it supports 32TB of memory but, some comments below suggest this is a typo and it supports 32GB or 512GB of memory.
If the later is true and it only supports 32GB (for the sake of my question) of memory and the SQL instance (2005 std x64/SP4) is installed on a Windows Server (2008 R2/SP1) that has 128GB of RAM installed and I set the max memory to 114GB my assumption here is that SQL Server can only use up to the 32GB of RAM. If the latter is true and it's 32TB of RAM then SQL Server will use memory up the max memory setting.
Is my thinking correct here?