Monitoring bcp Sessions with dbcc checktable and sp

If you do not specify which partition the bcp sessions should use, Adaptive 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:

dbcc checktable – to periodically to check the total page counts for each partition
sp_helpsegment or sp_helpartition – to perform a similar check, but without locking the database objects

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.

Monitoring bcp Sessions with dbcc checktable and sp_helpsegment