SQL Server Performance Forum – Threads Archive

High memory utilization

Hi,
I have installed SQLServer in Pentium III 512 Ram. When I Started my server the utilization of SQLServer is 90 MB, but after days this utilization go to more than 200 Mb.
This is Normal? If not how to solves this problem?
I think that this is cause of the server hangs with the message "Server Is Unable to Allocate Memory from the System Paged Pool".
Thanks
Flávio

---

It represents the server is on the heavy load and what kind of memory settings were set on SQL Server? REfer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;312362 to fix the issue.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Hi,
I applied the solution previously but the problem was not resolved.

---

What kind of application is hosted to connect SQL Server?
Are there any other applications sharing the resources on SQL Server?
What are the memory settings defined fro SQL? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Also, how many users?
Database size?
OP, SQL server and sp?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

… and also collect PERFMON (SYSMON) counters for Physical disk, memory, process, processor & SQL Memory for assessment. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

SQL Server memory architecture allows you to take it the maximum memory on the box as long as there is 5-10 MB for the OS. This does not mean that SQL Server needs the memory shown in task manageer / performance monitor at given time. Also the memory is released if OS or other application on the box needs it. 200 MB on 512 MB box is fairly low. Is there any other application on the box? If there is, have you ever calculated the amount of memory needed for that application to run? You can limit the memory available to SQL Server by setting the max server memory option. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

---

Hi,
Thanks for the attention of all. As I am not expert, go to try to obtain the data and will answer in briefing. Flavio

---

Hello Flavio, When I was tunning a new application, I had the same problem, because two things:
– Anti-virus software(in this case, old version of NAV);
– W2K and SQL2K service packs (the most important is W2K service pack lastest version). How to discover this information? Find out google.com, keyword "how to determine sql server version".
http://www.google.com/search?q=how …rsion&ie=UTF-8&hl=pt&btnG=Pesquisa Google&lr= or directly
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

---

]]>