April 15, 2003 at 7:29 am
Has anybody come across this curious problem:
I am running SQL Server 2000 on various P3 and Celeron based PCs without any problems, except on one PC; this PC is an IBM NetVista P4 1.5GHz with 512MB RAM on Windows 2000 (with no SP's for either Win2K or SQL Server 2K).
Whenever I run a query using QA, the memory used up by QA is not released after exiting. I need to stop the Server Service Manager and then restart it, in order to release the memory (which I monitor through the Windows task manager).
Hoss
April 15, 2003 at 8:07 am
Which SQL Server version do you run in this PC? MSDE? When you quit QA, you shouldn't see process "isqlw" in task manager unless you have multiple QA running. I don't see stopping SQL service manager has something to do with it.
Edited by - Allen_Cui on 04/15/2003 08:07:18 AM
April 15, 2003 at 12:50 pm
I am running the Personal Edition. When QA exits, isqlw disappears from the task manager, but clickng on the "Performance" tab shows that the real memory used (in my case 512MB) has not been released.
This causes a massive slowing down of the system and I, sometimes, have to reboot the PC.
April 15, 2003 at 2:33 pm
isqlw takes only few MBs memory and it releases it once you close the QA. You have to check other processes/services that might hold your machine memory. Check the memory usage column to see which proceses use most of memory.
Edited by - Allen_Cui on 04/15/2003 2:46:40 PM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply