SQL Server Performance

performance counters...

Discussion in 'General DBA Questions' started by ramkumar.mu, May 22, 2006.

  1. ramkumar.mu New Member

    Do we have any benchmark values for the following counters...

    SQLServer Locks: Lock Timeouts
    SQLServer Access Manager: Full Scans
    System: Processor Queue Length
    SQLServer Databases: Log Growths
    Memory: Page Faults
    Target server memory
    Total Server memory

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  2. satya Moderator

  3. ramkumar.mu New Member

    If my Total Server memory and target server memory values are same, does that mean a memory bottleneck???

    I have values likes...

    counter avg min max value
    -------------------------------------------------
    Target Server Memory164116391642
    Total Server Memory164116391642


    does this mean that i have a memory bottleneck?

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  4. satya Moderator

  5. ramkumar.mu New Member

    no performance issues.,in one of the articles in SSP, i read that...<br /><br />[if the SQLServer:Memory Manager: Total Server Memory (KB) counter is more or equal than the SQLServer:Memory Manager: Target Server Memory (KB) counter, this indicates that SQL Server may be under memory pressure and could use access to more physical memory.] <br /><br />And, my DBA said that never in a perfmon, the Tot SM would be shown greater that target SM. and, if it equal then it blindly means it needs more memory.<br /><br />I was hoping to get a proof to shut his mouth [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."
  6. satya Moderator

    Check what kind of other applications are on SQL server that are hungry for Memory. I would agree it is not a problem if there is difference in the performance over a period of time.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. ramkumar.mu New Member

    The machine is dedicated for SQL Server. the total memory is 2 GB

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."

Share This Page