just uploaded

tried yours and I had tried something similar will not give up the scan

Duh missed the obvious the first table only has 2 columns which are part of the clustered index time for a captain obvious

3rd party app no choice can't change code can change indexes

It returns 71 (reads 2.8 million in scan). Tried using non clustered on all fields in table in different variations, best I could get was a non clustered index...

tried that still loves the clustered index scan

I believe at one of the Microsoft sessions here in St. Louis it was also mentioned that statistics for querying the RO node also was stored in tempdb

the date on machine.config does not match with the day the problems happened it is 2 weeks before

This is actually all the shows up in the logs

The SQL Server Integration Services 11.0 service failed to start due to the following error:

The service did not respond to...

It ended up being a storage issue and VMOTION. The fact that someone P to V'd these active/passive clusters is part of the mess. Only one node came...

thanks the upgrade path has been clear there are a few unclear articles I have seen which seem to question whether or not you can do an in place edition...

couple of memory bugs that 3rd party vendor wants us on r2

Preaching to choir Not my argument, server is DWH server has to last me 6 more months and hit memory limit with 2008 standard.

Found it and the issue, in our VMWARE servers they have compressed C drive. Can't do that sql errors out. Saw this once before

going through blitindex also, results from same db on 2008 and 2012 are pretty significant.