Jeff Moden (8/22/2012)
I guess a question on my mind at this point is why anyone would need a 200GB TempDB.
It's unfortunately not hard to need it on an overly active system that's utterly out of scope and you're not allowed to fix it. Between table spools for sorts, RCSI, reports being built off the OLTP system, and any other number of things you can slam a TempDB FAR too easily off a half a tera database. I'm staring at one that does it daily.
Vendor DB, of course. To the vendor's credit we ARE two versions behind and they've stated they never expected the system to handle our volume.
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