Hi @Irakli Mikadze ,
May I know what's the number of your whole buffers and how do you set the DefaultBufferSize and DefaultBufferMaxRows?
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 AutoAdjustBufferSize is set to true, the engine data flow engine uses the calculated value as the buffer size, and the value of DefaultBufferSize is ignored.
- If AutoAdjustBufferSize is set to false, the engine data flow engine uses the following rules to determine the buffer size.
a.If the result is more than the value of DefaultBufferSize, the engine reduces the number of rows.
b.If the result is less than the internally-calculated minimum buffer size, the engine increases the number of rows.
c.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.
Hope the following link will be helpful:
Data Flow Performance Features
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?
SQl server and ssis running on same computer ram is 128 gb i am watching ram and it is cool i think there is somthing else :(
You didn't answer the 2nd question.
Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) Jul 25 2020 11:26:55 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
Sign in to comment