|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
20/08/2008, 07h21
|
#1 |
Messages: n/a
Hébergeur: |
AWE SQL 2005 / 8Gb RAM / 32bit
I have a Dell 2950 running Windows 2003 Enterprise Edition with a
MD1000 attached to it with RAID10. SQL version is Standard. The system has 8Gb of RAM and I am wondering how to utilize memory in the most efficient manner. Any would be appreciated. Thanks |
|
|
20/08/2008, 07h36
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: AWE SQL 2005 / 8Gb RAM / 32bit
Hi
Is it a cluster? sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 RECONFIGURE GO sp_configure 'max server memory', 6144 RECONFIGURE "Chowsman" <Chowsman@gmail.com> wrote in message news:99c0f856-a551-44ca-986c-f5487caf6280@z11g2000prl.googlegroups.com... >I have a Dell 2950 running Windows 2003 Enterprise Edition with a > MD1000 attached to it with RAID10. SQL version is Standard. The > system has 8Gb of RAM and I am wondering how to utilize memory in the > most efficient manner. > > Any would be appreciated. Thanks |
|
|
|
20/08/2008, 07h40
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: AWE SQL 2005 / 8Gb RAM / 32bit
On Aug 19, 10:36 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
> Hi > Is it a cluster? > > sp_configure 'show advanced options', 1 > RECONFIGURE > GO > sp_configure 'awe enabled', 1 > RECONFIGURE > GO > sp_configure 'max server memory', 6144 > RECONFIGURE > > "Chowsman" <Chows...@gmail.com> wrote in message > > news:99c0f856-a551-44ca-986c-f5487caf6280@z11g2000prl.googlegroups.com... > > >I have a Dell 2950 running Windows 2003 Enterprise Edition with a > > MD1000 attached to it with RAID10. SQL version is Standard. The > > system has 8Gb of RAM and I am wondering how to utilize memory in the > > most efficient manner. > > > Any would be appreciated. Thanks It is not a cluster, stand alone server. |
|
|
|
20/08/2008, 07h43
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: AWE SQL 2005 / 8Gb RAM / 32bit
On Aug 19, 10:40 pm, Chowsman <Chows...@gmail.com> wrote:
> On Aug 19, 10:36 pm, "Uri Dimant" <u...@iscar.co.il> wrote: > > > > > Hi > > Is it a cluster? > > > sp_configure 'show advanced options', 1 > > RECONFIGURE > > GO > > sp_configure 'awe enabled', 1 > > RECONFIGURE > > GO > > sp_configure 'max server memory', 6144 > > RECONFIGURE > > > "Chowsman" <Chows...@gmail.com> wrote in message > > >news:99c0f856-a551-44ca-986c-f5487caf6280@z11g2000prl.googlegroups.com... > > > >I have a Dell 2950 running Windows 2003 Enterprise Edition with a > > > MD1000 attached to it with RAID10. SQL version is Standard. The > > > system has 8Gb of RAM and I am wondering how to utilize memory in the > > > most efficient manner. > > > > Any would be appreciated. Thanks > > It is not a cluster, stand alone server. I am assuming here that this is run on the 'master' database? |
|
|
|
20/08/2008, 08h46
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: AWE SQL 2005 / 8Gb RAM / 32bit
Yes. For more deatils please refer BOL
"Chowsman" <Chowsman@gmail.com> wrote in message news:7f7d9b8d-e1a9-4c89-8709-c4832f62d769@i24g2000prf.googlegroups.com... > On Aug 19, 10:40 pm, Chowsman <Chows...@gmail.com> wrote: >> On Aug 19, 10:36 pm, "Uri Dimant" <u...@iscar.co.il> wrote: >> >> >> >> > Hi >> > Is it a cluster? >> >> > sp_configure 'show advanced options', 1 >> > RECONFIGURE >> > GO >> > sp_configure 'awe enabled', 1 >> > RECONFIGURE >> > GO >> > sp_configure 'max server memory', 6144 >> > RECONFIGURE >> >> > "Chowsman" <Chows...@gmail.com> wrote in message >> >> >news:99c0f856-a551-44ca-986c-f5487caf6280@z11g2000prl.googlegroups.com... >> >> > >I have a Dell 2950 running Windows 2003 Enterprise Edition with a >> > > MD1000 attached to it with RAID10. SQL version is Standard. The >> > > system has 8Gb of RAM and I am wondering how to utilize memory in the >> > > most efficient manner. >> >> > > Any would be appreciated. Thanks >> >> It is not a cluster, stand alone server. > > I am assuming here that this is run on the 'master' database? |
|
|
|
20/08/2008, 17h08
|
#6 |
|
Messages: n/a
Hébergeur: |
Re: AWE SQL 2005 / 8Gb RAM / 32bit
You can run sp_configure from any database. It allows you to change
server-wide properties. It is well documented. -- HTH Kalen Delaney, SQL Server MVP www.InsideSQLServer.com www.SQLTuners.com "Chowsman" <Chowsman@gmail.com> wrote in message news:7f7d9b8d-e1a9-4c89-8709-c4832f62d769@i24g2000prf.googlegroups.com... > On Aug 19, 10:40 pm, Chowsman <Chows...@gmail.com> wrote: >> On Aug 19, 10:36 pm, "Uri Dimant" <u...@iscar.co.il> wrote: >> >> >> >> > Hi >> > Is it a cluster? >> >> > sp_configure 'show advanced options', 1 >> > RECONFIGURE >> > GO >> > sp_configure 'awe enabled', 1 >> > RECONFIGURE >> > GO >> > sp_configure 'max server memory', 6144 >> > RECONFIGURE >> >> > "Chowsman" <Chows...@gmail.com> wrote in message >> >> >news:99c0f856-a551-44ca-986c-f5487caf6280@z11g2000prl.googlegroups.com... >> >> > >I have a Dell 2950 running Windows 2003 Enterprise Edition with a >> > > MD1000 attached to it with RAID10. SQL version is Standard. The >> > > system has 8Gb of RAM and I am wondering how to utilize memory in the >> > > most efficient manner. >> >> > > Any would be appreciated. Thanks >> >> It is not a cluster, stand alone server. > > I am assuming here that this is run on the 'master' database? |
|
|
|
05/09/2008, 16h42
|
#7 |
|
Messages: n/a
Hébergeur: |
Re: AWE SQL 2005 / 8Gb RAM / 32bit
In the line "sp_configure 'max server memory', 6144" - how did you determine
the number 6144? "Kalen Delaney" wrote: > You can run sp_configure from any database. It allows you to change > server-wide properties. > It is well documented. > > -- > HTH > Kalen Delaney, SQL Server MVP > www.InsideSQLServer.com > www.SQLTuners.com > > > "Chowsman" <Chowsman@gmail.com> wrote in message > news:7f7d9b8d-e1a9-4c89-8709-c4832f62d769@i24g2000prf.googlegroups.com... > > On Aug 19, 10:40 pm, Chowsman <Chows...@gmail.com> wrote: > >> On Aug 19, 10:36 pm, "Uri Dimant" <u...@iscar.co.il> wrote: > >> > >> > >> > >> > Hi > >> > Is it a cluster? > >> > >> > sp_configure 'show advanced options', 1 > >> > RECONFIGURE > >> > GO > >> > sp_configure 'awe enabled', 1 > >> > RECONFIGURE > >> > GO > >> > sp_configure 'max server memory', 6144 > >> > RECONFIGURE > >> > >> > "Chowsman" <Chows...@gmail.com> wrote in message > >> > >> >news:99c0f856-a551-44ca-986c-f5487caf6280@z11g2000prl.googlegroups.com... > >> > >> > >I have a Dell 2950 running Windows 2003 Enterprise Edition with a > >> > > MD1000 attached to it with RAID10. SQL version is Standard. The > >> > > system has 8Gb of RAM and I am wondering how to utilize memory in the > >> > > most efficient manner. > >> > >> > > Any would be appreciated. Thanks > >> > >> It is not a cluster, stand alone server. > > > > I am assuming here that this is run on the 'master' database? > > > |
|
|
|
05/09/2008, 17h35
|
#8 |
|
Messages: n/a
Hébergeur: |
Re: AWE SQL 2005 / 8Gb RAM / 32bit
Hi Amy
This question refers to a server with 8 GB of RAM, and we need to leave a bit for the OS, so max memory is set to about 6 MB. The ideal amount of memory should be determined by testing on your system with your application, but this blog post might get you started: http://glennberrysqlperformance.spac...960!1003.entry -- HTH Kalen Delaney, SQL Server MVP www.InsideSQLServer.com www.SQLTuners.com "Amy" <Amy@discussions.microsoft.com> wrote in message news:C4BEC7DC-B81A-43D7-B2AF-A7C320A903C1@microsoft.com... > In the line "sp_configure 'max server memory', 6144" - how did you > determine > the number 6144? > > "Kalen Delaney" wrote: > >> You can run sp_configure from any database. It allows you to change >> server-wide properties. >> It is well documented. >> >> -- >> HTH >> Kalen Delaney, SQL Server MVP >> www.InsideSQLServer.com >> www.SQLTuners.com >> >> >> "Chowsman" <Chowsman@gmail.com> wrote in message >> news:7f7d9b8d-e1a9-4c89-8709-c4832f62d769@i24g2000prf.googlegroups.com... >> > On Aug 19, 10:40 pm, Chowsman <Chows...@gmail.com> wrote: >> >> On Aug 19, 10:36 pm, "Uri Dimant" <u...@iscar.co.il> wrote: >> >> >> >> >> >> >> >> > Hi >> >> > Is it a cluster? >> >> >> >> > sp_configure 'show advanced options', 1 >> >> > RECONFIGURE >> >> > GO >> >> > sp_configure 'awe enabled', 1 >> >> > RECONFIGURE >> >> > GO >> >> > sp_configure 'max server memory', 6144 >> >> > RECONFIGURE >> >> >> >> > "Chowsman" <Chows...@gmail.com> wrote in message >> >> >> >> >news:99c0f856-a551-44ca-986c-f5487caf6280@z11g2000prl.googlegroups.com... >> >> >> >> > >I have a Dell 2950 running Windows 2003 Enterprise Edition with a >> >> > > MD1000 attached to it with RAID10. SQL version is Standard. The >> >> > > system has 8Gb of RAM and I am wondering how to utilize memory in >> >> > > the >> >> > > most efficient manner. >> >> >> >> > > Any would be appreciated. Thanks >> >> >> >> It is not a cluster, stand alone server. >> > >> > I am assuming here that this is run on the 'master' database? >> >> >> |
|
|
|
05/09/2008, 18h11
|
#9 |
|
Messages: n/a
Hébergeur: |
Re: AWE SQL 2005 / 8Gb RAM / 32bit
Perfect - that is exactly what we needed. Thank you.
"Kalen Delaney" wrote: > Hi Amy > > This question refers to a server with 8 GB of RAM, and we need to leave a > bit for the OS, so max memory is set to about 6 MB. The ideal amount of > memory should be determined by testing on your system with your application, > but this blog post might get you started: > > http://glennberrysqlperformance.spac...960!1003.entry > > -- > HTH > Kalen Delaney, SQL Server MVP > www.InsideSQLServer.com > www.SQLTuners.com > > > "Amy" <Amy@discussions.microsoft.com> wrote in message > news:C4BEC7DC-B81A-43D7-B2AF-A7C320A903C1@microsoft.com... > > In the line "sp_configure 'max server memory', 6144" - how did you > > determine > > the number 6144? > > > > "Kalen Delaney" wrote: > > > >> You can run sp_configure from any database. It allows you to change > >> server-wide properties. > >> It is well documented. > >> > >> -- > >> HTH > >> Kalen Delaney, SQL Server MVP > >> www.InsideSQLServer.com > >> www.SQLTuners.com > >> > >> > >> "Chowsman" <Chowsman@gmail.com> wrote in message > >> news:7f7d9b8d-e1a9-4c89-8709-c4832f62d769@i24g2000prf.googlegroups.com... > >> > On Aug 19, 10:40 pm, Chowsman <Chows...@gmail.com> wrote: > >> >> On Aug 19, 10:36 pm, "Uri Dimant" <u...@iscar.co.il> wrote: > >> >> > >> >> > >> >> > >> >> > Hi > >> >> > Is it a cluster? > >> >> > >> >> > sp_configure 'show advanced options', 1 > >> >> > RECONFIGURE > >> >> > GO > >> >> > sp_configure 'awe enabled', 1 > >> >> > RECONFIGURE > >> >> > GO > >> >> > sp_configure 'max server memory', 6144 > >> >> > RECONFIGURE > >> >> > >> >> > "Chowsman" <Chows...@gmail.com> wrote in message > >> >> > >> >> >news:99c0f856-a551-44ca-986c-f5487caf6280@z11g2000prl.googlegroups.com... > >> >> > >> >> > >I have a Dell 2950 running Windows 2003 Enterprise Edition with a > >> >> > > MD1000 attached to it with RAID10. SQL version is Standard. The > >> >> > > system has 8Gb of RAM and I am wondering how to utilize memory in > >> >> > > the > >> >> > > most efficient manner. > >> >> > >> >> > > Any would be appreciated. Thanks > >> >> > >> >> It is not a cluster, stand alone server. > >> > > >> > I am assuming here that this is run on the 'master' database? > >> > >> > >> > > > |
|
|
 |
| Outils de la discussion | |
|
|
