Installing Team Foundation Server

[mrdenny]

Has anyone installed Team Foundataion Server.

We are looking at installing it here and see that it requires that the SSAS service be installed on the main SQL Server.

The problem is that we are planning on putting the Team Foundataion Server database on a production OLAP cluster and a don't want to install SSAS as it will impact the performance of the SQL Server, but I don't see a way to seperate the SSAS from the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com

 

[ptheriault]

Hey Denny,
I've never installed Team Foundation server but I have installed SSAS many times. As far as I know you can't seperate SSAS from SQL server. Are you installing SSAS 2005? 2005 is not as much of a memory pig as the 2000 version was. You don't have to load all your dimensions into memory now, SSAS 2005 loads dimensions in memory on a as-needed basis.

- Paul
- Database performance looks fine, it must be the Network!

 

[mrdenny]

You can most definetly install SSAS without the SQL engine. You always have been able to. In SQL 7 and SQL 2000 SSAS was a totally seperate installer.

The whole concept with SQL 2005 is that all these various services can be run on seperate machines so that you don't have any of the overhead of SSRS, SSAS, SSIS on the actual SQL Server and can offload those services to there own server.

However the Team Foundation server seams to require that you have SSAS installed on the local machine. We'll we don't run SSAS on the SQL Servers. We have spent a lot of money on an SSAS infracturer (Dev, QA servers and clustered production servers). I don't want to have to spend all the money on hardware to purchase seperate machines just for Team Foundataion Server when I've got this kick a** enviroment all setup.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com

 

[ptheriault]

my mistake, i have just always installed SSAS on the same server as SQL, but we don't have very large Analysis services enironments.

- Paul
- Database performance looks fine, it must be the Network!

 

[Catadmin]

Denny,

Could you install SSAS and then disable the services? Would that work?

I don't have any experience with Team Foundation Server, so this is just a WAG.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Nope, It checks to see not only if the service is installed, but it's it's running, and if it's set to automatic.

Don't you just love it when the Microsoft development teams don't talk to each other.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com

 

[Catadmin]

GAH!!! That's horrible!!!

I feel your pain, Denny. M$ needs to quit rushing their software development cycles.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Yep. The best part is when you do the database install part of the installer it doesn't even touch the SSAS. When you install the front end piece is when it hits the SSAS.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com

 

[Catadmin]

Denny,

I was just at the book store the other day and saw a book published for Professional Team Foundation Server. I believe it was put out by WROX. Maybe there's something in there that can help you out?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"