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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-12 : 18:33:22
|
| stephane writes "Hi,Please forgive me for my poor english. I will try to explain clearly my problem. I haver a server of 1 Go memory mainly used by SQL Server 2005 (it seems the same with SQL Server 2000). When i make bulk insert or update on a large number of data, the process SQL Server always used more and more memory, it nevers goes down. So after a few hours, the SQL Server can use as much memory as 700 Mo while the server only have 1 Go. So i have to restart the test server.When i do the same bulk insert or update with SQL Server tools (i.e. English query or server management studio) the same problem occurs.Do you have any idea about the origin of the problem ? Can i use the SQL Server option 'max server memory' to force SQL Server to better use memory ?Thanks." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-12 : 18:53:24
|
| You do not need to restart the SQL Server. There is no problem with it using that much memory. SQL Server does not release the memory if it is no longer using it UNLESS some other process needs it.Tara Kizer |
 |
|
|
|
|
|
Memory used by SQL Server always go up