MSDE Memory Management

[SpiderBear6]

How does MSDE handle memory? I have a VB app that uses MSDE as a back end. When the user inserts a lot of records into the database, the memory usage gets up to over 1 GB. The machine doesn't actually have that much physical memory so the OS runs like a dog. After closing the app, MSDE still holds on to the memory until I physically stopped the service. Then when I start my app again and start using MSDE again, the memory usuage goes back up to over 1GB. (mind you I didn't restart the machine after I stopped the service). I know I can set the max memory for MSDE to use, but I am not sure how to set it. I am installing MSDE through merge modules and if I need to configure MSDE through my app, I use the SQLDMO dll. Has anyone else experienced similar problems?

Cheers.

 

[mrdenny]

SQL (and MSDE) will use as much memory as it thinks it needs to. Use the sp_configure procedure to change the "max server memory (MB)". The settings is in Megs.

Denny

 

[SpiderBear6]

Thanks Denny...I'll have at look at that procedure.

 

[mrdenny]

Let me know if you need anything else.

Denny