• There is 4 GB left out of 128 GB total.

    here's the breakdown:

    target sql memory: 100 GB

    +

    'sqlserver.exe' memory usage on RAMMAP: 24 GB

    =

    124 GB used

    --24GB extra used on top of MAX memory(100GB) allocated for SQL Instance.