Home Forums SQL Server 2005 Administering sqlservr.exe process only growing to 125Mb on very busy system - why ? RE: sqlservr.exe process only growing to 125Mb on very busy system - why ?

  • December 18, 2012 at 3:33 am

    #1569448

    It's this version

    Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86) Mar 25 2011 13:50:04 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    The VM has 6Gb or RAM with SQL capped at 4GB

    The memory objects i'm lookin at are pages /sec and page faults/sec

    page faults/sec is spiking up to 15000 - seems very high.

    And advise on improving the situation is much appreciated 🙂