• GTR (3/13/2010)


    First thing here is theoretically max and min memory setting should not effect if it is 64 bit

    Why do you say that? My experience of 64-bit SQL Server is that, if anything, it is even more important to set these correctly than on 32-bit SQL Server.

    http://technet.microsoft.com/en-us/library/ms187499.aspx

    If locked pages in memory privilege is granted (either on 32-bit for AWE support or on 64-bit by itself), we recommend also setting max server memory.