Post reply

how much memory SQL has available and SQL Server is currently using

  • May 4, 2009 at 1:55 pm

    #99681

    How to calculate or see how much memory SQL has available and SQL Server is currently using

  • May 4, 2009 at 2:01 pm

    #988353

    Use Windows Performance Monitor counters:

    SQL Server:Memory Manager>>Target Server Memory

    SQL Server:Memory Manager>>Total Server Memory

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • May 4, 2009 at 2:15 pm

    #988366

    How to get to Use Windows Performance Monitor counters?

    Thank you

  • May 4, 2009 at 2:21 pm

    #988376

    Either by using Windows Performance monitor (Start>>Control Panel>>Administrative Tools>>Performance) and finding the counters in the drop down

    OR

    select *

    from master..sysperfinfo

    where charindex('memory manager',object_name) > 0

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • May 4, 2009 at 2:22 pm

    #988380

    Continue thread here: http://www.sqlservercentral.com/Forums/Topic709588-5-1.aspx#bm709715

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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