Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Simulating memory pressure RE: Simulating memory pressure

  • September 1, 2008 at 1:20 am

    #865575

    Nicely Explained... the question needed such an explanation as all the options would have worked for the scenario but with some limitations and issues.

    But I am still confused about DROPCLEANBUFFERS / FREEPROCCACHE. The SP / Query once executed will be placed in the cache (if the memory is available). This will still happen if the memory is 512 MB. Please correct me if i am wrong...

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]