I am having a performance issue with my SQL reporting server, when I got to the server it shows 92% memory are used in total. so I checked detail which process were using so much memory, but nothing too big, so I sum all the memory usage listed in the resource monitor, and the total number is about 600m, and my server has 4G memory. Is there any way to check where is my memory? and which process are using it? Server Information: windows 2008 R2, with File service and web Server (IIS) Roles Installed SQL 2008 r2 Database service and Reporting Service detail list for the memory usage: Image PID Hard Faults/sec Commit (KB) Working Set (KB) Shareable (KB) Private (KB) ReportingServicesService.exe 1700 0 256,300 180,640 36,792 143,848 sqlservr.exe 1512 0 246,892 117,484 16,128 101,356 McShield.exe 2304 0 101,556 49,600 3,712 45,888 explorer.exe 952 0 22,304 41,232 24,800 16,432 svchost.exe (netsvcs) 876 0 33,060 22,340 9,376 12,964 perfmon.exe 4844 0 12,160 21,580 11,340 10,240 svchost.exe (LocalServiceNetworkRestricted) 828 0 16,080 12,708 2,564 10,144 python.exe 1620 0 23,452 11,144 2,636 8,508 TrustedInstaller.exe 1228 0 7,696 13,428 6,364 7,064 lsass.exe 560 0 9,936 10,968 4,776 6,192 svchost.exe (NetworkService) 136 0 28,488 6,884 2,800 4,084 svchost.exe (LocalService) 924 0 6,920 7,944 4,380 3,564 services.exe 552 0 6,764 5,780 2,556 3,224 SQLAGENT.EXE 1096 0 24,112 6,992 4,048 2,944 taskmgr.exe 4172 0 3,308 11,408 8,560 2,848 svchost.exe (LocalSystemNetworkRestricted) 976 0 13,628 7,048 4,628 2,420 svchost.exe (RPCSS) 740 0 4,340 4,008 1,648 2,360 svchost.exe (LocalServiceNoNetwork) 628 0 8,580 3,768 1,464 2,304 vmtoolsd.exe 2428 0 7,588 4,488 2,220 2,268 sppsvc.exe 3124 0 2,824 9,040 6,892 2,148 vmtoolsd.exe 2260 0 3,828 7,532 5,404 2,128 svchost.exe (termsvcs) 3104 0 3,680 5,360 3,480 1,880 svchost.exe (DcomLaunch) 664 0 4,020 3,720 2,080 1,640 csrss.exe 660 0 2,136 5,684 4,080 1,604 VMwareTray.exe 3972 0 2,788 5,392 3,852 1,540 taskhost.exe 4912 0 2,644 5,884 4,360 1,524 sqlbrowser.exe 2128 0 10,484 3,060 1,560 1,500 lsm.exe 568 0 3,136 3,240 1,792 1,448 rdpclip.exe 3940 0 1,656 5,032 3,624 1,408 spoolsv.exe 1164 0 7,012 2,664 1,288 1,376 FrameworkService.exe 1344 0 9,728 2,664 1,296 1,368 dsmcsvc.exe 2192 0 17,068 2,180 844 1,336 winlogon.exe 4344 0 1,608 4,620 3,320 1,300 dllhost.exe 3140 0 4,304 2,132 848 1,284 dwm.exe 1416 0 1,376 4,196 3,100 1,096 svchost.exe (iissvcs) 2276 0 6,992 1,604 692 912 svchost.exe (apphost) 1216 0 5,104 1,576 700 876 csrss.exe 396 0 2,308 1,156 336 820 mfeann.exe 2420 0 2,772 1,520 736 784 snmp.exe 1380 0 4,312 1,384 604 780 sqlwriter.exe 2164 0 5,384 1,516 740 776 VsTskMgr.exe 1408 0 7,836 1,340 572 768 fdhost.exe 3292 0 3,436 1,016 444 572 shstat.exe 992 0 3,548 1,088 576 512 naPrdMgr.exe 1520 0 4,344 796 360 436 LogonUI.exe 820 0 7,396 652 220 432 dsmcad.exe 2248 0 11,104 308 36 272 conhost.exe 2096 0 1,000 444 200 244 smss.exe 248 0 460 504 268 236 conhost.exe 1640 0 916 316 112 204 conhost.exe 2060 0 940 328 128 200 msdtc.exe 3452 0 3,388 200 0 200 svchost.exe (NetworkServiceNetworkRestricted) 1632 0 1,780 192 0 192 snmp.exe 2052 0 1,076 252 80 172 EngineServer.exe 1252 0 1,148 204 36 168 watchdog.exe 1588 0 1,208 200 32 168 mfevtps.exe 1476 0 1,680 188 28 160 csrss.exe 464 0 1,656 172 16 156 fdlauncher.exe 548 0 1,372 152 0 152 winlogon.exe 488 0 1,504 160 12 148 conhost.exe 2436 0 884 164 16 148 svchost.exe (regsvc) 1660 0 964 144 0 144 conhost.exe 3312 0 940 160 16 144 wininit.exe 440 0 1,492 140 0 140 System 4 0 112 132 76 56 Total N/A N/A 998,512 629,852 205,648 424,204

I would have ask here. http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver Thanks

Hi Myousufali thanks for your reply. Since the memory usage of SQL service is normal, so I would think it should be a general issue of the Winows 2008 server R2.

Hi, SQL services are designed in such a way that it takes most of the memory of your system, so this seems normal. Thanks, Swapnil Prajapati

Hi Prajapati That part is weird, because if you take a look at the resource usage, it shows that the SQL service and Reporting service are only using the 200m memory. How can I determine the exactly memory of SQL services are used? I listed the memory usage of SQL services from the Resource Monitor: Image PID Hard Faults/sec Commit (KB) Working Set (KB) Shareable (KB) Private (KB) ReportingServicesService.exe 1700 0 256,300 180,640 36,792 143,848 sqlservr.exe 1512 0 246,892 117,484 16,128 101,356

Finally using the RAMMap tool to find out that the memory was locked by VMWare. the detail descritption please check: http://forum.sysinternals.com/rammap-driver-locked_topic23326.html