Hi All,

I am running a simple query (Insert into tbl Select a, b, c, from ....)
with some 4 joins concurrently on two different servers. One server has
been created from the backup/restore of the other one. The original
server runs the query in 10 mins with no major impact on the transaction
log. The second server is taking more than 4 hours and increases the
size of the transaction log from 2 MB to 85GB in the mentioned time.

How do I troubleshoot this problem.

Any help is appreciated...

Ankush

MS Sql Server LazyDBA home page