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 |
|
roel_vz
Starting Member
16 Posts |
 Posted - 2008-04-04 : 03:28:49
|
| With SQL Server 2005, I have the problem that sqlserv.exe keeps using more and more memory. Now I did some research and found the following anwers in different places:*It seems to be the way that SQL Server works. It just uses all the memory which it can get. I have two remarks about this:1) I that is true, then why is a fresh installation of SQL Server not consuming all the memory it can get?2) After a few weeks, it consumes so much memory that the whole system (even SQL Server itself) start running very slow. I don't think that's the intended behavior?So I thought about restricting the maximum memory that SQL Server uses, but people keep saying that's not the way it should be done: SQL Server should be allowed to allocate memory dynamically.Can anyone help me with my questions?One other thing that may be of relevance: This instance is a disitributor for replication and the distribution.MDF file also seems to be increasing over time. It became much larger than the application database.Thanks in advance for replies |
|
|
djdanrt
Starting Member
15 Posts |
Posted - 2008-04-05 : 10:35:58
|
quote:
Originally posted by roel_vz
With SQL Server 2005, I have the problem that sqlserv.exe keeps using more and more memory. Now I did some research and found the following anwers in different places:*It seems to be the way that SQL Server works. It just uses all the memory which it can get. I have two remarks about this:1) I that is true, then why is a fresh installation of SQL Server not consuming all the memory it can get?2) After a few weeks, it consumes so much memory that the whole system (even SQL Server itself) start running very slow. I don't think that's the intended behavior?So I thought about restricting the maximum memory that SQL Server uses, but people keep saying that's not the way it should be done: SQL Server should be allowed to allocate memory dynamically.Can anyone help me with my questions?One other thing that may be of relevance: This instance is a disitributor for replication and the distribution.MDF file also seems to be increasing over time. It became much larger than the application database.Thanks in advance for replies
Have you allocated too much memory for the SQL and not enough left over for the server? I cant get my SQL to use more than 110mb and I have 24gig. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 22:37:40
|
| roel_vz, let sql take care of memory allocation if it's dedicated sql server. But on 64-bit machine, need leave 4gb memory for os. By the way, how often do you rebuild index or update statistics? Slowness maybe due to statistics are out of date. Regarding distribution db size, did you see any unreplicated transactions on the server? Check it in replication monitor. Also ensure replication clean up jobs are working properly.djdanrt, check response in your own thread. |
|
|
|
|
|
|
|
|
sqlserv.exe memory usage