Up to last saturday at 8am this process ran in 20-30 mins. Now it's taking 3 hours.
obviuosly kevin ans sean will give here better idea
something from my side too
sudden performance degrade happens because of sudden activity happened prior. like data migration, cache clean. dropping any index (or even statistics)
any idea if something had happened ?
-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done;-)