SQL Server Performance

Performance Problem-Memory

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by tfakih, May 31, 2007.

  1. tfakih New Member

    Hello Friends,

    I am using Sql Server 2005 with Windows 2003 Memory of Server is 4GB. This is a new server & database size is hardly 500MB now.

    I was monitoring Performance Monitor & found that
    SQL Server : Memory Manager
    Target Server Memory (KB) : 331680
    TotalServer Memory (KB) : 146944

    As per the theory Target Server Memory should not exceed TotalServer Memory. My server is responding very slowly.
    Why is it showing so much less TotalServer Memory?
    What I should now?
    Please guide me.

    Thanks
    Regards,
    Tfakih
  2. satya Moderator

    What is the service pack on Windows & SQL Server?

    Also confirm at what stages the server is resonding slow.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. tfakih New Member

    Windows 2003 R2 Service Pack 1
    SQL Server 2005 Service Pack 1

    Server is responding slow against Queries....even in loading Management Studio.
  4. satya Moderator

    Do you have anti-virus or anti-spyware tool installed or running on the server?

    http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx - fyi on looking into troubleshooting the issue. And http://blogs.sqlservercentral.com/blogs/brian_kelley/archive/2006/06/12/639.aspx too.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. MohammedU New Member

    In sql server 2005 sql server will not use all available/configured memory, it will be taken as needed.
    Is this dedicated sql server?
    Your db is very small... but update the statics any way...
    Run the profiler and see if there are any long running queries...
    At the same check the network issues...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  6. tfakih New Member

    I have Trend Micro -Client Server Security for SMB on my Server
    It is a dedicated SQLServer.
    There is no Network Issue as hardly 10 users r connected with this server.
  7. fabricioz New Member

    Please, check this article from microsoft. My server was experimenting the same behavior, and when I run the SysteM information tool, I saw that all the working set for the processes were the same (Trimmed) for some reason, causing exesive page faults.

    http://support.microsoft.com/kb/905865/

Share This Page