Physical memory for OS

Question

We have a windows server 2003 ent sp2 with SQL 2000 . The server has 16 Gbs memory ram. SQL could set a limit of memory to 13 Gbs of ram.

Some cases get log in event viewer that memory is high consumed. Does 3 Gbs for OS and another processes is enough for it?

Answer 1

A good practice is to use the Performance Monitor and get some measures.
Based on facts it is easier to fine-tune the server.
Maybe this is helpful:
https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-memory-usage?view=sql-server-ver15

Without having any detailed information about the "other processes" running in the server and the SQL Server details I would say 3 GB isn't that much. Maybe it would make sense to go for 12 GB for SQL Server and 4 GB for OS and other processes. But if the server is running smooth and performance is ok for everything/everyone, it's always an option for "never touch a running system" ;-)

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Hi anonymous user

Check with the below url's it will help your issue.

how to get OS available memory & total memory in sql server 2005 & 2000

SQL Server 2000 - Memory Management - Fixed / Dynamic

If a post helps to resolve your issue, please click the Accept the answer and Click Answered Vote as helpful . By marking a post as Answered and/or Helpful, you help others find the answer faster.