Hi All,

I've been working on a cluster design (n+1) for server consolidation on a
service environment. One node will host a single sql server instance, and the
other 2-3 nodes will host multiple instances (to prevent any potential tempdb
contention) each.
Some apps will use both data engine and analysis services, and some will not.
What should be the most flexible design that might accommodate not only the
existing apps but also future applications?
I used to install AS on each node in a cluster. I wonder if I should install
it on one dedicated node servicing multiple apps.

Environment:
Windows Server 2008
SQL Server 2008

Thanks,

Ada
--
SQL Server DBA