rhunt
Well Known Member
Does anybody have information on the QDBSRV04 job? As I understand it, this system job rebuilds access paths when corruption is found in an index. I have seen pockets of time when this job has used 25% of my CPU for several minutes at a time. Additionally, my external reporting tool is taking hours to run general ledger reports that took 2 minutes yesterday.
Does anyone know who to find where the bad index is or have an alternate suggestion?
Thanks in advance.
Ryan
Does anyone know who to find where the bad index is or have an alternate suggestion?
Thanks in advance.
Ryan