OS version question

[NoCalAdmin]

Would you say this statement is true?

Running Windows Server 2003 32 bit Enterprise with SQL 2005 will provide us the exact same functionality within SQL as if we were running the same datasets and databases on a Windows Server 2003 64 bit Standard with SQL 2005, except for performance.

Inherently the code, database and sets will function the same, correct?

I am trying to give my boss a definitive answer that we can use some servers built with Windows 2003 32 bit with SQL 2005 for on-going SQL developmental needs……… the current Production environment is built on Windows 2003 64 bit with SQL 2005......

Tom

 

[mrdenny]

No, there are some features of SQL Server 2005 which are not available. If you are not available on the 32bit enviroment. If you aren't using these features then yes they are the same.

xp_sendmail doesn't work in 64bit
DTS was not ported to the 64bit platform
Linked servers on the 64bit platform can be a pain to get working to servers other than SQL Server.

I think there are a couple of other little differences, but this is all that comes to mind at the moment.

Also Windows 2003 Standard 64bit still only gives you 4 Gigs of RAM (it's a licensing thing, not a platform thing).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[NoCalAdmin]

thanks for the SQL info

the server side: I am running 2003 64 bit Standard with SQL 2005 and using all 16GB of RAM. so I do disagree with the RAM statement.


Tom

 

[mrdenny]

Per

http://www.microsoft.com/windowsserver2003/evaluation/features/featuresorterresults.aspx

Windows 2003 Standard only supports up to 4 Gigs of RAM (It's towards the bottom).

SQL Server 2005 Standard will support as much RAM as the OS Supports.

Windows Server 2003 R2, Standard Edition, supports new systems with up to 4 GB of RAM, which facilitates improved system scalability and performance. The more RAM added to a server beyond minimum requirements, the more memory available for applications to use.

Windows Server 2003 R2, Enterprise Edition, supports new systems with 32 GB of RAM, which facilitates improved system scalability and performance. The more RAM added to a server beyond minimum requirements, the more memory available for applications to use.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[NoCalAdmin]

my bad.......... and I checked your right I am running the Enterprise Edition.... sorry for doubting you

Tom