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 |
|
LianaS
Starting Member
6 Posts |
 Posted - 2002-07-17 : 03:06:29
|
| Hy everybody!I have a SQL Server 2000 Developer Edition installed on a Windows 2000 Advanced server with 512 MB RAM.I have noticed that, after getting at a poin where the memory allocated to SQL Server (sqlservr.exe proccess in TaskManager ) is 413920 and finishing the process that generated this memory allocation (I verified in Entreprise Manager and the process is no longer there) , the memory is not released. At this stage the total used memory on the machine is 549432, so more than 515572 physical limit and the system is paging. As I read in Books Online, I expected the SQL SERVER to grow or shrink the buffer cache to keep free physical memory between 4 MB and 10 MB depending on server activity.What is the explanation to the situation described?Thank you! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-07-17 : 03:48:53
|
| SQL Server hold on to as much memory as it needs and does not let it go again. You can set the upper limit in the server settings in EM, but most people tend to let SQL handle it's own memory allocation as it usually runs on it's own server(it's not advisable to run anything else on the same server)...Hope this helps.PeaceRick |
 |
|
|
LianaS
Starting Member
6 Posts |
Posted - 2002-07-17 : 04:47:43
|
| When the server is using arround 400MB , the machine responds very slow to querys.I looked up in the Books Online and read :"When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical memory available. SQL Server grows or shrinks the buffer cache to keep free physical memory between 4 MB and 10 MB depending on server activity."I noticed the growth but not the shrink, and I wanted to better understand how it really works. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-17 : 07:33:50
|
| I am pretty sure SQL will only realease RAM if another app comes along that needs more and the OS asks for it....write yourself an infinate loop in vb and watch what happens to RAM allocated to SQL...(don't do that on a live box, though...)<O> |
|
|
|
LianaS
Starting Member
6 Posts |
Posted - 2002-07-18 : 04:03:59
|
| I tried something simple: launch another application on the server. The memory from SQL Server was not released.I'll try to limit the upper memory of SQL server and see how it works. |
|
|
|
|
|
|
Memory management