|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
12/09/2008, 18h52
|
#1 |
Messages: n/a
Hébergeur: |
Guidelines for 64 bit Max Server Memory setting
We are running SQL Server 2005 Enterprise Edition, SP2, 64 bit, with 32GB RAM.
This is a server dedicated to SQL Server, single instance, OLTP based. Is there a link that gives some guidelines as to how much memory (Max Server Memory) should be allotted to SQL Server given the above information? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums...erver/200809/1 |
|
|
12/09/2008, 21h50
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Guidelines for 64 bit Max Server Memory setting
I don't think there is such a document mainly because there are so many
things that may play a role in this. Rarely is a server ONLY running SQL Server even though it is dedicated to SQL Server. For instance you have AV software, Term services, SSIS packages, 3rd party compression tools etc. My rule of thumb is to start with 4GB free on a 32GB system and then adjust as necessary based on actual running conditions. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "cbrichards via SQLMonster.com" <u3288@uwe> wrote in message news:8a1721c001de2@uwe... > We are running SQL Server 2005 Enterprise Edition, SP2, 64 bit, with 32GB > RAM. > > > This is a server dedicated to SQL Server, single instance, OLTP based. > > Is there a link that gives some guidelines as to how much memory (Max > Server > Memory) should be allotted to SQL Server given the above information? > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums...erver/200809/1 > |
|
|
|
14/09/2008, 09h14
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Guidelines for 64 bit Max Server Memory setting
Hi
Also make sure that you granted to the account that SQL Server runs nder -Lock Page Memory local policy "cbrichards via SQLMonster.com" <u3288@uwe> wrote in message news:8a1721c001de2@uwe... > We are running SQL Server 2005 Enterprise Edition, SP2, 64 bit, with 32GB > RAM. > > > This is a server dedicated to SQL Server, single instance, OLTP based. > > Is there a link that gives some guidelines as to how much memory (Max > Server > Memory) should be allotted to SQL Server given the above information? > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums...erver/200809/1 > |
|
|
|
17/09/2008, 23h49
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Guidelines for 64 bit Max Server Memory setting
Term Services! Yikes! Dedicated SQL Server should not be running this at
all! I consumes memory that would better serve SQL Server. You don't need it, everything on the server can be managed from the client. "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:e4i8ZDRFJHA.3488@TK2MSFTNGP02.phx.gbl... > I don't think there is such a document mainly because there are so many > things that may play a role in this. Rarely is a server ONLY running SQL > Server even though it is dedicated to SQL Server. For instance you have AV > software, Term services, SSIS packages, 3rd party compression tools etc. > My rule of thumb is to start with 4GB free on a 32GB system and then > adjust as necessary based on actual running conditions. > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > > "cbrichards via SQLMonster.com" <u3288@uwe> wrote in message > news:8a1721c001de2@uwe... >> We are running SQL Server 2005 Enterprise Edition, SP2, 64 bit, with 32GB >> RAM. >> >> >> This is a server dedicated to SQL Server, single instance, OLTP based. >> >> Is there a link that gives some guidelines as to how much memory (Max >> Server >> Memory) should be allotted to SQL Server given the above information? >> >> -- >> Message posted via SQLMonster.com >> http://www.sqlmonster.com/Uwe/Forums...erver/200809/1 >> > |
|
|
|
| Outils de la discussion | |
|
|
