Memory utilization on the processes RRS feed

  • Question

  • Hello Team,

    Iam from the SQL team, wanted to know one small information.

    I have allocated maxmemory for the sql server to 8GB out of 12GB(consider ex) -the exe is sqlservr.exe.

    My question is that if windows gets starts up, how I can identify how much memory took for My sqlservr.exe  note iam not talking about the sql level instead consider how each processes will use memory from the OS & how we can identify this.

    with performance counter -if so what counters should be set (or) processesmonitor(or) any other information is appreciated.

    Regards, S_NO "_"

    • Edited by S_NO Wednesday, May 23, 2018 4:05 PM typo
    • Moved by Stanly Fan Tuesday, May 29, 2018 6:49 AM
    Wednesday, May 23, 2018 4:04 PM

All replies

  • You can get the used memory with PerformanceCounter.CounterName = "Working Set - Private"
    Wednesday, May 23, 2018 4:12 PM