Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

BCP packet size not working Expand / Collapse
Author
Message
Posted Thursday, December 20, 2012 8:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 4:13 PM
Points: 44, Visits: 257
I have a Window 2008 R2 server 64-bit, SQL 2008 Enterprise 64-bit RTM I am doing large (hundred of millions of rows) BCP jobs and set the -a switch to 65535 but they all run at 32576 which I know was the max way back when but everything I read says 65535 is the max for the environment I'm working in.

What's not set? Where?

My sys admins can run stuff (non sql envriornment) at 65535 packet size


???? At a loss any help would be appreciated

Post #1399025
Posted Thursday, December 20, 2012 10:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 4:13 PM
Points: 44, Visits: 257
More info.

Running this BCP from inside xp_cmdshell (has to do with validation issues)

SQL Server default packet size is set to 4096 ....

so think that perhaps there is something in the SSMS/Query/SQL environment that is constricting the packet size to 32576
Post #1399064
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse