Asynchronous prefetch is used during the following dbcc checks:
dbcc checkalloc, which checks allocation for all tables and indexes in a database, and the corresponding object-level commands, dbcc tablealloc and dbcc indexalloc
dbcc checkdb, which checks all tables and index links in a database, and dbcc checktable, which checks individual tables and their indexes
