• Given that profiler shows no queries with large numbers of reads took away my normal response.

    Complete guesses here:

    1) someone accidentally put windows/sqlserver 32 bit on the system (yes, I have seen that happen!)

    2) the IO subsystem is completely insufficient and/or grossly misconfigured. Have you done IO stall analysis yet?

    3) did you do a wait stats analysis yet?

    Note: I have been a professional SQL Server tuner for 15 years and I pretty much never care about PLE unless it is taking a precipitous dive to 0 indicating a likely bug somewhere on the system (drivers/firmware/3rd party apps, etc).

    Speaking of professional, there really are a LOT of things that could be at play here and you could hunt and peck on a forum for days without resolution. Consider getting a good tuner to remote into the system. It could be just a matter of minutes to a few hours before the cause is isolated and corrected. Client wins, and you win by getting some mentoring to enable you to better troubleshoot the next time you come across something like this.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service