[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • Last Modified:

All memory used by SQL Server 2008 + Reporting Services

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?
2 Solutions
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: http://msdn.microsoft.com/en-us/library/ms178067.aspx (there is a code at the bottom of the page which you can use as an example).
Kumaraswamy RCommented:

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now