Finding the max row length in a recordset returned from a query

Question

Finding the max row length in a recordset returned from a query

dndaughtery

SSChampion

Points: 11290
More actions
March 7, 2011 at 7:17 am

#247751

I am new to buffer tuning and I'm trying to find a way to determine what my estimated record length is for records returned from a query with several joins so I can configure my DefaultMaxBufferRows and DefaulBufferSize. Does anyone have any ideas on how to do this?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

If I'm not mistaken, the estimated buffer length is the sum of sizes of the data types of all your columns. If you have data types with variable size, you should take the maximum size.

SSIS data types:

http://msdn.microsoft.com/en-us/library/ms141036.aspx

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP