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 |
|
robacaus
Starting Member
1 Post |
 Posted - 2002-01-23 : 10:06:22
|
| SQL server in RAM is growing while I'm updating from VB, and doesn't seem to stop. Is this a database issue or a programmatic one?Rob |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-23 : 11:09:58
|
| SQL Server always tries to grab as much memory as it can until the OS starts paging. It is using this memory for caching purposes. If you want to limit the amount of memory SQL Server can grab could set MAX SERVER MEMORY option.-------------------If trainstation is a place where train stops, what's a workstation?Edited by - izaltsman on 01/23/2002 11:10:09 |
 |
|
|
|
|
|
SQL grows without shrinking when updating.