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 |
|
m_saad
Starting Member
22 Posts |
 Posted - 2004-03-04 : 08:43:56
|
| Hi, I have one more question regarding SQL Server and its memory management. I know SQL Server is memory hungry and it will take as much memory provided to it and there is nothing wrong in it, but I am concerned with its sudden rush of memory consumption.I have a dedicated SQL server which has 2 GB of ram, problem is whenever I restart (for any reason) SQL service, within 10 hours after its restart available memory comes down to only 500 Mb. This server also has Full text searching on and there are websites which use this facility. Now I want to whether this sudden rush of memory consumption is normal or is this a sign of something to happen? I will be fine if available memory be 200 Mb after a month of Uptime but not within couple of days.ThanksSaad |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-04 : 12:23:30
|
| 500MB free is a lot of memory free on a SQL Server box. On my servers, the available MB gets down to around 20MB within a few hours. But that isn't a problem for us as the servers are dedicated to SQL Server. So yes this normal.Tara |
 |
|
|
m_saad
Starting Member
22 Posts |
Posted - 2004-03-04 : 13:33:33
|
Thanks mam :), I guess, now I can keep my boss quiet  |
|
|
|
|
|
|
Memory Usage