thanks buddy

e-mail id is-----

priyank.saxena@hcl.in

thanks ;

just want to confirm if this tempdb.ldf is transaction logs for temporary SP's and DML between a Begin and Commit/Rollback on a temporary objects etc.

Size- 108874.88 MB

Code-

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

/********************************************************************************

ALTER PROCEDURE [dbo].[sprFinData_Batch]

AS

BEGIN

SET NOCOUNT ON

SET XACT_ABORT ON

BEGIN TRY

...

sorry but I can't understand!

actually when job is run after that when we see on server there are 2 .ldf files one is around 45 GB and other is 5 GB

and surprisingly it creates...

Hi,

DB LogSize(MB) LogspaceUsed(%) Status

SVIDB4.984375 21.37539 ...

Thanks!,

I have checked DBCC OPENTRAN but there is no opened transaction .

Any other thoughts?

Ok fine ,

can you pls tell me 3 or 4 general steps to optimize the Job

Can we break the code thru SavePoints or can we braek the job in 5...