SSIS Performance Issue

From: "Frank" <frankhe713@xxxxxxxxx>
Date: 5 Dec 2006 20:00:23 -0800

Hi Experts,

We used SSIS as ETL tool to design our first data mart. One of our SSIS
package is trying to load data from one Oracle DB to another Oracle DB
(no any data transformations, and using Native OLEDB\MS OLEDB Provider
for Oracle). The total rows is around 3 millions. But it took forever
to run it. The average loading speed is 5000 rows/minutes.

The configuration of my workstation is 4cpu, 2.8GHz, 1GB RAM. Even I
run the package in the server, which is Inter Xeron CPU, 3.2 GHz, 3.75
RAM, the it is still incredibly slow. And I've tried to set
DefaultBufferSize to 70MB, and reduce DefaultBufferMazRows to 5000. But
it 's not changed. I am wondering which parameter should I have to
adjust to improve the performance. Thank you so much for your time.

Frank

.

Prev by Date: Re: Create a cube in analysis services out of more than one fact table.
Next by Date: UDM approach/concept in real
Previous by thread: Create a cube in analysis services out of more than one fact table.
Next by thread: UDM approach/concept in real
Index(es):
- Date
- Thread

Relevant Pages

Re: Puzzeling error with package
... The platform is Oracle 10.2.0.3 running on 64bit Linux in a RAC ... I have a package which in the specification defines a constant i.e. ... All scripts spool to log files and I check each log file prior to ... initialization all happen at the same point and no errors are ...
(comp.databases.oracle.server)
Re: Puzzeling error with package
... The platform is Oracle 10.2.0.3 running on 64bit Linux in a RAC ... I have a package which in the specification defines a constant i.e. ... All scripts spool to log files and I check each log file prior to ... initialization all happen at the same point and no errors are ...
(comp.databases.oracle.server)
Re: Puzzeling error with package
... The platform is Oracle 10.2.0.3 running on 64bit Linux in a RAC ... I have a package which in the specification defines a constant i.e. ... All scripts spool to log files and I check each log file prior to ... initialization all happen at the same point and no errors are ...
(comp.databases.oracle.server)
Re: Puzzeling error with package
... The platform is Oracle 10.2.0.3 running on 64bit Linux in a RAC ... I have a package which in the specification defines a constant i.e. ... All scripts spool to log files and I check each log file prior to ... tcross rapttech dot com dot au ...
(comp.databases.oracle.server)
Puzzeling error with package
... The platform is Oracle 10.2.0.3 running on 64bit Linux in a RAC ... I have a package which in the specification defines a constant i.e. ... All scripts spool to log files and I check each log file prior to ... initialization all happen at the same point and no errors are ...
(comp.databases.oracle.server)