Re: -- SQL 2005 memory (x64) --

Tech-Archive recommends: Fix windows errors by optimizing your registry

1. If 64 bits architecture doesn't need AWE, Why is the option available
in the SQL Server 64 bits?

Honestly, I don't really know why that checkbox is exist in x64 version of
SQL Server.

For AWE and SQL2005 X64, take a read of the following blog:

http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx

Linchi

"Ekrem Önsoy" wrote:

Hello Edmundo!

Answers are in lines.

--
Ekrem nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT



"Edmundo J. Davila" <edavila@xxxxxxxxxx> wrote in message
news:066B9EFE-EDC3-4AF5-AF01-509F3263EF73@xxxxxxxxxxxxxxxx
Ekrem,

Thank you for your answer.

I have the following doubts:

1. If 64 bits architecture doesn't need AWE, Why is the option available
in the SQL Server 64 bits?

Honestly, I don't really know why that checkbox is exist in x64 version of
SQL Server. I'll ask you to check out the following document from BOL to
learn more about usage of AWE option in SQL Server 2005 and why it's not
necessary to use it in x64 systems.

http://msdn2.microsoft.com/en-us/library/ms175581.aspx


2. I'm supposing SQL Server is using a maximum of 2GB of RAM, because I
can't increase the maximum server memory in the SQL Server (the top is
2147483647)? Because of that I can't set (at least from the interface) the
maximum memory of SQL Server to 4GB.

2147483647 is MB, not KB or BYTE. This is a default and max value.


3. Why do you think is better RAID10 than RAID5. As far as I know (I'm
not an expert on RAIDs) RAID10 would be slower because of the redundancy.

Take a look at the following article by S. Kagel:
http://www.miracleas.com/BAARF/RAID5_versus_RAID10.txt

Your answer has been very useful. I'll appreciate your comments regarding
to my doubts.

Edmundo J. Davila

.

Relevant Pages

  • Re: Memory usage not exceeding 4GB.
    ... You do not need to add /PAE for x64 systems. ... you need to be sure that AWE is enabled of course. ... First be sure your system sees all of your memory. ... SQL Server 2000 enterprise edition sp4 is installed. ...
    (microsoft.public.sqlserver.setup)
  • Re: How to know whether SQL Server 2005 Tools installed are x64 ve
    ... My mistake, I'm confused with SSMS, as there's no x64 version of this tool. ... have a look at "Microsoft SQL Server 2005 Command Line Query Utility", ... Microsoft SQL Server Management Objects Collection ...
    (microsoft.public.sqlserver.tools)
  • Re: Cant install SQL Server 2005 Express Edition on WinXP Pro x64 (0x80041008)
    ... Edition setup off CD, everything installs just fine, but SQL ... Server 2005 Express Edition x64". ... it fails on "SQL Server Setup is scanning ... executed due to WMI configuration on the machine ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server consolidation project
    ... The bottom line is that X64 will give you reasonable cost hardware that is capable of accessing lots of memory directly for X64 bit apps while still allowing 32 bit apps to run just as fast as well. ... Andrew J. Kelly SQL MVP ... Could you guys please recommend some good IBM machines as i dont have a choice for running SQL Server as a cluster ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 x96 and x64 side by side
    ... If I followed the discussion correctly, the cluster in this example has SQL ... Your comment on "x64 does not have a compiler for scripting" I don't quite ... The SQL Server Books Online also have a discussion of how to run SSIS ... We want to isntall anew dedicated instance for SSIS in Prod and they want ...
    (microsoft.public.sqlserver.setup)