SQL Server Performance

process large dimension fast

Discussion in 'SQL Server 2005 Analysis Services' started by light_wt, Oct 9, 2008.

  1. light_wt New Member

    I have a large dimension in the Analysis Service. It reads data from a view in SQL server over the network.

    a select of that view locally takes about 6 min to finish. there are about 4 million rows

    a select of that view from the AS box takes about 18 min to finish (3x the time compare to local).

    is there a way to speed up the AS to process that dimension?

  2. moh_hassan20 New Member

    drop the view, and create table with same name and structure
    Create SSIS task for importing the data . Create schedule for executing it.

Share This Page