Solved

SQL instance limiting memory

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

867 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

15 Experts available now in Live!

Get 1:1 Help Now