Post reply

Memory Utilization

  • April 6, 2012 at 3:15 am

    #259497

    Hello, During some operation I want to check the Memory utilization. Can I get some memory utilization details by some query/DMV like this:

    TotalAvailableMemoryUsedMemory

    -------------------------------------

  • April 7, 2012 at 9:57 am

    #1470402

    Checkout the sys.dm_os_memory_xx dmv's - there should be something in there you're after.

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

  • April 9, 2012 at 3:12 am

    #1470584

    I'ev checked a lots of them already but don't understand which values to use for checking memory pressure while running my code.

  • April 9, 2012 at 3:17 am

    #1470585

    Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

  • April 9, 2012 at 6:06 am

    #1470604

    Thanks a lot Gail. This is exactly what I was looking for. Thanks one again for sharing this link.

  • April 10, 2012 at 7:03 am

    #1471177

    try out DBCC memorystatus. It is documented online by Microsoft but not in Books Online.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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