| Dave Wickert [MSFT] 2005-04-26, 8:24 pm |
| 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/evalua.../bianalysis.asp
--
Dave Wickert [MSFT]
dwickert@online.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@gmail.com> wrote in message
news:1114292759.720288.29550@f14g2000cwb.googlegroups.com...
> 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
>
|