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.

Rgds
Isaac