SQL Server Databases and Cubes on one Server
User Rating: / 0
Written by Andrew Fryer   
Saturday, 23 August 2008 02:34

I have put Business Intelligence into a number of small businesses and these guys typically have one server set a side for BI, so how do you cram the database and the cubes into one box to get the best performance?

SQL Server databases and Analysis Services (SSAS) both love memory, and even windows server gets upset if you deprive it of more than certain amount so here’s some guidelines:


Tags: 2005, article

XL Cubed