RMS 2.0.2000, SQL Server 2014

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

RMS 2.0.2000, SQL Server 2014 Standard (32 GB RAM)

At times when we try to add items by copying an item in the list (111,000 items in list), headquarters manager will stop responding. It will take multiple minutes to populate the item list and then turn gray when you click on an item. This seems to happen when the amount of RAM being used by the SQL Server process begins to approach the maximum allowed.

I have the Max set on 16 GB, and as I am no expert at SQL server I'm not sure if that is appropriate or not for a 32 GB quad core server (Dell T620 about a year old).

If I restart the SQL Service or reboot the server, it will work fine for a while, until it approaches 14 GB of memory in use by the process. Is there some way to mitigate this?

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: RMS 2.0.2000, SQL Server 2014

What other processes are you running on that server, is it dedicated to just SQL Server? In Theory you could set the maximum to 80% of physical RAM if no other processes are being ran, or need memory.

Also try to keep your db file defragged. You might also need to check you log growth settings and set a good / large minimum size for the log file. Then rotate, backup, and truncate the log on a regular schedule.