September 15, 2011 at 4:47 am
Guys we are beginning to look at Sharepoint 2010 as of right now I'm working on putting out a 2010 test server so our business groups can take a crack at some of the new features. Of course one of the features that's driving this project is Power Pivot for Excel 2010 my only problem with powerpivot is the dependency on SQL 2008 R2. Our main production SQL servers are running SQL 2008 but I read that Power Pivot depends heavily on 2008 R2 analysis services. So my question is has anyone set up Power pivot in a SQL 2008 environment for example I don't run analysis services on a separate box I have it installed on my production SQL server I even installed an instance of sql 2008 on the test VM that I'm running SP2010 on. So what I'm wanting to do is install analysis services 2008 R2 on the same box that's running SQL 2008 server and 2008 analysis services do you guys think this will be a problem or should analysis services 2008 R2 be installed on a completely separate system away from any server 2008 pieces. My last concern is does 2008 R2 analysis services have any dependencies where it needs a 2008 R2 database instance?
September 15, 2011 at 6:41 am
So what I'm wanting to do is install analysis services 2008 R2 on the same box that's running SQL 2008 server and 2008 analysis services do you guys think this will be a problem or should analysis services 2008 R2 be installed on a completely separate system away from any server 2008 pieces.
You will need to very careful about managing memory on the server. You could easily bring the server down if you allow analysis services to page to disk.
My last concern is does 2008 R2 analysis services have any dependencies where it needs a 2008 R2 database instance?
Yes, you can run 2008 R2 analysis services against a 2008 database without issues.
September 15, 2011 at 7:28 am
Ok well let me ask since I'm a SQL rookie how would I prevent analysis services from paging to disk besides making sure the sql box has enough physical ram installed. Also I'm assuming you've ran analysis services 2008 R2 on the same box as regular SQL what problems did you run into?
September 15, 2011 at 8:40 am
For analysis services you only supply a percentage of RAM to use, not an amount in MB as in SQL Server. So if you allocate 40% to both instances of analysis services then you will only leave 20% of your ram for both SQL Server and the OS. I would be very concerned about doing this on a production OLTP server.
September 15, 2011 at 8:54 am
So what are you saying should it be on a different server other than the production SQL server. I have no problem installing it on a dev box along with SQL 2008 and analysis services 2008 but I'm concerned about putting it on my production 2008 sql server. I've just always ran SQL and analysis services on the same box however I'm sure in some larger environments analysis services runs on it's on dedicated box.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply