Hi ,

I have attached the execution plans for the 2 servers here :

1. Mum plan (Server with better performance of 6 hr)

2. Del plan (I ran this one yesterday but still no out put so I stopped the query and saved the execution plan)

Please let me know if there are any differences in it.

This Job performs an "insert into table" action in the SQL table after fetching the data . The estimate number of rows which gets loaded daily is around ~230000 rows. The same solution is also deployed on the third server but there data is comparatively less and performance is also acceptable. But this 2 servers with similar data shows huge difference in performance.

The H/W (RAM, Processor, HDD and operating system) are same. Apart from this are there any other parameters that needs to be checked from SQL SERVER or H/W side , do let me know that.

Thanks in advance