Selecting Hardware for Analysis Services (10GB-1TB size)
The first thing you are going to is to figure out is if you even need a dedicated analysis services server.
Some of our smaller customers just go for a mini "appliance" server which has Analysis Services/SharePoint and sometimes even a small data warehouse and PowerPivot installed on a single virtual machine with 16+ GB of RAM. For under 50 users, with only maybe 10 concurrent users, a cube size under 10GB or so and light usage this may work well, and is certainly a good starting block for an SME, proof of concept or small department.
Read more...Tags: management