• Thanks for all of your comments.

    Setting Maximum Memory Parameter is also a good option and nothing against this. However, I personally experienced that Maximum Memory Parameter is most useful when lock pages option has been enabled from Windows.

    Thanks

    Swarndeep

    http://talksql.blogspot.com