Re: 2003 & SQL 2000 clustering Memory

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 08:50:50 -0500

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@online.microsoft.com> wrote in message 
news:5bn8LPdAFHA.3176@cpmsftngxa10.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/security/bulletin/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
>
>

Relevant Pages

  • Re: How to use EFS to encrypt SQL DB file
    ... You want to make sure that SQL is starting here with an ... account that has the right to decrypt the mdf file. ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • RE: Users Logins
    ... On the sql ... server machine, go to start, programs, SQL Server, then choose the icon for ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Domain Group
    ... -Did you give that sql login access rights in the DB on the SQL Side? ... -Does it work with SQL Authentication and just not windows? ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • Re: Anti Virus software and SQL
    ... How about a recommendation from Microsoft: ... Consideration for a Virus Scanner on a Computer That Is Running SQL ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Genuine Advantage
    ... I tried all the methods recommended by Carey. ... couldn't validate because the ActiveX wouldn't run. ... Recommendation ... Microsoft Community Newsgroups ...
    (microsoft.public.windowsupdate)