Viewing Usage and Cleaning Up Memory
Studio displays real-time memory usage in the lower right corner of the Studio interface. The Studio Manager displays a more detailed view of the TDV Server memory usage and it also has a Free Unused Memory button that can invoke Garbage Collection.
The Resource Monitor displays how much Kernel Memory is being used and the degree to which Page Filing is occurring. If that number is bigger than the amount of physical memory, it means that your server is paging and performance can suffer for it. Investigate the queries being run and adjust your server memory settings accordingly.
If memory usage is high, you can release memory using the garbage collection feature. Typically, garbage collection is an automatic process.
To view usage and clean up unused memory
1. Open Studio.
2. Select the Manager tab on the left side of the screen.
3. Select Memory.
4. Determine what might be impacting your memory usage.
5. Click Free Unused Memory.