Hai sa punem problema altfel. Ce masuri ai luat pana in prezent ?
Ai incercat sa identifici cauza ?
>
Something about SSIS Performance Counters &
Set up OLE DB source to read from View efficiently>
Monitoring the Performance of the Data Flow Engine>
http://msdn.microsoft.com/en-us/library/ms141031.aspxYou can configure the following properties of the Data Flow task, all of which affect performance:
-
Specify the locations for temporary storage of buffer data (BufferTempStoragePath property) and of columns that contain binary large object (BLOB) data (BLOBTempStoragePath
property). By default, these properties contain the values of the TEMP
and TMP environment variables. You might want to specify other folders
to put the temporary files on a different or faster hard disk drive, or
to spread them across multiple drives. You can specify multiple
directories by delimiting the directory names with semicolons.
-
Define the default size of the buffer that the task uses, by setting the DefaultBufferSize property, and define the maximum number of rows in each buffer, by setting the DefaultBufferMaxRows
property. The default buffer size is 10 megabytes, with a maximum
buffer size of 100 megabytes. The default maximum number of rows is
10,000.
-
Set the number of threads that the task can use during execution, by setting the EngineThreads
property. This property provides a suggestion to the data flow engine
about the number of threads to use. The default is 5, with a minimum
value of 3. However, the engine will not use more threads than it
needs, regardless of the value of this property. The engine may also
use more threads than specified in this property, if necessary to avoid
concurrency issues.
...Adjust the Sizing of Buffers
The
data flow engine begins the task of sizing its buffers by calculating
the estimated size of a single row of data. Then it multiplies the
estimated size of a row by the value of DefaultBufferMaxRows to obtain a preliminary working value for the buffer size.
-
If the result is more than the value of DefaultBufferSize, the engine reduces the number of rows.
-
If the result is less than the internally-calculated minimum buffer size, the engine increases the number of rows.
-
If the result falls between the minimum buffer size and the value of DefaultBufferSize, the engine sizes the buffer as close as possible to the estimated row size times the value of DefaultBufferMaxRows.