• kesavan.rv (10/26/2016)


    thanks for the reply friends..there is an another view which i got is 'virtual memory ballooning ' an option in VMware..

    If the data is being paged out of physical memory, it has to be put somewhere.

    So that goes to your swap file.

    Use min server memory to guarantee a minimum amount of memory available to the SQL Server Memory Manager for an instance of SQL Server.

    Do you have SSIS, SSAS or SSRS running on the same server?

    If so, set the Max Mem leaving a couple of GB for the OS and these services.

    Don't make the MIN and MAX Memory values the same.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]