SQL Server 2005: Data Warehouse Location

[Caroline]

Hi,

Is it okay to create a data warehouse on a separate instance of sql server
2005, or is a separate machine required?

We have two Dell PowerEdge 2950 servers with 1.2 terabytes of EMC SAN
database storage, set up in a two-noce active/passive config, running on
Windows Server 2003 Enterprise Edition.

[Todd C]

Kind of depends on the load you expect to be hitting your DW.

As a minimum, I would make it a separate database. But would NOT install
another SQL (named) instance on a box that already has one just so you can
have a pure environment dedicated to data warehouseing. (OK, I *might*
consider it if the security requirements were so *drastically different* than
the OLTP databases and you had no other server).

If you are strictly Active/Passive, I would install on the Active node,
default instance. We have Active/Active so we installed it on the second
node, default instance.
--
Todd C
MCTS SQL Server 2005

Post by Caroline
Hi,
Is it okay to create a data warehouse on a separate instance of sql server
2005, or is a separate machine required?
We have two Dell PowerEdge 2950 servers with 1.2 terabytes of EMC SAN
database storage, set up in a two-noce active/passive config, running on
Windows Server 2003 Enterprise Edition.

[a a r o n . k e m p f @gmail.com [MCITP: DBA]]

how much RAM you got? how big is the database? how many databases are
on the main instanc?

If you have a lot of ram and the database isn't huge, then I'd
consider putting it on a seperate instance for sure.

Thanks

-Aaron

Post by Caroline
Hi,
Is it okay to create a data warehouse on a separate instance of sql server
2005, or is a separate machine required?
We have two Dell PowerEdge 2950 servers with 1.2 terabytes of EMC SAN
database storage, set up in a two-noce active/passive config, running on
Windows Server 2003 Enterprise Edition.