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

Thanks for the link Linchi.

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



"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:21279F4E-BC72-43F0-8A10-DA0B127AD6C0@xxxxxxxxxxxxxxxx
> 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: Version.
    ... You mean like "MCTS: SQL Server 2005"? ... "Rogers" wrote in message ... "Ekrem Önsoy" wrote in message ...
    (microsoft.public.sqlserver.clients)
  • Re: -- SQL 2005 memory (x64) --
    ... Test RAID5 and RAID10 for your environment if you have ... After deciding which RAID configurationis the best for your particular ... MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Client on Windows XP
    ... MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ... "Ekrem Önsoy" wrote in message ...
    (microsoft.public.sqlserver.clients)
  • Re: Version.
    ... MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT ...
    (microsoft.public.sqlserver.clients)
  • Re: Error: AES128
    ... MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT ... "Rogers" wrote in message ...
    (microsoft.public.sqlserver.clients)
Loading