• Thanks

    one final clarifications, still I am not getting conclusion about LPIM setting.

    1.SQL SERVER 2008 on top of Windows 2008 enterprise edition both x86 and x64

    2.SQL SERVER 2008 R2 on top of Windows 2008 R2 enterprise edition both x86 and x64

    Which & when condition needs to be enable LPIM for both environments?