• Oldman@ds9 (6/22/2010)


    I've the similar Problem on by new SQL-Sever, having a lot of freee memory. I still not found a resolution.

    I realize this thread is 18 months old, but I'm doing some research on the Free Pages counter (It's gone in SQL Server 2012) and came across this post.

    As a single measure, this provides you with almost no information at all. It gives you an indication of free pages, but it doesn't tell you if you actually have pressure on memory. It can be a very low number and everything can be fine. You have to use this in combination with some of the other counters already mentioned such as page life expectancy.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning