Post reply

SQL Memory Consumption

  • June 13, 2016 at 10:00 am

    #314490

    I am looking for a way to easily explain SQL memory consumption to an Oracle DBA. I am also looking for a way to show allocated memory, consumed memory and who is consuming the memory in SQL. Are there any graphical tool that I can use also?

    I am currently using combination of Process Explorer and DMV, but I can't seems to explaint it right for the Oracle folks to understand it.

    Thanks,

    MC

  • June 13, 2016 at 10:05 am

    #1884709

    Glenn Berry SQL Diagnostic Scripts has some good stuff. IIRC the SQL Server Internals books may have a useful section too.

    I think there was a tool someone wrote to show some memory usage, but I can remember the name.

    dbcc memorystatus gives lots of info, but is only moderately documented.

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

  • June 13, 2016 at 10:22 am

    #1884713

    Bear in mind that the majority of SQL's memory won't belong to any session, it'll be the data cache and the plan cache

    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

  • June 13, 2016 at 1:00 pm

    #1884758

    Thanks Kevin and Gail for the information.

    Thanks,

    MC

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

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