Concurrency issues for sp_iqcheckdb – Sybase 12.4.2 User Manual

Page 415

Advertising
background image

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

Advertising