01-15-2011 07:30 AM
How to I reduce the size of or set limits on how much memory the SQL Server can use.
My computer is DELL Latitude D630 2000MHz 2048MB 120GB (WIN XPP+) 14.1 DVDRW 10/100/1000 NIC 56 kbps 8 MB VRAM.
Please provide a solution to this problem if you have one.
Thanks
01-15-2011 07:58 AM
01-15-2011 08:00 AM
What should the settings be as for minimum and maximums?
Thanks
01-15-2011 08:04 AM
01-15-2011 08:24 AM
The SQL Server has gone as high as 1 gig at times. I have 2500 contacts. I will try your recommendation.
Thanks
01-15-2011 09:18 AM
01-15-2011 12:14 PM
01-15-2011 12:16 PM
04-14-2015 12:30 PM
Maybe you can help me. I have a similar issue.
I'm running Microsoft Small Business Server 2011 Standard Edition with 32 GB RAM.
I've set ACTDIAG Server memory to minimum 1024MB and Maximum 2048MB and I've set the release to 30 minutes.
After a day or two SQL server uses ALL avaialble memory in the server. It reaches 14GB after 2 days when we use ACT!.
I've verified in SQL Management Studio that the maximum is set to 2048MB.
If I disable the ACT! instance then SQL never allocates more than 4096MB
Why does it continue to eat up ALL memory? It causes the server to run extremely slow.
Please help.
Thank you,
Devin