Solved

SQL instance limiting memory

Posted on 2011-03-03
1
387 Views
Last Modified: 2012-05-11
We hare having issues with some small businesses running server 2008 with SQL.  The SQL instances eat all available memory after a few days of heavy use.

In management studio, should we limit the instance or buy more ram?  Currently we have 8 gig of ram.  SQL is using 2-3 gigs per instance and the servers begin to crawl until we reboot them.

if limiting the instance is the route to take... any particular size anyone can recommend?  most these are small business offices with maybe 10 users.
0
Comment
Question by:calljk
1 Comment
 
LVL 11

Accepted Solution

by:
dodge20 earned 500 total points
ID: 35031366
Yes, you should always limit the amount of memory sql uses.
To determine how much - I estimate how much the OS needs then add about 1GB to that. I give the rest to SQL (assuming there isn't anything else running on the box).

SQL will try to cache a lot of information into memory. It will release memory when needed, but that is a slow process and it is best to leave the OS all the memory it needs.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question