March 17, 2008 at 3:36 am
Hi
I'm currently running SQL 2005 Standard on Windows 2003 Standard server with 3.25Gb memory, I have set up two instance of SQL, the server is currently running at a constant 95% memory utilisation.
I thought SQL 2005 managed it's own memory or am I just wrong on that?
Is there a way to get the two instances to load balance the memory usage and set this to a maximum to allow the OS to have some memory to play with?
If I had one instance I'd just set the maximum memory but I don't know how it works with multiple instances.
Thanks
March 17, 2008 at 7:31 am
In and of itself 95% memory utilization is not a bad thing, unless you have excessive Fault IO or you have problems with SQL's response time.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 18, 2008 at 3:39 am
If you have multiple instances on a box, they will all compete for the available memory. None of the instances are aware of what the others are doing, so each one will all be after the most memory it can get.
SQL Server does respond to memory pressure by releasing memory. However, you should not assume SQL Server will release memory fast enough to prevent performance issues with Windows. Neither should you assume there will always be performance issues if you run multiple instances with no set limit on max memory use.
If one of the instances is for production, and the other is non-production, it makes sense to limit the memory for the non-production instance, so that the important work is not affected.
If you see a high rate of paging, or any messages in the SQL Error log or Windows Event logs that indicate that memory is overcommitted, then you should set maximum memory values for both instances.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 18, 2008 at 4:03 am
Thank you very much for your comment Ed it makes it makes me a lot happier knowing that I did the best thing by leaving it to manage itself as it's not causeing any problems appart from some alerts the server support people are getting about memory usage.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply