First thing to do is generate a query plan on both servers and see
what's (if there is) the difference... "CTRL-L" is your friend. ;)


-----Original Message-----
From: Ankush Sharma
[mailto:mssqldba-ezmlmshield-x26527667.[Email address protected]
Sent: Friday, March 30, 2007 2:32 PM
To: LazyDBA Discussion
Subject: Transaction Log filling very fast

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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



------------------------------------------------------------------------------
NOTICE OF CONFIDENTIALITY
The information contained in this communication and any accompanying document(s) is proprietary and confidential and is intended solely for the above-named individual or entity. If you are not the intended receiver, recipient or entity, you are advised that any distribution, copying, disclosure or communication of this email is strictly prohibited. If you have received this email in error, please contact me at the telephone number listed above or 858.716.1500.
==============================================================================


MS Sql Server LazyDBA home page