Post reply

What app is using the page file

  • February 22, 2010 at 9:45 pm

    #145310

    Hi,

    I've got SQL 2005 on Windows 2003 Server. The box has 64GB of RAM and currently 11GB is free, however around 40% of the 2GB page file is being used.

    Is there a way to find out if this is SQL Server using the page file? The service account has "lock pages in memory" right.

    Is there a way to find out which app is using the page file?

    Thanks.

  • February 22, 2010 at 10:00 pm

    #1123412

    You can try one of the sysinternals tools

    http://technet.microsoft.com/en-us/sysinternals/bb795533.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply