Currently, my server is running some applications and sql server.
The system physical memory is 4GB. From task manager, i found that the memory used by sql sever is ard 1.7GB even when not in much use. Memory allocation is set to dynamically.
1. Can i change mem allocation to fixed memory? (e.g min server memory= max server memory). Will it improve performance?
2. How to derive the fixed amount of memory to set for sql server? Any suggestion on the value i should try.
3. Should the 'set working set size' be set to 1 or 0 for the above?
4. Or any suugestion to improve the memory allocation?
Thanks alot. Hope experts here can give me some guidiance.