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 |
|
ramiinfo
Starting Member
2 Posts |
 Posted - 2009-10-06 : 04:48:11
|
| i'm Using SqlServer 2008 Product Version 10.0.2531.0 and Product Level SP1 After i Install This Version. i Face a big Problem.i Find That Any Action Be Done on Database Query Or Update Or Programs Connect On DataBase Make DataBase Consume alot of Memory Size After Few Times And Even after i Stop Any Actions or Programs Connect on database .Still Database Consume Alot Of Memory Size.My PC RAM Is 8 GB and DataBase Consume Approximately All The Size and never Return again to the normal case except i make restart to The Pc That Has Database.i appreciate any help |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-06 : 06:44:27
|
| Set the max memory size for the SQL Server. By default, this is set to dynamic.Try 2GB, maybe. It depends on what other applications you are running. |
 |
|
|
ramiinfo
Starting Member
2 Posts |
Posted - 2009-10-06 : 08:25:34
|
| I already set it 4 GB but the problem when the memory increase it never decrease again and this make the performance very poor. |
|
|
|
yavvie
Starting Member
46 Posts |
Posted - 2009-10-09 : 06:24:39
|
| If you solve it please write here how, we solved something similar by scheduling a restart every night... :|I heard that SQL server takes the memory and doesnt release it anymore. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-10-09 : 06:40:40
|
| Are you sure you set the Maximum Server Memory (in MB) to 4096? Remember that you need to restart the sql server service for these changes to take effect... SQL Server is designed to consume as much memory as is available to it. This makes data retrieval faster since it doesn't have to go to disk as much.- Lumbagohttp://xkcd.com/327/ |
|
|
|
|
|
|
Sql Server 2008 Memory Problem