SQL 2005 - Memory Allocation (Best Practice)? Hello, I am not in the SQL (DBA) field however I am in the infrastructure, visualization field so have a good understanding.

Q: What should the memory limits be set to for a SQL Server 2005 on a Windows 2008 64bit server with 44Gb of Memory.

I am looking for "Memory limits set by SQL" not VMware ect.

Thanks