Post reply

sql server memory

  • May 10, 2011 at 11:52 am

    #239338

    We have a sql server from task manager we can see sqlservr.exe using 8 gb memory of the total 12 gb memory.

    I know sql server will shoot up or reserve 80-90 percent of operating system, if operation system needs more, it will release to it. This is a designed behaviour.

    But how can I find out how much memory SQL server really use?

  • May 10, 2011 at 9:50 pm

    #1322728

    Use Perfmon and select the following Counters

    SQLServer:Memory Manager -- Target Server Memory (KB) -- amount of memory SQL Server wants to use

    SQLServer:Memory Manager -- Total Server Memory (KB) -- how much it is currently using

    Or you can use the following TSQL Query

    SELECT * FROM sys.dm_os_performance_counters

    WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)','Logins/sec','Logouts/sec')

    Thank You,

    Best Regards,

    SQLBuddy

  • May 10, 2011 at 10:49 pm

    #1322740

    have you defined AWE in SQL server ?

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • May 11, 2011 at 2:27 am

    #1322796

    Sorry, post in wrong discussion.

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

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