Corrupt DB Table but no error messages!

[oublie]

Hi,

I've just had one of the strangest errors I've yet to encounter. On of our systems has about 2000 connections and yesterday the users reported that the system was running slow. Checked the DB no errors, DBCC check Table etc still no faults anywhere on the system. Admins checked server - no faults, Network guys checked user network and server connections - no faults, lots of head scratching. Narrowed problem down to a specific table being used by a stored proc that was causing the problem but that table had no issues. Ran query, it constantly timed out i.e. corrupt table. Recreated the table and problem was resolved. The question I have is has anyone experience this and if so how come checktable showed nothing and is there a more reliable way to check for such a problem? Thanks for you help.

 

[nigelrivett]

Are you sure the table was currupt?
Did you try clearing the plans out of memory and updating statistics, checking locks, rebooting server...
Is it just that query or access to that table that caused problems

I've had this sort of thing happen before but very rarely and usually when people are playing around with object IDs when the system is online..

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[oublie]

yes, yes, yes, yes, no reboot as system is critical to multiple applications and linked servers. The system was live when the problem occurred but nothing unusual was happening on SQL.