June 1, 2010 at 9:24 am
I'm new to SSAS and have never used it or installed it. I understand SSAS can be installed on its own server or on the same server as the SQL Server. I'm considering installing it on the SQL Server, as that server is going to be clustered. Additionally, the SQL Server will be the only datasource for SSAS, at least at this time.
Are there any pitfalls in doing so, or is it a best practice to install SSAS on its own server? Are there any licensing considerations when installed on a separate server?
Thanks,
Cindy
June 1, 2010 at 9:50 am
you can install it on the same server, the advantage is that the data does not have far to travel when building the cubes. The disadvatange is that analysis server may compete for resources from the SQL server databases.
June 2, 2010 at 6:06 am
Thank-you for your response. That was the answer I was hoping to hear!
Cindy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply