please confirm.

I thought my production server is settle under memory usages.

I did configuration as below

1. set the max memory 6GB (dedicated SQL machine), total 8 GB.

2. configured Lock page memory

(service account add to the Local Security Policy Setting, It is always required to configure at 64bit system) also which accounts can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk.

Now SQLSERVR.EXE process consuming only 89MB only in Task manager till last 4 days, as per current workload process.

Before not configured Lock page memory, that time SQLSERVR.EXE process consuming only 5.5GB and max memory setting 6GB.

thanks