Monitoring bcp Sessions with dbcc checktable and sp_helpsegment

If you do not specify which partition the bcp sessions should use, the SAP ASE server randomly assigns the multiple bcp sessions to the table’s available partitions.

If this random assignment occurs, be sure to monitor the partitions to ensure that the process has evenly distributed the inserts by using either of the following:

For more information about dbcc checktable, see the System Administration Guide. For more information about sp_helpsegment and sp_helpartition, see the Reference Manual.

For more information about table partitions, see the Performance and Tuning Guide.