Hi

We are getting ready to deply AS for our sql server database. The
database will be on D1 server and AS will be on D2 server. Both are 8
cpu compaq servers with 4 GB RAM. Failover of Analysis Services is not
an option. We will be adding close to 800 K rows per day to the
database ( we have 3 or 4 dbs like that). We will be connecting from
Web Server W1/W2 ( IIS and XMLA ) to connect to D04 to display the
cubes. I want to implement the best practices for this task.

1. The repository can be migrated to Sql Server.
2. Paritioned Cubes will be built pointing to tables split on monthly
levels. Good thing is insert/updates happens to only the past 10 days
worth of data. So once we build a cube for a monthly table like 3/2005,
we are done. Only for Apr 2005 we need to process the cubes everyday.
3. We plan to do MOLAP for old monthly data and even current data. We
have only 4 cubes and a total of 12 dims. The processing time for
processing close to 25 M rows was around 30 minuets for 1 cube.

Please share your input about what else I need to take care because of
the large amount of data.

Thanks

Ragu

AS Performance Guide and the AS Operations Guide outlines many of the best
practices for large-scale deployments. For the most part, what you describe
looks correct.
http://www.microsoft.com/sql/evaluat...bianalysis.asp
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ragu" <ragudba (AT) gmail (DOT) com> wrote