I compared the execution plan and there seems to be no difference. Also,
I observed that the tempdb fills up real fast at first and then the
transaction log fills quickly on the server in question. This situation
does not happen on the master DB.
Ankush
-----Original Message-----
From: Gordon Rayburn
[mailto:mssqldba-ezmlmshield-x52580613.[Email address protected]
Sent: Friday, March 30, 2007 2:40 PM
To: LazyDBA Discussion
Subject: RE: Transaction Log filling very fast
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.
========================================================================
======
---------------------------------------------------------------------
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
MS Sql Server LazyDBA home page