Post reply

Memory uitilization

  • October 3, 2013 at 4:06 am

    #299453

    Hi

    I asked bu one of my clients to schedule daily moinotring reports and provide cpu and memory uitilization of sql server.Now please help me how to proceed with it specially memory part

    Thanks and Regards

    Anoop pandey

  • October 3, 2013 at 4:17 am

    #1655486

    Have a look at the sys.dm_os_memory* DMVs and the memory-related counters for SQL Server in perfmon.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 4, 2013 at 10:01 pm

    #1656078

    GilaMonster (10/3/2013)

    Have a look at the sys.dm_os_memory* DMVs and the memory-related counters for SQL Server in perfmon.

    Hi gila thanks for your reply

    now i wanted to know whether i can put value of perfmon counter target memory in my report or other values to should be considered and put in in reports

    Thanks and regards

    Anoop Pandey

  • October 5, 2013 at 5:40 am

    #1656089

    Put the values that your client wants to see, it's not my report.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 5, 2013 at 10:35 pm

    #1656141

    GilaMonster (10/5/2013)

    Put the values that your client wants to see, it's not my report.

    I know its my report and client wants to know about total memory utilization by sql server.I think they are interested in whole part rather then individzual components .can you plz tell me briefly what parameters i should look for memory begin uitilized by sql server

    Regards

    Anoop

  • October 6, 2013 at 12:47 am

    #1656144

    Try checking out "MSSQL$InstanceName:Buffer Manager", "MSSQL$InstanceName:Memory Manager" and "Memory" perfmon counters. This would be a good place to start. Make sure you capture over a good period of time to get an accurate reading.

    [font="Times New Roman"]There's no kill switch on awesome![/font]

  • October 6, 2013 at 2:30 am

    #1656147

    anoop.mig29 (10/5/2013)

    can you plz tell me briefly what parameters i should look for memory begin uitilized by sql server

    I did. The memory-related perfmon counters for SQL Server (there's 4 different objects under SQL Server in perfmon that have to do with memory, all have memory or buffer in their names) and, if you want a breakdown into components, the sys.dm_os_memory* DMVs

    Have a look through them (in conjunction with Books Online if necessary) and see what matches your requirements.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

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