 | |
Re: 2003 & SQL 2000 clustering Memory
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: 2003 & SQL 2000 clustering Memory -
01-24-2005
, 06:53 PM
|
From: "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com References: <#aikJhBAFHA.824 (AT) TK2MSFTNGP11 (DOT) phx.gbl 991EF344-9DA1-4551-9BA8-78C9CE26FC4A...soft (DOT) com |
<#laLrJMAFHA.3120 (AT) TK2MSFTNGP12 (DOT) phx.gbl>
<ey5dcnTAFHA.3592 (AT) TK2MSFTNGP09 (DOT) phx.gbl>
<uVcp0xVAFHA.3840 (AT) tk2msftngp13 (DOT) phx.gbl>
<5bn8LPdAFHA.3176 (AT) cpmsftngxa10 (DOT) phx.gbl>
Quote:
|
Subject: Re: 2003 & SQL 2000 clustering Memory Date: Mon, 24 Jan 2005 08:50:50 -0500 Lines: 52 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Message-ID: <unUD8uhAFHA.936 (AT) TK2MSFTNGP12 (DOT) phx.gbl Newsgroups: microsoft.public.sqlserver.clustering NNTP-Posting-Host: h002078c8df25.ne.client2.attbi.com 24.61.176.109 Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftn gxa06.phx.gbl!TK2MSFTNGP08 |
Quote:
|
Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clustering:16385 X-Tomcat-NG: microsoft.public.sqlserver.clustering What do you base that recommendation to not use the /3GB switch on? I have yet to see a system with only 8GB have a problem as long as you left at least 1GB for the OS and you were not running other apps on the server. -- Andrew J. Kelly SQL MVP "Uttam Parui[MS]" <uttamkp (AT) online (DOT) microsoft.com> wrote in message news:5bn8LPdAFHA.3176 (AT) cpmsftngxa10 (DOT) phx.gbl... I do not recommend using /3gb and /pae in boot.ini. If you are using both /3gb and /pae then do proper testing. Run Perfmon and monitor Free System PTEs under the Memory object to observe how many are free. Consider any value below 3000 as a minimum. NOTE: Low free page table entries can cause system instability. I would rather use just /pae in boot.ini and have awe enabled for sql and set max memory for sql = 6Gb. This would leave 2gb for OS and other programs/services. Ofcourse, in this case the assumption is that there is just one virtual SQL Server 2000 instance. Additional Information ================== Apply security update MS04-032 http://www.microsoft.com/technet/sec.../ms04-032.mspx Best Regards, Uttam Parui Microsoft Corporation This posting is provided "AS IS" with no warranties, and confers no rights. Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security. Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites: http://www.microsoft.com/protect http://www.microsoft.com/security/guidance/default.mspx |
#2
| |||
| |||
|
|
I have seen some cases where there was unexpected failovers and/or node hangs. On troubleshooting, we found that they were using /3gb, /pae and awe enabled and Perfmon logs showed Free PTE very low. Removing the /3gb gave relief and did not reproduce the issue. In some cases we also used /userva (for win2K3). Thats the reason, I recommended testing the cluster nodes and making sure that Free PTE was not very low (i.e not less than 3000). Best Regards, Uttam Parui Microsoft Corporation This posting is provided "AS IS" with no warranties, and confers no rights. Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security. Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites: http://www.microsoft.com/protect http://www.microsoft.com/security/guidance/default.mspx |
#3
| |||
| |||
|
|
Hello Andrew, The recommendations are based on the following KB article and also supporting customers with similar configurations that have faced OS stability issues: How to configure memory for more than 2 GB in SQL Server http://support.microsoft.com/default...274750&sd=tech Regards, Shashank Pawar SQL Server Support Engineer, Microsoft This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | From: "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com | References: <#aikJhBAFHA.824 (AT) TK2MSFTNGP11 (DOT) phx.gbl 991EF344-9DA1-4551-9BA8-78C9CE26FC4A...soft (DOT) com eGfTcbJAFHA.612 (AT) TK2MSFTNGP09 (DOT) phx.gbl #laLrJMAFHA.3120 (AT) TK2MSFTNGP12 (DOT) phx.gbl ey5dcnTAFHA.3592 (AT) TK2MSFTNGP09 (DOT) phx.gbl uVcp0xVAFHA.3840 (AT) tk2msftngp13 (DOT) phx.gbl 5bn8LPdAFHA.3176 (AT) cpmsftngxa10 (DOT) phx.gbl | Subject: Re: 2003 & SQL 2000 clustering Memory | Date: Mon, 24 Jan 2005 08:50:50 -0500 | Lines: 52 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 | X-RFC2646: Format=Flowed; Original | Message-ID: <unUD8uhAFHA.936 (AT) TK2MSFTNGP12 (DOT) phx.gbl | Newsgroups: microsoft.public.sqlserver.clustering | NNTP-Posting-Host: h002078c8df25.ne.client2.attbi.com 24.61.176.109 | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftn gxa06.phx.gbl!TK2MSFTNGP08 phx.gbl!TK2MSFTNGP12.phx.gbl | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clustering:16385 | X-Tomcat-NG: microsoft.public.sqlserver.clustering | | What do you base that recommendation to not use the /3GB switch on? I have | yet to see a system with only 8GB have a problem as long as you left at | least 1GB for the OS and you were not running other apps on the server. | | -- | Andrew J. Kelly SQL MVP | | | "Uttam Parui[MS]" <uttamkp (AT) online (DOT) microsoft.com> wrote in message | news:5bn8LPdAFHA.3176 (AT) cpmsftngxa10 (DOT) phx.gbl... | >I do not recommend using /3gb and /pae in boot.ini. If you are using both | >/3gb and /pae then do proper testing. Run Perfmon and monitor Free System | >PTEs under the | > Memory object to observe how many are free. Consider any value below 3000 | > as a minimum. NOTE: Low free page table entries can cause system | > instability. | | > I would rather use just /pae in boot.ini and have awe enabled for sql and | > set max memory for sql = 6Gb. This would leave 2gb for OS and other | > programs/services. | > Ofcourse, in this case the assumption is that there is just one virtual | > SQL Server 2000 instance. | | > Additional Information | > ================== | | > Apply security update MS04-032 | | > http://www.microsoft.com/technet/sec.../ms04-032.mspx | | > Best Regards, | | > Uttam Parui | > Microsoft Corporation | | > This posting is provided "AS IS" with no warranties, and confers no | > rights. | | > Are you secure? For information about the Strategic Technology Protection | > Program and to order your FREE Security Tool Kit, please visit | > http://www.microsoft.com/security. | | > Microsoft highly recommends that users with Internet access update their | > Microsoft software to better protect against viruses and security | > vulnerabilities. The easiest way | > to do this is to visit the following websites: | > http://www.microsoft.com/protect | > http://www.microsoft.com/security/guidance/default.mspx | | | | | |
#4
| |||
| |||
|
|
I do not recommend using /3gb and /pae in boot.ini. If you are using both /3gb and /pae then do proper testing. Run Perfmon and monitor Free System PTEs under the Memory object to observe how many are free. Consider any value below 3000 as a minimum. NOTE: Low free page table entries can cause system instability. I would rather use just /pae in boot.ini and have awe enabled for sql and set max memory for sql = 6Gb. This would leave 2gb for OS and other programs/services. Ofcourse, in this case the assumption is that there is just one virtual SQL Server 2000 instance. Additional Information ================== Apply security update MS04-032 http://www.microsoft.com/technet/sec.../ms04-032.mspx Best Regards, Uttam Parui Microsoft Corporation This posting is provided "AS IS" with no warranties, and confers no rights. Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security. Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites: http://www.microsoft.com/protect http://www.microsoft.com/security/guidance/default.mspx |
#5
| |||
| |||
|
|
That KB actually supports using the /3GB. Maybe even a bit too much in fact. Is there a KB that talks directly about these customer issues? If so that would be great to see. -- Andrew J. Kelly SQL MVP "Shashank Pawar [MSFT]" <spawar (AT) online (DOT) microsoft.com> wrote in message news:GGG3ehnAFHA.2868 (AT) cpmsftngxa10 (DOT) phx.gbl... Hello Andrew, The recommendations are based on the following KB article and also supporting customers with similar configurations that have faced OS stability issues: How to configure memory for more than 2 GB in SQL Server http://support.microsoft.com/default...274750&sd=tech Regards, Shashank Pawar SQL Server Support Engineer, Microsoft This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- | From: "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com | References: <#aikJhBAFHA.824 (AT) TK2MSFTNGP11 (DOT) phx.gbl 991EF344-9DA1-4551-9BA8-78C9CE26FC4A...soft (DOT) com eGfTcbJAFHA.612 (AT) TK2MSFTNGP09 (DOT) phx.gbl #laLrJMAFHA.3120 (AT) TK2MSFTNGP12 (DOT) phx.gbl ey5dcnTAFHA.3592 (AT) TK2MSFTNGP09 (DOT) phx.gbl uVcp0xVAFHA.3840 (AT) tk2msftngp13 (DOT) phx.gbl 5bn8LPdAFHA.3176 (AT) cpmsftngxa10 (DOT) phx.gbl | Subject: Re: 2003 & SQL 2000 clustering Memory | Date: Mon, 24 Jan 2005 08:50:50 -0500 | Lines: 52 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 | X-RFC2646: Format=Flowed; Original | Message-ID: <unUD8uhAFHA.936 (AT) TK2MSFTNGP12 (DOT) phx.gbl | Newsgroups: microsoft.public.sqlserver.clustering | NNTP-Posting-Host: h002078c8df25.ne.client2.attbi.com 24.61.176.109 | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftn gxa06.phx.gbl!TK2MSFTNGP08 phx.gbl!TK2MSFTNGP12.phx.gbl | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clustering:16385 | X-Tomcat-NG: microsoft.public.sqlserver.clustering | | What do you base that recommendation to not use the /3GB switch on? I have | yet to see a system with only 8GB have a problem as long as you left at | least 1GB for the OS and you were not running other apps on the server. | | -- | Andrew J. Kelly SQL MVP | | | "Uttam Parui[MS]" <uttamkp (AT) online (DOT) microsoft.com> wrote in message | news:5bn8LPdAFHA.3176 (AT) cpmsftngxa10 (DOT) phx.gbl... | >I do not recommend using /3gb and /pae in boot.ini. If you are using both | >/3gb and /pae then do proper testing. Run Perfmon and monitor Free System | >PTEs under the | > Memory object to observe how many are free. Consider any value below 3000 | > as a minimum. NOTE: Low free page table entries can cause system | > instability. | | > I would rather use just /pae in boot.ini and have awe enabled for sql and | > set max memory for sql = 6Gb. This would leave 2gb for OS and other | > programs/services. | > Ofcourse, in this case the assumption is that there is just one virtual | > SQL Server 2000 instance. | | > Additional Information | > ================== | | > Apply security update MS04-032 | | > http://www.microsoft.com/technet/sec.../ms04-032.mspx | | > Best Regards, | | > Uttam Parui | > Microsoft Corporation | | > This posting is provided "AS IS" with no warranties, and confers no | > rights. | | > Are you secure? For information about the Strategic Technology Protection | > Program and to order your FREE Security Tool Kit, please visit | > http://www.microsoft.com/security. | | > Microsoft highly recommends that users with Internet access update their | > Microsoft software to better protect against viruses and security | > vulnerabilities. The easiest way | > to do this is to visit the following websites: | > http://www.microsoft.com/protect | > http://www.microsoft.com/security/guidance/default.mspx | | | | | |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.