Solved

SQL instance limiting memory

Posted on 2011-03-03
1
389 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

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…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

630 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