Post reply

SQL Server Memory usage

  • July 5, 2011 at 1:49 pm

    #253215

    What is the normal memory usage.

    I get warnings that my memory usage is high but when I check, my memory paging is low (0%) and buffer and proc cache hit look good.

    Thanks

  • July 5, 2011 at 2:14 pm

    #1348571

    Where do the warnings come from?

    Can you also provide the actual message?

    Also, assuming you are on a physical (not virtual server) what is the Available Memory In Task Manager?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • July 5, 2011 at 2:29 pm

    #1348579

    I just get the generic warnings from Idera SQL Diagnostic Manager

    1. SQL Server instance sqlprod is currently using 92.00% of the server memory.

    2. SQL Server instance sqlprod - The operating system has 98.65% of memory in use.

    The box is a VM in the cloud.

    Task Man memory:

  • July 5, 2011 at 3:06 pm

    #1348603

    This is normal when you haven't set max memory for SQL Server. SQL Server will take all of the memory you allow it.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • July 5, 2011 at 3:40 pm

    #1348623

    It's risky to run with the default SQL Server max memory setting (unlimited). Please have a look at this article: http://qa.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 6, 2011 at 2:15 am

    #1348791

    The following will set the max server memory to the value you specify in MB's

    exec sp_configure 'show advanced options', '1'

    reconfigure

    exec sp_configure 'max server memory (MB)', 'set this'

    reconfigure

    exec sp_configure 'show advanced options', '0'

    reconfigure

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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