FYI,

http://support.microsoft.com/kb/970399

Need SP1 CU3 or higher

http://www.piriform.com/defraggler

Will allow single file defrag too

I appreciate the feedback.

Check this out, could be related to the memory leak

http://support.microsoft.com/kb/971622

that error of yours does look like what you'd get if the db is in compatibility mode 80 or lower

you might find this helpful

http://www.sqlservercentral.com/scripts/67088/[/url]

http://support.microsoft.com/kb/970399

This problem occurs because the query optimizer ignores the option when it is set to a value larger than 1. Therefore, the estimated degree of parallelism computation does not include...

http://support.microsoft.com/kb/329204

In SQL Server 2008, if MAXDOP exceeds the value that was configured by using the Resource Governor, the Database Engine uses the Resource Governor MAXDOP value. All semantic rules that...

Thanks again,

I've disabled the daily dbcc checkdb, now running weekly, and we will see if this resolves the issue or not.

Thanks Guru,

There are no other jobs running for a 1 hour or so before or after. The backups are running about an hour later.

Perhaps it's a user recompile statement...

unable to find any articles stating schema version changes will occur with dbcc checkdb

http://msdn.microsoft.com/en-us/library/ms190918.aspx

blurb about lazy schema validation

Thanks, but I'm thinking that's actually going to run a bunch of db shrink commands at the same time...which is the problem I'm looking to address.

Not sure if wrapping each in a BEGIN TRAN / EXEC TRAN will work b/c it's a dbcc command...

https://connect.microsoft.com/WindowsServerFeedback/feedback/details/561750/2008-failover-clustering-failover-unsuccessful-when-nic-disabled-or-public-network-disconnected