DBCC MEMUSAGE

  • In MSSQL6.5, the command provides info on memory usage, top 20 objects in buffer cache, and top 20 objects in procedure cache.

    In MSSQL2K, the command only returns info on top 20 objects in buffer cache.

    Any idea where to find the rest of the info ?

  • Refer to this in BOL

    =======================

    DBCC MEMUSAGE provided detailed reports on memory use. Removed; no longer supported or available. Remove all references of DBCC MEMUSAGE and replace with references to these Performance Monitor counters.

    Relationships are like Banks.You Invest the Principal and then get the Interest.


    He who knows others is learned but the wise one is one who knows himself.

Viewing 2 posts - 1 through 1 (of 1 total)

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