Post reply

installed memory(RAM)

  • November 2, 2016 at 4:18 pm

    #331706

    Good morning Experts,

    Could you please let me know if i can get the installed memory(RAM) from SSMS through a script.

  • November 4, 2016 at 9:20 am

    #1910632

    Are you meaning something like this?

    Select *

    ,dopc.cntr_value / 1024 As 'Total (MB)'

    From sys.dm_os_performance_counters dopc

    Where dopc.counter_name In ('Target Server Memory (KB)', 'Total Server Memory (KB)')

  • November 4, 2016 at 5:13 pm

    #1910744

    Yes, something like that

  • November 7, 2016 at 5:20 am

    #1910882

    You can find detailed memory information in the sys.dm_os_process_memory view.

    😎

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply