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 |
|
mikezat
Starting Member
11 Posts |
 Posted - 2001-05-09 : 15:15:16
|
| Hi! I am experiencing a problem I can not resolve. I am doing a bunch of inserts(over 200000) into my SQL Server 2000. I'd rather use bcp or bulk insert, but in this case I can't. After I am done the SQL2000 does not release the memory it grabbed for several hours. I did not have patience to wait more than 12 hrs. After I stop the SQL Service service, all the memory is released.Is there anything I can do to release the memory as soon as I am done inserts? Is therea command I can invoke programmatically to do so? Am I missing smth?Any suggestions/fixes are greatly appreciated.Thanks,Mike P.S. I am doing my tests on a Pentium III MHz512 MB RDRAM SCSI-3 machine that's very fast and powerfull |
|
|
|
|
|
SQL Server 2000 not releasing memory