Solved

SQL instance limiting memory

Posted on 2011-03-03
1
385 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

816 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now