• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

SSIS BufferManagement In SQL Server

For the data flow in SSIS we have the defaultMaxRows and DefualtMaxSize,It will take which ever is less.Now my question is ,for the BlobStoragePath and BufferStoragePath,if i create more paths will there is any boost in performance and also wh at is the use if i do like this.

For example i now have 2 BlobStoragePath and 2 BufferStoragePath...if i increase to 4 each what is the difference and what is the advantage
0
jollysreek
Asked:
jollysreek
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> For example i now have 2 BlobStoragePath and 2 BufferStoragePath.

Hope you meant by BlobTempStoragePath and BufferTempStoragePath properties.
These properties will help store your Blob and Buffer storage in case File Syste, / SQL Server doesn't have capacity to hold the data.
Detailed info about these parameters here:

http://www.bimonkey.com/2008/04/blobtempstoragepath-and-buffertempstoragepath/

If you have 2/4 paths, then the single advantage is that if one path gets filled completely the others will be utilized.
If the first path is not completely filled, there is no difference in having either 2 or 4 paths.

Please note that these paths will be used when your MDF file is completely filled ( If autogrowth is restricted) or Physical disk is full or the File system in which BLOB files are stored has no free space.
Hope this clarifies
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now