Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sentinelace
Starting Member
34 Posts |
 Posted - 2011-04-01 : 08:53:21
|
| SQL all of a sudden is eating near all my memory in my server. I have 12GB and it's using 60% of the memory in the server, slowing it down. I know it is normal behavior in SQL by default. I set the max to 3500 as suggested but it's no working. Most fixes I saw was for 32 Bit as well. Can someone tell me the proper config on getting SQL to not hog all the memory? Thanks in advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-04-03 : 23:47:56
|
| You set the max memory to 3500MB? That's a little over 3 GB. What else is running on the server? You may need to restart the sql service if this is really what you want. |
 |
|
|
|
|
|
How to: Set Min/Max Memory in 2008 SQL R2 ?