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 |
|
dshelton
Yak Posting Veteran
73 Posts |
 Posted - 2004-11-16 : 17:48:57
|
| Hi All,Yesterday I came across a server which had the SQL Server service taking up 1.6gb of RAM! I looked into the active processes of this server but there were no active processes running. After restarting the service the RAM dropped down to a normal level. The wierd thing is today I have the same issue! Has anyone seen a problem like this before? Or know how it can be resolved? |
|
|
dshelton
Yak Posting Veteran
73 Posts |
Posted - 2004-11-16 : 18:14:27
|
| More info on this.... the tempdb database has blown out and filled up most of the hard disk. Is it possible that SQL Server then lets tempdb allocate space on RAM or is this just with previous versions?? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-16 : 18:25:08
|
| SQL Server does not release memory unless it no longer needs it AND another process is requesting it. So what you are seeing is normal. This is why SQL Server should be on a dedicated server.Tara |
|
|
|
dshelton
Yak Posting Veteran
73 Posts |
Posted - 2004-11-16 : 18:51:52
|
| OK.How about the tempdb on RAM? does SQL Server do this dynamically or has the tempdb on RAM option been discarded totally?Dave |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-16 : 18:58:09
|
Tempdb in RAM is no longer supported. quote:
because SQL Server 2000 has been optimized for maximum performance.
Tara |
|
|
|
|
|
|
Memory Leak