Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / March 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fox1977 - 11 Mar 2008 16:15 GMT
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
John Bell - 12 Mar 2008 09:48 GMT
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

> Hi folks,
>
[quoted text clipped - 20 lines]
>
> Thanks in advance
Fox1977 - 24 Mar 2008 22:24 GMT
> Hi
>
[quoted text clipped - 28 lines]
>
> > Thanks in advance

Thanks John,

We have decided to take the plunge and go with x64 for server and SQL
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.