INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I love this site! It's so nice to know that there are so many people out there who are willing to share their knowledge..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Analysis Services (OLAP) Forum

SSAS on its own or on the same box as the DB ?

Read More Threads Like This One

Recce (Programmer)

10 May 10 6:18

Good day,

I was wondering if anyone can give me some insight as to what the best practice is when working with SSAS.

Currently we have SSAS on a server that house the DB as well. Also,on the same server we have SSRS.

I was wondering if we would get better performance from SSAS if it was on its own server and then only pull the data from the DB which will be on another box. I would like to know if this sort of route will give us faster processing and better browsing performance on the user's side.

Also, what is the industry standar of doing things.

Thanks

pipe "We know nothing but, that what we know is not the truth..." - Me

MDXer (TechnicalUser)

10 May 10 16:02

A lot of factors can come into play like system resources and such. But for the most part I always place SSAS on a seperate server when given the option. SSAS will use every bit of resource available so I like having a box serve nothing but SSAS.

Recce (Programmer)

11 May 10 2:14

Thanks for this ...

pipe "We know nothing but, that what we know is not the truth..." - Me

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft SQL Server: Analysis Services (OLAP)