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 |
|
afitch
Starting Member
7 Posts |
 Posted - 2008-05-13 : 22:48:25
|
| I'm having problems with SQL 2005 Express Edition exceeding the maximum memory limit. I hard set the minimum to 100 and the maximum to 500, but the server is currently using over 800MB and is causing the system to page. Has anyone had any experience with similar issues and if so how did you resolve them. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 23:57:10
|
| Anything is running beside SQL Server. |
 |
|
|
afitch
Starting Member
7 Posts |
Posted - 2008-05-14 : 13:45:37
|
| I'm not sure that I understand the question. The sqlserver.exe process is taking 300MB of memory more than the hard limit maximum server memory cap of 500MB that I set. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-14 : 13:48:13
|
| Post the output of max server memory (MB) and min server memory (MB) from sp_configure.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
afitch
Starting Member
7 Posts |
Posted - 2008-05-14 : 14:47:45
|
| max server memory (MB) 16 2147483647 512 512min server memory (MB) 0 2147483647 100 100 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-14 : 19:02:58
|
| "I hard set the minimum to 100 and the maximum to 500, but the server is currently using over 800MB and is causing the system to page."How did you know? Did you check memory counters in Perfmon. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 22:23:51
|
| >> The sqlserver.exe process is taking 300MB of memory more than the hard limit maximum server memory cap of 500MB that I set.You can't add them up to get 800mb, have to check target server memory in perfmon. |
|
|
|
afitch
Starting Member
7 Posts |
Posted - 2008-05-15 : 11:44:39
|
| Isn't the maximum server memory setting supposed to limit the sqlserver.exe process from taking any more memory than that value? If not how can I prevent it? I only have 1GB of Ram in the systems I have this running on and need to prevent SQL from taking any more than half of the physical memory. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 22:34:54
|
| Yes it is. As said, you have to check sql's memory usage in perfmon. |
|
|
|
|
|
|
SQL 2005 Exceeding Memory Limit