CHAPTER 11 Backup and Data Recovery
395
Figure 11-1: sp_iqcheckdb results
Concurrency issues for sp_iqcheckdb
When you run sp_iqcheckdb, it reads every database page in use. This
procedure consumes most of the database server’s time, so that the I/O is as
efficient as possible. Any other concurrent activities on the system will run