December 5, 2001 at 8:07 am
I run the vbs script which connects to the database and selects the data and sqlservr.exe using most of the server memory.
vbs script and SQLServer2000 are on separate
PCs.
Even after script stops memory usage is still the same and not dropping.
Maybe you have any solutions for this problem?
December 5, 2001 at 4:37 pm
Memory on the client or the server? I wouldnt expect server memory to drop, it just had to work to cache the data, why would it release it a few seconds later?
Andy
December 7, 2001 at 8:05 am
Memory is on the SQL Server 2000 PC.
If I run another program will SQL SERVER release some of the memory to this program?
December 7, 2001 at 12:12 pm
Can I control the cache of the SQLServer 2000?
December 7, 2001 at 1:02 pm
SQL will release memory as long as it's not configured as fixed. But that should be on the server, not the client. If you're not releasing memory on the client I'd check to see if you're setting everything to nothing in your script.
You can't really control the cache. You can dump the contents, or pin a table to keep in cache, or add more memory to boost the available cache.
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply