All memory used by SQL Server 2008 + Reporting Services

Posted on 2009-12-31
Last Modified: 2012-05-08
We have a database running on SQL Server 2008. On the server we were initially using 4 Gb. Because all memory was used bij SQL Server / Reporting Services, we tried to increase the amount of memory. But even with 15 Gb, all memory is used by SQL Server / Reporting Services.

This doesn't seem normal to me. How to identify the problem and how to solve the memory problem?
Question by:erwin_des
    LVL 18

    Accepted Solution

    SQL Server can take all the memory available in the box if only there is  large enough database (a database with data size bigger than the amount of RAM). It's normal because SQL Server tries to store as much data in the buffer cache as it can (to avoid physical reads from disks). To prevent SQL Server from taking all the memory for its buffer cache you can set the maximum server memory setting for the SQL Server instance. See here for details: (there is a code at the bottom of the page which you can use as an example).
    LVL 29

    Assisted Solution

    by:Kumaraswamy R

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    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…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    734 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

    22 Experts available now in Live!

    Get 1:1 Help Now