Sorry, didn't register that you're using adhoc sql generated in the app. If that is the case perhaps consider using sp_create_plan_guide which should work quite well with your unknown WHERE...

Grant did u see the app?...

Edit: Sorry, didn't register that you're using adhoc sql generated in the app. If that is the case perhaps consider using sp_create_plan_guide which should work quite well with your unknown...

DBCC DROPCLEANBUFFERS should only get run as a test. That removes all the data from memory. Based on the queries you've shown, compiles aren't your issue. You're looking at memory...

The only time an adhoc plan will be reused is if the sql matches exactly to the one that create the plan. Exactly meaning down to the white space and...

Thanks SQLGuru

So there's no way to enforce the READ UNCOMMITED at a system level?

I don't have any control over what the devs write in their ad-hoc queries. So, it...

Can you tell me how much investigation/study did you do about snapshot isolation prior to asking that question? At 1k/sec DML activity it is my guess that...

Will do ...thanks..

While I'm here would there be any benefit to me using

snapshot isolation?

While doing my testing (inserts are active) i was getting deadlocks and kicked out.

So I added the NOLOCK, that stopped the deadlock errors..so then..

I removed all indexes, and created a...

Thanks Matt,

I was kinda thinkin I may create a simple VB front end, and write a proc or two.

Oh I see what you are saying..thanks Gsquared

I think I can get a pretty good list of the kinda stuff they query the most, but...

It does have a timestamp, I will try that.

THANKS MATT

Is there some way I can force/require them to use a date (or date range)?

Thanks Grant,

I'll experiment with both those options and look into using 08.

Thanks for answering Matt,

Yes this table is kind of a troubleshooting table. So, there are techs that need to see real time info.

I was trying to think of a...