Pei Zhu (7/6/2009)
I do not think it would be a concern for 64 bit sql instance. Correct me if I am wrong.
depends
we have a 64bit SQL server that threw up some errors and turned out to be memory and SQL grabbing too much. had to put a max memory figure and leave 4GB to the OS. we have another SQL server that also runs a java app on the same server. that server has 64GB of RAM with 32GB for SQL and the rest for the OS and the application