SQL Server Performance

high PF Usage on sql server 2005?

Discussion in 'Performance Tuning for DBAs' started by dba_boston, Jun 13, 2008.

  1. dba_boston Member

    One of our sql server (2005, 64 bit), I just noticed it has very high PF Usage from the window task maanger
    It showes the high PF Usage as 16 G.
    Here is the detail info:
    Does this indicate it short of the memory?
    Handles: 17034
    Threads 973
    Processes 38
    Physical Memory ( K):
    Total: 16776180
    Available: 290580
    System Cache: 360960
    Kernel Memory (K)
    Total: 198352
    Paged: 109620
    Nonpaged: 88732
    Commit Charge (K)
    Total: 1685896
    Limit: 18361240
    Peak: 16966736
  2. techbabu303 New Member

    It is good to focus your attention on COMMITED BYTES and AVAILABLE MEMORY, in your case AVAILABLE MEMORY ~ 16.7GB > COMMITED BYTES ~1.6GB so the server is healthy.
    Look at perfmon tool for these counters and compare the both.
  3. satya Moderator

    Do you see high memory usage during any query execution process?
    Are you getting any performance loss on the database server?

Share This Page