I am running two stored procedures through a VB application (the first takes 2.30 minutes, the second about 8 minutes when run in SQL server 7). When I run the first through the application the memory usage shoots up to 250 mb and when completed (about 8 minutes later) the memory usage does not fall back to its initial level (160mb instead of 90 mb). When the second is set off the memory usage shoots up to over 300 mb, and the PC groans away for about 20 minutes. What is causing this and is there any way to reset the memory usage? The PC is not doing any processing, that all happens on the server. I am puzzled why the processing takes so long and why it has such an effect on the machine. Any ideas would be appreciated.
Seosamh
Seosamh
