DW data load speed and sql page size

Hot Topic

Variable error
Message when clicking on the Report link - You are not authorized to view this page
Redudant Data on a table column...
error creating named calculation
How to achieve the last Time-selection while iterating in the time-dimension itself ?
xp_smtp_sendmail and Outlook Express works; Database Mail doesn't
Does a checkpoint file record a package's state
Retrieving DefaultConstraint property of a Table column is too slow
Optimization issues with a Database Maintenance Plan
JOIN problem with time involved

SQL Server

Calculated Members slow to display in Excel PivotTable
Huge issue with the Lookup problem
From MySQL to MSSQL 2005
Debugging a customponent used in a Integration Services project
High level of login/sec
Errors in the high-level relational engine
Copy Database
Calculated Member - #VALUE! in the Grand Total
ODBC connection for client application to SQL Server 2005 Express installed on network computer
dun have SSIS service under computer management in control panel.

DW data load speed and sql page size

We are working on our first DW in sql 2000 (later sql2005). We anticipate loading 30GB+ of data into our Analysis server. Is it possible to increase the sql page size from 8K to something larger (I'm hoping that doing so would facilitate the data loading speed. Or would that just cause more trouble down he line )

Bill

Answer this question

DW data load speed and sql page size

  • ArnoldA

    I have loaded a 120gb db with 115 million rows, many dimensions and hierarchies in 2hrs on a Quad x64 with 8gb. The cube is 6gb in size. Partitioning the cube improves thr throughput, as the partitions are processed in parallel.

    I have not changed any parameters in db engine or Analysis services. During cube load, SSAS uses all the 8gb and the 4 processors.

    Hope this helps.

  • drachx

    Forgot to give the time, ~ 1hr 30mins.
  • DW data load speed and sql page size
Answer this question