kidly pass how to resolve this.

I have an application running on SQL server, with same set
up on other server with higher hardware set up mainly
double the size of memory. When I run script generated
from application to reconstruct database it takes 5 to 10
hours on one server on the other server which is with the
lower memory, the same task takes more then 2 days and
then server hang.
During this process tempdb grows form 5GB to 100 GB and
cpu uses remains 100%. this do happens on other server,
tempdb grows but not this much, cpu use 90%.

I have checked query generate lot of select,joints,where
and updates.

Is there any configuration or parameter matters other then
sql query.