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 |
|
cuthbert
Starting Member
5 Posts |
 Posted - 2007-06-17 : 20:21:06
|
| Hi,I have SQL Server 2005 running on Windows Server 2003 Standard Edition SP2.The server has 3GB of physical memory and its PF size is fixed with a 2GB min and 4 GB max.This server has only 1 database with maybe a max of about 10 concurrent db connections.Everytime after a reboot or databse restart, the PF usage slowly grows and grows until the server locks up. It appears as though the server is not releasing the RAM after is uses it... For example, right now, it is early in the morning and there is only 1 db connection but the PF usage is sitting at 1.87GB and slowly growing.Has anyone ever had this issue before or does someone know how I can resolve this issue?I would appreciate any helpCheers |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 20:28:00
|
| Is it dedicated sql server? How much memory used by sql? Why don't let OS decide PF size? |
 |
|
|
cuthbert
Starting Member
5 Posts |
Posted - 2007-06-17 : 20:35:40
|
| Hi,yes, it is a dedicated sql server and the sqlservr.exe process is using 1.7GGB (about 95% of total usage) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 22:04:29
|
| Sql server will use all available memory on the server by default. |
|
|
|
|
|
|
Page File Usage