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 |
|
suinan
Starting Member
3 Posts |
 Posted - 2009-12-21 : 08:49:13
|
| Hi,In the SQL management studio, I set a max.memory usage to 512MB. But when I check in Task Manager, it shows that the memory of SQL usage is still more than 512MB (around 600.000KB). Can anyone could explain to me why the SQL memory usage can exceed the max.memory usage limit. Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-12-21 : 09:33:48
|
| Have you restarted your services? What is the exact amount as 512MB is 524288KB?Guessing this is just a home-pc. |
 |
|
|
suinan
Starting Member
3 Posts |
Posted - 2009-12-22 : 02:43:07
|
| It is around 592,000KB and it is a server actually. I haven't restarted the service since I set the limit. Is it necessary to do that? Do I need to restart the computer to take effect? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-12-22 : 04:57:04
|
| No, it is not necessary, but it will only release the memory when it has finished with it. I would guess that your server is busy all the time.512MB is not a lot for a server and it will run like a dog most of the time. |
|
|
|
|
|
|
SQL 2005--- memory usage exceeds the max.limit