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 |
|
jstormoen
Starting Member
30 Posts |
 Posted - 2007-07-18 : 12:43:03
|
| We have a server that after reboot an app runs great but within 4 hours the reports run at 4 times the speed ? The server is Win 2003 Enterprise running Sql 2000 enterprise sp4 - SQL instance has 7G allocated box total is 16G - also has /pae switch for startup.All I can find on the server is that after reboot the sql service is using 200M of memory but this starts climbing until it hits about 1.7G never giving anything back.We are perplexed - everything looks normal as far as queueing, other memory Looking for ideas or anything ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-18 : 12:47:54
|
| That is normal for memory. SQL Server does not release any memory unless it no longer needs it and some other process is needing it. SQL Server is a memory hog, plain and simple.You'll need to run SQL Profiler when the queries slow down to determine what is going on.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-18 : 17:40:59
|
| If you don't enable awe in sql server, sql can't use memory beyond 4gb no matter how much you allocated. |
|
|
|
|
|
|
Memory issues ?