Viewing 15 posts - 361 through 375 (of 994 total)
These are broken links to statsistics blobs. If you DBCC PAGE the pages referenced in the errors, you'll be able to see what indexes the stats are for. Then try...
June 23, 2009 at 8:30 am
No - it's nothing to do with clustering - it's the I/O subsystem. Possibly bad memory on the primary node. Can you run memory diagnostics on it?
June 22, 2009 at 6:58 pm
This looks exactly like a stale read issue from an I/O subsystem controller. It's definitely the data files that are corrupt, not the log file.
June 22, 2009 at 9:50 am
Yeah, that's a little high 🙂
June 18, 2009 at 11:13 am
Do you have page checksums enabled for the database? Are you seeing 823 or 824 errors in the errorlog? These would be proof that it's the I/O subsystem and avoid...
June 18, 2009 at 10:50 am
These two errors together lead me to believe there's something wrong with your I/O subsystem. The CHECKDB issue is caused most commonly when the I/O subsystem is overloaded (can you...
June 18, 2009 at 10:30 am
Yes, if that solution works for you.
You also need to investigate why this happened. Torn-page commonly happens when the server loses power and some component of the I/O subsystem fails...
June 17, 2009 at 7:47 am
June 16, 2009 at 1:42 pm
ok - will do. It's lunchtime - nothing else to do 🙂
June 16, 2009 at 1:24 pm
That page has been corrupted (torn-page is usually from power-outage - did that happen?) and is not recoverable. You've got two choices - restore from a backup (possibly even a...
June 16, 2009 at 12:34 pm
You don't need to use DBCC SHOWCONTIG for databases in non-90 compat modes. As long you run the DMV script in a database that's in 90-compat mode, it'll work fine...
June 16, 2009 at 11:15 am
June 16, 2009 at 8:21 am
Be careful running a script like this that touches all indexes on all databases. Even though the LIMITED mode is only oging to read the level of the index above...
June 16, 2009 at 8:18 am
Nope - that can't happen with DBCC in 2000 and beyond. It's stale read issue on your I/O subsystem, or something similar, or you're doing something and by the time...
June 12, 2009 at 9:18 pm
Viewing 15 posts - 361 through 375 (of 994 total)