I have two notebooks with same specs (same model, only ram is 24GB/32GB, same ssd) and exact same database and same sql server version. SQLIO is 3300 and 3600.
Now I run a query on one notebook and get ~100 reads in the sql server profile and on the second notebook I get ~40000 reads for the same query.
I assume that the index is not used on the second notebook, even tho its there because its the same database (I restored it). The index usage report shows that the index is not used for the same query. The duration for the query therefore is ~100x higher.
How can I fix that?
Update1 4/16/2014, 4:35pm:
When I re-execute one of my 35.000 queries, the query plan shows me that the index is used. Still, I don't understand why the reads are 100x higher, this has of course, a performance impact.