Friday, March 23, 2012

New SQL Server Setup - 32 or 64bit windows 2003?

Hi folks,
Just wondering if anyone can offer me any advice on a new SQL server
setup I am putting together. We are trying to squeeze as much
performance out of a new server as possible.
We are looking at getting a DL380 with a quad core xeon, 4gb ram and
looking to run windows 2003 server standard r2 edition. The question
is whether to go with the 32 bit
version of windows or the 64bit version. We will be running SQL 2000
in 32 bit mode anyway so is there really any benfit in running the 64
bit version of windows? One supplier has mentioned
that it isn't really worth it unless we are running with at least 8gb
of RAM in the machine. Anyone any ideas?
On the disk arrangements I am looking at the following setup. 2 x
72gb SAS drives RAID 1 running the system, 2 x 72gb SAS drives RAID 1
running the log files and then 3 x 146gb SAS drives
running the datafiles running RAID 5. What do you think? Is this
suitable?
Any tips or ideas greatfully received!
Thanks in advance
Hi
If you have 64bit processors that are are supported SQL Server, then using
64bit all the way through is going to give you better performance. I am not
sure why you rule out 64bit SQL Server?
John
"Fox1977" wrote:

> Hi folks,
> Just wondering if anyone can offer me any advice on a new SQL server
> setup I am putting together. We are trying to squeeze as much
> performance out of a new server as possible.
> We are looking at getting a DL380 with a quad core xeon, 4gb ram and
> looking to run windows 2003 server standard r2 edition. The question
> is whether to go with the 32 bit
> version of windows or the 64bit version. We will be running SQL 2000
> in 32 bit mode anyway so is there really any benfit in running the 64
> bit version of windows? One supplier has mentioned
> that it isn't really worth it unless we are running with at least 8gb
> of RAM in the machine. Anyone any ideas?
> On the disk arrangements I am looking at the following setup. 2 x
> 72gb SAS drives RAID 1 running the system, 2 x 72gb SAS drives RAID 1
> running the log files and then 3 x 146gb SAS drives
> running the datafiles running RAID 5. What do you think? Is this
> suitable?
> Any tips or ideas greatfully received!
> Thanks in advance
>
|||On 12 Mar, 08:48, John Bell <jbellnewspo...@.hotmail.com> wrote:[vbcol=seagreen]
> Hi
> If you have 64bit processors that are are supported SQL Server, then using
> 64bit all the way through is going to give you better performance. I am not
> sure why you rule out 64bit SQL Server?
> John
> "Fox1977" wrote:
>
>
Thanks John,
We have decided to take the plunge and go with x64 for server and SQL

No comments:

Post a Comment