Best place to install MS SQL 2005

[patrichek]

Hello everyone,
I need a bit of advice. I will be installing MS SQL 2005 standard edition on a dual xeon 3ghz, 600gb hd raid 5, 60 gb raid 1, 4gb ram poweredge server that is already running exchange 2003 on windows 2003 standard edition.
We have approximately 130 users who use the mail and 75 will be accessing the database.
Has anyone done something like this, do you think my server can handle the load?
My other option will be to install the sql 2005 on a terminal server (also a poweredge 2950 identical to my exchange server) running 2x application server (2x.com) which is where the database application will also be. I plan on using terminal services for users to access the database and 2x app. server is the seamless window (like citrix).
Thoughts, advice?

Thanks!

 

[mrdenny]

It's recommended to not install SQL Server on either an Exchange server or a Terminal server. SQL and Exchange will both try to use all the memory and CPU power. The same goes with SQL and the Terminal Server. It's highly recommended that you purchase a new server to run your SQL Server.

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)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[patrichek]

thanks. i was afraid of that...I'll order another server for TS.
With that in mind, I am considering ordering the TS Server with the 64bit OS and implications of mixing it with a 32bit domain?

thanks!

 

[onpnt]

None. Your domain doesn't care if the base system is 64 or 32 bit


[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[mrdenny]

With the domain there will be no issues. However having a terminal server that is 64bit, you'll want to have all the apps being installed on the machine being 64bit. I'd leave the Term Server as is, and move SQL to the 64bit machine.

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)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com