none
Analysis Service 配置集群的问题 RRS feed

  • 问题

  • 大大们好:

          接触到一个需要配置Analysis Service2008集群的问题,这里向大家请教下

          安装SQL Server 2008,主要使用的却是Analysis Service 和integration Service,后台数据库使用Oracle,把Oracle的数据提取出来在放入到Analysis Service中,然后通过工具ReportPortal来展现多维数据。

          问题一:客户提供了两台PC,希望可以提高查询性能,这个是配置SQL Server集群还是NLB,对于Analysis Service是需要单独配置吗?

          问题二:通过SQL Server代理定义作业时限Analysis Service的处理,只有通过设置时间这个方法吗?微软有没有提供基于事件的触发?

    问题一可能有些大,复杂的话希望大大们给提个醒,有链接地址或是哪方面的资料说一下,谢谢!

    2010年10月11日 2:31

答案

  • 1. SSAS doesn't support load balancing.

    2. you mean like to process cube based on data change in Oracle?

    • 已标记为答案 songcongjie 2010年10月12日 1:02
    2010年10月11日 3:12
  • You have to write code to start processing job when value in base table changes, but is it good practice? What happens if user is querying cube while you want to process it?

    With 2 machines, you may split users to them if can keep cube and dimensions in sync.

    • 已标记为答案 songcongjie 2010年10月12日 1:02
    2010年10月11日 14:27

全部回复

  • 1. SSAS doesn't support load balancing.

    2. you mean like to process cube based on data change in Oracle?

    • 已标记为答案 songcongjie 2010年10月12日 1:02
    2010年10月11日 3:12
  • 2.比如说我Oracle中的表的数据刷新后,我会定义一个触发的表,Oracle中的数据刷新后这个表里的值就发生改变,当这个值改变后就会处理cube,这个是要自己写代码还是微软有提供的方案?

    SSAS不支持负载均衡,那我这两台PC也就是没有意义了?


    好好做事,好好做人
    2010年10月11日 3:40
  • You have to write code to start processing job when value in base table changes, but is it good practice? What happens if user is querying cube while you want to process it?

    With 2 machines, you may split users to them if can keep cube and dimensions in sync.

    • 已标记为答案 songcongjie 2010年10月12日 1:02
    2010年10月11日 14:27
  • hi rmiao,

          I found these in SSAS2005PerGuid.doc:

     

    If your performance bottleneck is processor utilization on a single system as a result of a multi-user query workload, you can increase query performance by using a cluster of Analysis Services servers to service query requests. Requests can be load balanced across two Analysis Services servers, or across a larger number of Analysis Services servers to support a large number of concurrent users (this is called a server farm). Load-balancing clusters generally scale linearly. Both Microsoft and third-party vendors provide cluster solutions. The Microsoft load-balancing solution is Network Load Balancing (NLB), which is a feature of the Windows Server operating system. With NLB, you can create an NLB cluster of Analysis Services servers running in multiple host mode. When an NLB cluster of Analysis Services servers is running in multiple host mode, incoming requests are load balanced among the Analysis Services servers. When you use a load-balancing cluster, be aware that the data caches on each of the servers in the load-balancing cluster will be different, resulting in differences in query response times from query to query by the same client.

           If i can install SSAS in a cluster and keep cube and dimensions in sync , will this improve the performance? and how i can keep cube and dimensions in sync between two machines?


    好好做事,好好做人
    2010年10月12日 2:09
  • NLB cluster is different from msmc cluster. To set nlb, ssas db has to be in sync on all servers in the farm. Means have to build cube same way and process it in same schedule on all servers.
    2010年10月12日 2:19