September 8, 2009 at 7:19 am
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 🙂
September 8, 2009 at 7:22 am
Kwisatz78 (9/8/2009)
Wow that was quick, I was just editing the post, please see above 🙂
Likewise :laugh:
September 8, 2009 at 7:34 am
😀 so are you saying I should maybe change the min server memory to 1GB? Oh this is 32bit without AWE implemented.
September 8, 2009 at 7:43 am
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
September 8, 2009 at 10:41 am
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
September 8, 2009 at 3:17 pm
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
November 26, 2009 at 9:34 pm
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
@Analytics Peformance - Microsoft SQL Server & Windwos Server Data Collector
December 1, 2009 at 2:33 pm
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]
December 1, 2009 at 2:39 pm
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
December 1, 2009 at 3:03 pm
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