Ok I have ran checkdb and the results show no errors:

DBCC CHECKDB (MyDatabase) WITH all_errormsgs, no_infomsgs executed by JoeBloggs found 0 errors and repaired 0 errors. Elapsed time: 0 hours...

Ok thanks for your reply.

Ok I'll try those tools then. Thanks very much for the replies - much appreciated 🙂

Would you say they are high given the numbers I mentioned ?

Any pointers on how to investigate why cached plans may not be being reused ?

Thanks for the advice guys.

I'm not to familiar with extended events in sql2008r2 - so if you have any good pointers on how to use them then great. I have...

I'm running a query to test my indexes that shows me the 'total number of queries which read' and 'total number of queries which wrote', together with reads/write ratio. All...

The error message is very vague. It just says it failed to execute a stored proc that the package calls. I can't be more specific at the time of posting...

Ok thanks Gail.

Looks like iv'e missed the boat then as the default trace is not going back to the day I need.

thanks Grant 🙂

The bit about the leading edge of the index always confused me, but I think you've just cleared that up !

Thanks Gail. That makes sense then and I think I have found out why we had the slowdown - because it looks like we had disc io performance issue on...

Grant - thanks for clearing that up.

Thanks everybody !!:-)

Lowell - should i be resetting the wait stats dmv's at the start of the day ? I don't think I currently take that step !

The job runs right...

Yeah I also exported to a script and that did the trick also.

Thanks Grant.

Guys - I think i have worked this out !

The option to 'Deploy Data-tier Application' is available when you right click the instance and not the database node.

This should...

ok thank you for your suggestions.

I had a feeling I'd have to re run the snapshot which isn't really a problem because it runs in a matter of minutes as...