| Groups | Blog | Home |
sql server clustering : Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4
I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory Manager/Total Server Memory). I would like to allocate nearly all of the available memory on the machine to SQL Server. I seem to have the same symptons described in this MS article- http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No Qualifying Products" error when I try to install the HOTFIX. Any help would be greatly appreciated. Nick
Hint - look in the subject title :)
Cheers, Rodney R. Fournier MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://msmvps.com/clustering - Blog http://www.clusterhelp.com - Cluster Training ClusterHelp.com is a Microsoft Certified Gold Partner [quoted text, click to view] "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:Oxd$uP%23OGHA.2604@TK2MSFTNGP09.phx.gbl... > You didn't mention which edition and version of SQL Server you are using. > What about the OS? > > > -- > Andrew J. Kelly SQL MVP > > > <nicholasbecker@gmail.com> wrote in message > news:1141069604.298209.240400@i39g2000cwa.googlegroups.com... >>I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB >> >> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL >> >> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory >> Manager/Total Server Memory). I would like to allocate nearly all of >> the available memory on the machine to SQL Server. >> >> I seem to have the same symptons described in this MS article- >> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No >> Qualifying Products" error when I try to install the HOTFIX. >> >> >> Any help would be greatly appreciated. >> >> >> Nick >> > >
You didn't mention which edition and version of SQL Server you are using.
What about the OS? -- Andrew J. Kelly SQL MVP [quoted text, click to view] <nicholasbecker@gmail.com> wrote in message news:1141069604.298209.240400@i39g2000cwa.googlegroups.com... >I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB > > of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL > > Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory > Manager/Total Server Memory). I would like to allocate nearly all of > the available memory on the machine to SQL Server. > > I seem to have the same symptons described in this MS article- > http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No > Qualifying Products" error when I try to install the HOTFIX. > > > Any help would be greatly appreciated. > > > Nick >
Agreed they did not say if they were clustering or not.
Cheers, Rodney R. Fournier MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://msmvps.com/clustering - Blog http://www.clusterhelp.com - Cluster Training ClusterHelp.com is a Microsoft Certified Gold Partner [quoted text, click to view] "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:e%23dacv%23OGHA.456@TK2MSFTNGP15.phx.gbl... >I hate when that happens<g>. I never expect details to be in the subject >line. We still need to know the Editions of each though. > > -- > Andrew J. Kelly SQL MVP > > > "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in > message news:%23093YX%23OGHA.2828@TK2MSFTNGP12.phx.gbl... >> Hint - look in the subject title :) >> >> Cheers, >> >> Rodney R. Fournier >> >> MVP - Windows Server - Clustering >> http://www.nw-america.com - Clustering Website >> http://msmvps.com/clustering - Blog >> http://www.clusterhelp.com - Cluster Training >> ClusterHelp.com is a Microsoft Certified Gold Partner >> >> >> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >> news:Oxd$uP%23OGHA.2604@TK2MSFTNGP09.phx.gbl... >>> You didn't mention which edition and version of SQL Server you are >>> using. What about the OS? >>> >>> >>> -- >>> Andrew J. Kelly SQL MVP >>> >>> >>> <nicholasbecker@gmail.com> wrote in message >>> news:1141069604.298209.240400@i39g2000cwa.googlegroups.com... >>>>I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB >>>> >>>> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL >>>> >>>> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory >>>> Manager/Total Server Memory). I would like to allocate nearly all of >>>> the available memory on the machine to SQL Server. >>>> >>>> I seem to have the same symptons described in this MS article- >>>> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No >>>> Qualifying Products" error when I try to install the HOTFIX. >>>> >>>> >>>> Any help would be greatly appreciated. >>>> >>>> >>>> Nick >>>> >>> >>> >> >> > >
I hate when that happens<g>. I never expect details to be in the subject
line. We still need to know the Editions of each though. -- Andrew J. Kelly SQL MVP "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in message news:%23093YX%23OGHA.2828@TK2MSFTNGP12.phx.gbl... [quoted text, click to view] > Hint - look in the subject title :) > > Cheers, > > Rodney R. Fournier > > MVP - Windows Server - Clustering > http://www.nw-america.com - Clustering Website > http://msmvps.com/clustering - Blog > http://www.clusterhelp.com - Cluster Training > ClusterHelp.com is a Microsoft Certified Gold Partner > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:Oxd$uP%23OGHA.2604@TK2MSFTNGP09.phx.gbl... >> You didn't mention which edition and version of SQL Server you are using. >> What about the OS? >> >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> <nicholasbecker@gmail.com> wrote in message >> news:1141069604.298209.240400@i39g2000cwa.googlegroups.com... >>>I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB >>> >>> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL >>> >>> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory >>> Manager/Total Server Memory). I would like to allocate nearly all of >>> the available memory on the machine to SQL Server. >>> >>> I seem to have the same symptons described in this MS article- >>> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No >>> Qualifying Products" error when I try to install the HOTFIX. >>> >>> >>> Any help would be greatly appreciated. >>> >>> >>> Nick >>> >> >> > >
Yes they did. First line:
"I have a SQL Server cluster with..." And it does sound like they should be able to install the hotfix. I suggest making sure they are logging in from a domain account with local admin privs, makng sure the windows scheduler works, and making sure they are starting the install from the noe that currently owns the SQL resource group. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in message news:exaUjy%23OGHA.2236@TK2MSFTNGP15.phx.gbl... [quoted text, click to view] > Agreed they did not say if they were clustering or not. > > Cheers, > > Rodney R. Fournier > > MVP - Windows Server - Clustering > http://www.nw-america.com - Clustering Website > http://msmvps.com/clustering - Blog > http://www.clusterhelp.com - Cluster Training > ClusterHelp.com is a Microsoft Certified Gold Partner > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:e%23dacv%23OGHA.456@TK2MSFTNGP15.phx.gbl... >>I hate when that happens<g>. I never expect details to be in the subject >>line. We still need to know the Editions of each though. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in >> message news:%23093YX%23OGHA.2828@TK2MSFTNGP12.phx.gbl... >>> Hint - look in the subject title :) >>> >>> Cheers, >>> >>> Rodney R. Fournier >>> >>> MVP - Windows Server - Clustering >>> http://www.nw-america.com - Clustering Website >>> http://msmvps.com/clustering - Blog >>> http://www.clusterhelp.com - Cluster Training >>> ClusterHelp.com is a Microsoft Certified Gold Partner >>> >>> >>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >>> news:Oxd$uP%23OGHA.2604@TK2MSFTNGP09.phx.gbl... >>>> You didn't mention which edition and version of SQL Server you are >>>> using. What about the OS? >>>> >>>> >>>> -- >>>> Andrew J. Kelly SQL MVP >>>> >>>> >>>> <nicholasbecker@gmail.com> wrote in message >>>> news:1141069604.298209.240400@i39g2000cwa.googlegroups.com... >>>>>I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB >>>>> >>>>> of RAM. I have PAE and AWE enabled on the server, but I cannot get >>>>> SQL >>>>> >>>>> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory >>>>> Manager/Total Server Memory). I would like to allocate nearly all of >>>>> the available memory on the machine to SQL Server. >>>>> >>>>> I seem to have the same symptons described in this MS article- >>>>> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No >>>>> Qualifying Products" error when I try to install the HOTFIX. >>>>> >>>>> >>>>> Any help would be greatly appreciated. >>>>> >>>>> >>>>> Nick >>>>> >>>> >>>> >>> >>> >> >> > >
Yes but you can cluster Developer Edition :)
Cheers, Rodney R. Fournier MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog http://www.clusterhelp.com - Cluster Training ClusterHelp.com is a Microsoft Certified Gold Partner [quoted text, click to view] "Geoff N. Hiten" <SQLCraftsman@gmail.com> wrote in message news:eGfdXEAPGHA.2268@TK2MSFTNGP09.phx.gbl... > Yes they did. First line: > "I have a SQL Server cluster with..." > > And it does sound like they should be able to install the hotfix. > > I suggest making sure they are logging in from a domain account with local > admin privs, makng sure the windows scheduler works, and making sure they > are starting the install from the noe that currently owns the SQL resource > group. > > -- > Geoff N. Hiten > Microsoft SQL Server MVP > Senior Database Administrator > > "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in > message news:exaUjy%23OGHA.2236@TK2MSFTNGP15.phx.gbl... >> Agreed they did not say if they were clustering or not. >> >> Cheers, >> >> Rodney R. Fournier >> >> MVP - Windows Server - Clustering >> http://www.nw-america.com - Clustering Website >> http://msmvps.com/clustering - Blog >> http://www.clusterhelp.com - Cluster Training >> ClusterHelp.com is a Microsoft Certified Gold Partner >> >> >> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >> news:e%23dacv%23OGHA.456@TK2MSFTNGP15.phx.gbl... >>>I hate when that happens<g>. I never expect details to be in the subject >>>line. We still need to know the Editions of each though. >>> >>> -- >>> Andrew J. Kelly SQL MVP >>> >>> >>> "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in >>> message news:%23093YX%23OGHA.2828@TK2MSFTNGP12.phx.gbl... >>>> Hint - look in the subject title :) >>>> >>>> Cheers, >>>> >>>> Rodney R. Fournier >>>> >>>> MVP - Windows Server - Clustering >>>> http://www.nw-america.com - Clustering Website >>>> http://msmvps.com/clustering - Blog >>>> http://www.clusterhelp.com - Cluster Training >>>> ClusterHelp.com is a Microsoft Certified Gold Partner >>>> >>>> >>>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >>>> news:Oxd$uP%23OGHA.2604@TK2MSFTNGP09.phx.gbl... >>>>> You didn't mention which edition and version of SQL Server you are >>>>> using. What about the OS? >>>>> >>>>> >>>>> -- >>>>> Andrew J. Kelly SQL MVP >>>>> >>>>> >>>>> <nicholasbecker@gmail.com> wrote in message >>>>> news:1141069604.298209.240400@i39g2000cwa.googlegroups.com... >>>>>>I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 >>>>>>GB >>>>>> >>>>>> of RAM. I have PAE and AWE enabled on the server, but I cannot get >>>>>> SQL >>>>>> >>>>>> Server to access more than 4GB of RAM (using perfmon- >>>>>> SQLServer:Memory >>>>>> Manager/Total Server Memory). I would like to allocate nearly all of >>>>>> the available memory on the machine to SQL Server. >>>>>> >>>>>> I seem to have the same symptons described in this MS article- >>>>>> http://support.microsoft.com/default.aspx?kbid=899761, but I get a >>>>>> "No >>>>>> Qualifying Products" error when I try to install the HOTFIX. >>>>>> >>>>>> >>>>>> Any help would be greatly appreciated. >>>>>> >>>>>> >>>>>> Nick >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
But it reacts exactly like Enterprise Edition for this purpose. :)
-- Geoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in message news:uULg6mAPGHA.3264@TK2MSFTNGP11.phx.gbl... [quoted text, click to view] > Yes but you can cluster Developer Edition :) > > Cheers, > > Rodney R. Fournier > > MVP - Windows Server - Clustering > http://www.nw-america.com - Clustering Website > http://www.msmvps.com/clustering - Blog > http://www.clusterhelp.com - Cluster Training > ClusterHelp.com is a Microsoft Certified Gold Partner > > > "Geoff N. Hiten" <SQLCraftsman@gmail.com> wrote in message > news:eGfdXEAPGHA.2268@TK2MSFTNGP09.phx.gbl... >> Yes they did. First line: >> "I have a SQL Server cluster with..." >> >> And it does sound like they should be able to install the hotfix. >> >> I suggest making sure they are logging in from a domain account with >> local admin privs, makng sure the windows scheduler works, and making >> sure they are starting the install from the noe that currently owns the >> SQL resource group. >> >> -- >> Geoff N. Hiten >> Microsoft SQL Server MVP >> Senior Database Administrator >> >> "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in >> message news:exaUjy%23OGHA.2236@TK2MSFTNGP15.phx.gbl... >>> Agreed they did not say if they were clustering or not. >>> >>> Cheers, >>> >>> Rodney R. Fournier >>> >>> MVP - Windows Server - Clustering >>> http://www.nw-america.com - Clustering Website >>> http://msmvps.com/clustering - Blog >>> http://www.clusterhelp.com - Cluster Training >>> ClusterHelp.com is a Microsoft Certified Gold Partner >>> >>> >>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >>> news:e%23dacv%23OGHA.456@TK2MSFTNGP15.phx.gbl... >>>>I hate when that happens<g>. I never expect details to be in the >>>>subject line. We still need to know the Editions of each though. >>>> >>>> -- >>>> Andrew J. Kelly SQL MVP >>>> >>>> >>>> "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in >>>> message news:%23093YX%23OGHA.2828@TK2MSFTNGP12.phx.gbl... >>>>> Hint - look in the subject title :) >>>>> >>>>> Cheers, >>>>> >>>>> Rodney R. Fournier >>>>> >>>>> MVP - Windows Server - Clustering >>>>> http://www.nw-america.com - Clustering Website >>>>> http://msmvps.com/clustering - Blog >>>>> http://www.clusterhelp.com - Cluster Training >>>>> ClusterHelp.com is a Microsoft Certified Gold Partner >>>>> >>>>> >>>>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >>>>> news:Oxd$uP%23OGHA.2604@TK2MSFTNGP09.phx.gbl... >>>>>> You didn't mention which edition and version of SQL Server you are >>>>>> using. What about the OS? >>>>>> >>>>>> >>>>>> -- >>>>>> Andrew J. Kelly SQL MVP >>>>>> >>>>>> >>>>>> <nicholasbecker@gmail.com> wrote in message >>>>>> news:1141069604.298209.240400@i39g2000cwa.googlegroups.com... >>>>>>>I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 >>>>>>>GB >>>>>>> >>>>>>> of RAM. I have PAE and AWE enabled on the server, but I cannot get >>>>>>> SQL >>>>>>> >>>>>>> Server to access more than 4GB of RAM (using perfmon- >>>>>>> SQLServer:Memory >>>>>>> Manager/Total Server Memory). I would like to allocate nearly all >>>>>>> of >>>>>>> the available memory on the machine to SQL Server. >>>>>>> >>>>>>> I seem to have the same symptons described in this MS article- >>>>>>> http://support.microsoft.com/default.aspx?kbid=899761, but I get a >>>>>>> "No >>>>>>> Qualifying Products" error when I try to install the HOTFIX. >>>>>>> >>>>>>> >>>>>>> Any help would be greatly appreciated. >>>>>>> >>>>>>> >>>>>>> Nick >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
I apologize for semantics of my question. I would like to get back to
the original question. Does anyone have any information with regards to problem I'm experiencing?
We really were waiting for you to supply the editions of the OS and SQL
Server. If you are not running one of the editions that support above 4GB then this message is valid. If you are sure you are running a valid edition I would give MS PSS a call as it sounds like you do qualify for the AWE bug and they should be able to tell you why it errors. -- Andrew J. Kelly SQL MVP [quoted text, click to view] <nicholasbecker@gmail.com> wrote in message news:1141190045.680236.257000@i39g2000cwa.googlegroups.com... >I apologize for semantics of my question. I would like to get back to > the original question. Does anyone have any information with regards > to problem I'm experiencing? >
Windows 2K3 Enterprise and SQL Server 2000 Enterprise SP4 are the
versions.
Yes, Windows 2K3 Enterprise and SQL Server 2000 Enterprise SP4 are the
versions. Enterprise edition of both are required for clustering.
Yes sorry, you did mention it was a cluster. I would give MS PSS a call then
as the hotfix is required to get the full amount of AWE memory available. If the hotfix doesn't like something then they should tell you what it is and how to address it. They will refund your money for the call if it is in fact a bug. http://www.support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support http://www.mssqlserver.com/faq/general-pss.asp MS PSS -- Andrew J. Kelly SQL MVP [quoted text, click to view] "Ted Nugent" <nicholasbecker@gmail.com> wrote in message news:1141230123.984189.105620@i40g2000cwc.googlegroups.com... > Yes, Windows 2K3 Enterprise and SQL Server 2000 Enterprise SP4 are the > versions. Enterprise edition of both are required for clustering. >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |