September 27, 2006 at 9:27 pm
We have a case where just one table--a heavily used one--keeps getting its indexes corrupted. This table is part of a large OLTP database--more than 1,000 tables with the database mostly in fourth normal form.
If we stop everything and rebuild the indexes on this table, things will go fine for ten minutes or so. Then, things will slow down (extremely) and we find that the indexes are again corrupted.
What can cause this kind of thing to happen?
I apologize in advance if this is covered elsewhere in the forum. I just couldn't find the right reference.
Thanks for your help.
Richard D. Cushing
Sr. Consultant
SYNGERGISTIC SOFTWARE SOLUTIONS, LLC
October 2, 2006 at 7:27 am
Richard
More information, please. Is it all the indexes on this table, and if so have you rebuilt them all, including the clustered index (if there is one)? How do you know that the indexes are corrupt, and which ones? How are you rebuilding the indexes? DDL for the table and indexes would also be helpful.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply