One thing to be sure of is to get the actual rather than estimated execution plan since there is usually a big difference. Another, method of determining what is going on is to use SQL Profiler and run a trace to see what is using up server resources. Perhaps some other process on that server is taking resources and slowing down your query.


Keith Risman M.S, MCDBA, MCSE, CTT

---- Gordon Rayburn <mssqldba-ezmlmshield-x52580613.[Email address protected] wrote:
> 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