In the procedure they are deleting values before a particular date.

Values are deleted from a master table and inserting into a another table.

Smaller chunks in the sense changing the date...

Thanks a lot Gail.

What i need to do to resolve this high space usage in this case?

Thanks Gail.

I was under the impression that only BULK LOG=minimal logging

Thanks Gail for the reply.

We have a proc from developers to delete around 700 millions records from a table,this caused database log files to grow very high that the disk...

Thanks Everyone.

Do we need to take any kind of backup when changing database recovery model from SIMPLE-->BULK LOGGED-->SIMPLE

Also please let know whether its necessary to take these backups after changing...

Thanks Kevin,

Ours is a small organization and cant afford consultants at this point.

Thanks Gail

Dev team is running around 37 .dtsx files. In job they are calling the main .dtsx file which in turn calls the other files.

What can be the cause for this?

Checked for processes having huge wait time and they are jobs calling SSIS packages with waittype RESOURCE_SEMAPHORE.

Thanks Gail,

Can you help me in identifying the processes using tempdb?? Some SSIS jobs running and its showing they are using user db.

The procedure is used to take CPU statistics,backups,update statistics,shrink ,fragmentation etc.

These procedures i think created by DBAs but extensively used by developers.

Got the above waittypes but CPU never reached more than 70%.

The server is a vmware machine with 36 Core and 9GB RAM.

Thanks Gail,

Actually its SSIS packages running behind .

Some queries used are

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dba].') AND type in (N'U'))

DROP TABLE [dba].

Thanks Anthony