Post reply

SQL SERVER 2005 ENTERPRISE 64 BITS MEMORY UTLIZATION

  • August 24, 2010 at 7:56 pm

    #239462

    Hi Guys,

    We have a sql instance running on SQL SERVER 2005 ENTERPRISE 64 BITS. We did not set the maximum server memory cap for memory for it.

    Our current memory utlization is 97%.

    We have a few databases running on the instance.

    How can I check which database is utilizing the most memory?

    Is it recommended to cap the memory for sql server 2005?

    thanks

  • August 24, 2010 at 11:35 pm

    #1211457

    Here is a query which will show you how memory is being used by each db.

    SELECT

    CASE

    WHEN database_id = 32767 THEN 'Resource Database'

    ELSE DB_NAME (database_id)

    END AS 'Db Name',

    COUNT(*)/128 AS 'Size in MB'

    FROM sys.dm_os_buffer_descriptors

    GROUP BY database_id

    ORDER BY database_id

    I always recommend setting max server memory as it is very easy for SQL in 64bit to cause issues by grabbing too much memory. Glenn has a nice post on here with recommended settings depending upon the amount of ram you have.

    http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

    -Jeremy

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

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