SQL Server Performance

Weird Perfmon counters...odd....

Discussion in 'Performance Tuning for DBAs' started by woke, Nov 12, 2003.

  1. woke New Member

    This has me stumped and I thought someone could shed some light :

    We have server with 2GB RAM installed. SQL is configured to use all of the 2GB

    From Perfmon we get :
    CPU is 0.4 %
    Cache Hit Ratio is 47%
    Total server memory is 210 MB
    Target Server memory is 1500 MB

    From Task Manager we get :
    Total Physical Memory is 2000 MB
    Available Physical Memory is 1350 MB
    Commit charge total is 483 MB
    The sqlservr.exe process shows 239.5 MB used ( other processes use another 200 MB )

    Why such screwy readings? Nothing really lines up.........

    By the way, when I installed SQL the SQL Perfmon counters didn#%92t show up so I had to manually register them then they worked.

  2. Twan New Member

    How big are the databases that are on that server? Is the server in use?
  3. satya Moderator

    DO you get any performance bottleneck, if not just ignore and make sure to maintain scheduled backups and health checks for DB.

    Satya SKJ
  4. Luis Martin Moderator

    Cache Hit Ratio = 47% sound lower to me.
    Is a development database?

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  5. woke New Member

    Hi all,

    The problem is that Target Memory, SQL should be using 1500 MB - its using way less than that. This counter tells me SQL needs 1500 MB ( which is available ) but its only using 239 MB and has the room to grow to 1500 MB.

    I double checked the readings - they are correct.

    I am not aware of any performance bottleneck. It is a prodiuction database that gets a lot of update & select hits ( 2200 users ) in the morning of each day, then settles down to mostly select queries during rest of day.

    I am a little concerned the perfmon theory & counters may not be accurate.



  6. satya Moderator

    My guess if there is no issue with current setup & performance no need to worry, just keep on moving with current maintenance activities.

    Satya SKJ
  7. thomas New Member

    Are you talking about Buffer Manager: Buffer Cache Hit Ratio, or are you talking about Cache Manager:Cache Hit Ratio? They are 2 distinct counters and measure different things.<br /><br />Are there any other applicaiton running on the server (e.g IIS)? Check the counters, Process<img src='/community/emoticons/emotion-4.gif' alt=':p' />rivate Bytes for other processes on the server and check what is using what.<br /><br />If nothing else seems to be using memeory - and you've got plenty of available memory - maybe you should try forcing SQL Server to use a larger fixed amount of memory and see what happens.<br /><br />Tom Pullen<br />DBA, Oxfam GB

Share This Page