Sybase ASE. How to tell bcp is fast or slow

[corral]

I would like to know whether a bulk copy operation, seen as BULK INSERT with sp_who, is a fast or slow bcp in. That is, whether it is fully or minimally logged.

ASE 15.7 SP52

[former_member89972]

sp_who shows you some process details for each SPID including partial command details under "CMD" column.

bcp is fast (non-logged) based on how the table & database are configured.

- Database option "bulkcopy" must be true/enabled

- No indexes on table

- No triggers (or disabled triggers)

Otherwise bcp is slow i.e. logged

And this is NOT visible via output of sp_who.

HTH

Avinash