JeepHound (8/8/2014)
Thanks for the flame, now I know why they call you evil:-D
Now now, not exactly a flame. 😛 Certainly not aimed at any one of the particular people above me, just the methodology. It seemed to skip the first steps, at least as I perceive them.
All the answers given are relevant to the initial conversation, period.
A perfectly fair statement. It's a branching logic tree though for me as to where you go from there. Example: Sometimes the 3rd party app has to have SA as per the contracts. You can't do anything about that (other than stick it on an isolated instance). Sometimes they've decided to run poorly implemented ORM, so you can't run FULL recovery without a few hundred gigs worth of tran log space.
I just get concerned about open ended questions like this. It's too easy to just take a list, bring it to a meeting, and not understand all the different concepts that goes behind every question you need to ask.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA