Thank you for replay
Yes, I have enabled Lock page Memory in Local policy setting.
Now Performance Tap showing 4.55 GB after SQL services restarted on yesterday..
Sqlservr.exe using 103 MB for current working set task.
Powershell Result
-----------------
Name WorkingSetSize(MB)
---- ------------------
ccSvcHst.exe 4.5
ccSvcHst.exe 16.4
cissesrv.exe 1.8
cmd.exe 0.2
cmd.exe 0.2
cmd.exe 0.2
cmd.exe 0.2
cmd.exe 0.2
conhost.exe 0.3
conhost.exe 0.4
conhost.exe 0.4
conhost.exe 2.8
conhost.exe 4.4
conhost.exe 3.0
cpqnimgt.exe 4.8
cpqrcmc.exe 1.7
cpqteam.exe 3.8
cqmghost.exe 6.0
cqmgserv.exe 2.6
cqmgstor.exe 2.9
csrss.exe 5.8
csrss.exe 2.4
csrss.exe 0.2
dwm.exe 4.8
explorer.exe 45.1
fdhost.exe 5.6
fdlauncher.exe 3.9
hpsmhd.exe 8.6
hpsmhd.exe 0.4
hpwmistor.exe 1.1
LogonUI.exe 0.4
lsass.exe 14.4
lsm.exe 3.7
msdtc.exe 1.1
MsDtsSrvr.exe 2.9
powershell.exe 59.5
rdpclip.exe 7.0
rotatelogs.exe 0.2
rotatelogs.exe 0.4
rotatelogs.exe 0.4
rotatelogs.exe 0.2
services.exe 9.4
Smc.exe 8.0
smhstart.exe 1.2
smss.exe 0.5
snmp.exe 4.2
spoolsv.exe 8.3
SQLAGENT.EXE 19.9
sqlservr.exe 136.5
sqlwriter.exe 1.6
Ssms.exe 62.0
svchost.exe 6.3
svchost.exe 5.3
svchost.exe 1.4
svchost.exe 2.8
svchost.exe 45.6
svchost.exe 9.9
svchost.exe 2.3
svchost.exe 10.9
svchost.exe 1.9
svchost.exe 11.2
svchost.exe 5.9
svchost.exe 16.4
sysdown.exe 0.9
System 0.3
System Idle Process 0.0
taskhost.exe 6.0
vcagent.exe 5.3
wininit.exe 0.3
winlogon.exe 0.2
winlogon.exe 5.2
WmiPrvSE.exe 6.0
WmiPrvSE.exe 10.8
WmiPrvSE.exe 13.5
WmiPrvSE.exe 16.7
WmiPrvSE.exe 138.3
Top 10 memory consumer
SELECT TOP 10
type,
CAST(SUM(single_pages_kb+multi_pages_kb) / 1024.0 AS DECIMAL(10, 2)) AS [Mem, Mb]
FROM sys.dm_os_memory_clerks
GROUP BY type
ORDER BY SUM(single_pages_kb+multi_pages_kb) DESC ;
result
typeMem, Mb
CACHESTORE_SQLCP145.07
CACHESTORE_OBJCP22.57
MEMORYCLERK_SOSNODE18.99
CACHESTORE_PHDR12.68
OBJECTSTORE_SNI_PACKET10.42
MEMORYCLERK_SQLUTILITIES9.85
MEMORYCLERK_SQLSTORENG6.37
MEMORYCLERK_SQLGENERAL5.47
USERSTORE_DBMETADATA4.98
USERSTORE_SCHEMAMGR4.07