muthyala_51 (1/27/2014)
Hi,Can some one suggest what should i be looking at?
Concurrency.
The most typical reason two identical environments behave differently (and I do mean identical, down to the data in them) is the variability of usage. Test environments are usually quiet. Prod environments are usually noisy.
My guess is you had a different long running query doing updates or inserts and this one was stuck waiting for it somewhere. The new indexes probably allowed that to complete faster as well. But to determine that, you'd have had to been exploring the blocking chains.
If it was just indexing and no blocking, then you were getting different execution plans. To determine why, you'd have to examine them. It could be fragmentation differences, a change in parallelism... any number of things.
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