SQL Server Performance Forum – Threads Archive
Performance Problem-Memory
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 thatSQL 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
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.
Windows 2003 R2 Service Pack 1
SQL Server 2005 Service Pack 1 Server is responding slow against Queries….even in loading Management Studio.
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.
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.
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.
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/
]]>