balasach82 (8/30/2015)
Its a new Win 2008 R2 box with 128 GB ram. SQL is allocated about 4 GB (min) max (61 GB). Thsi configuratin is much higher than what we had in SQL 2008 (win 2003).Yes, stats are uptodate. There are 1 or 2 indexes only which doesnt have much frag.
Canyou post the actual execution plan?
😎