Pop quiz: how much memory does SQL Server 2008 R2 Standard Edition support?
If you’re like me, you’d head to Microsoft’s site and check the SQL Server edition comparison:
Looks pretty straightforward, right?
If you bought any licenses of SQL Server 2008 R2 Standard Edition, now would be a good time to call your Microsoft contacts and start asking what’s going to happen when you add memory to your servers over time. I doubt anyone will get free upgrades to Enterprise Edition, but this is definitely something I’d raise if I was negotiating a company-wide licensing agreement. If the marketing materials say “OS Maximum” and the software you sold me doesn’t support that, then give me something that will.
Note – this doesn’t mean you should only use 64GB of RAM in the server. SQL Server will only use 64GB – but you should still leave some for the operating system, file copies, backup agents, etc. I tend to use 96GB of memory (just because it’s a roundish number).