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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-14 : 08:43:59
|
| Desmond Ong writes "Hi, I run a mssql server 2000 and currently a database of mine is working as a push subscriber to a transactional replication publication. Every hour my sql server grabs in more memory from the OS when i view it from the OS's Task Manager. It even reaches until 500>MBs! I checked the max_memory setting and it sets to a number of 800>MBs. Then.. after i change the max_memory to 128MBs the task manager shows the consumption of memory goes to 118MBs, the memory i have currently in the server is 1GB. Everytime i reboot the sql service.. the memory comsuption is down to 20MB, but as time passes it will slowly increase.. to a huge amount again as shown in the task manager. Could this have something to do with the management AWE Memory?, i didn't set AWE in the sql server but why is it grabbing all the memory from the OS?Please advise.Thanks." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-01-14 : 09:37:46
|
| SQL Server is designed to grab as much memory as possible (as it needs it), unless you set it otherwise. You can specify the minimum and maximum amount of memory it should use through Enterprise Manager; right-click the server, choose Properties, then choose the Memory tab. |
 |
|
|
|
|
|
SQL Server Memory Consumption keep increasing.