High % Disk Time but low Avg. Disk Queue Length

  • Paul White (9/8/2009)


    Kwisatz78 (9/8/2009)


    How do I check whats allotted, this isn't the max server memory setting is it?

    That's what he's after, yes.

    Wow that was quick, I was just editing the post, please see above 🙂

  • Kwisatz78 (9/8/2009)


    Wow that was quick, I was just editing the post, please see above 🙂

    Likewise :laugh:

  • 😀 so are you saying I should maybe change the min server memory to 1GB? Oh this is 32bit without AWE implemented.

  • Kwisatz78 (9/8/2009)


    😀 so are you saying I should maybe change the min server memory to 1GB? Oh this is 32bit without AWE implemented.

    The min/max server memory settings relate to the minimum and maximum that SQL Server will use for buffer pool (data cache) memory. So no - not 1GB! I would set it to max = 7168MB (or maybe less).

    *BUT* you will need to enable AWE in the SQL Server configuration settings (and restart the SQL Server service) to allow SQL Server to use more than roughly 3GB RAM.

    AWE (Address Windowing Extensions) allow memory beyond 4GB to be accessed by the SQL Server you see. (4GB = maximum value you can store in 32 bits).

    At the moment, SQL Server is likely using around *2GB* memory. This is because physical memory must be mapped to virtual memory addresses to be usable. The virtual memory space is addressed by 32-bits and is therefore 4GB in size. 2GB of that space is usually reserved for Windows (that's *virtual* memory NOT physical memory). I'm sorry if that all seems complicated - it is!

    Summary:

    Enable AWE and restart the SQL Server service!

    Set max server memory as indicated.

    Set min server memory if you wish - the default of zero is usually fine too.

    Paul

  • Paul ant others - there is a great webcast about "max memory" settings: http://www.sqlbits.com/Agenda/event3/A_walk_down_memory_lane/default.aspx

  • Slava Oks' old blog is a favourite of mine for all things memory too: http://blogs.msdn.com/slavao/archive/tags/SQL+Server+Memory+Management/default.aspx

  • Hi

    Please evaluate @nalytics Performance Free Data Collector for Microsoft SQL Server &

    Windows Server, this tool can help you to solve your performance problems and get

    performance archive history information

    Regards

    support.sql@gmail.com

    @Analytics Peformance - Microsoft SQL Server & Windwos Server Data Collector

    http://www.analyticsperformance.com/

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • support.sql (11/26/2009)


    ...Please evaluate @nalytics Performance Free Data Collector for Microsoft SQL Server & Windows Server...

    You know, this kind of constant product spamming would go down a lot easier if you just tried to provide a little actual added value to the discussion first.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • RBarryYoung (12/1/2009)


    support.sql (11/26/2009)


    ...Please evaluate @nalytics Performance Free Data Collector for Microsoft SQL Server & Windows Server...

    You know, this kind of constant product spamming would go down a lot easier if you just tried to provide a little actual added value to the discussion first.

    That cannot be automated though, and thus is of no use to the spammer.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • Heh, right you are, Kevin.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 10 posts - 16 through 24 (of 24 total)

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