Nope. unfortunately not.

Wayne - Those history tables have around 4-5k records...

Just to update that we found the issue. Batteries of one of the controllers had failed. the read/write cache was disabled and hence the slowness and low disk throughput. it...

aah.. got your point. i thought you were trying to move the "zipped" file to a target location.

I'll assume your .zip files will stay on the current location for some...

Ok. this is what i found on net.

modified it a bit.

Dim oFS, oFile, sFile

Set oFS = WScript.CreateObject("Scripting.FileSystemObject")

Const sSourceFdr = "C:\test1\"

Const sDestFdr = "D:\test2\"

For Each oFile In oFS.GetFolder(sSourceFdr).Files '...

shew (9/21/2010)[hr

From my testing, a seperate "move job" makes no difference. My issue is that I cannot tell "when" the zipping is complete. Consequently, there is the risk of deleting...

Jeff Moden (9/21/2010)[hr

Yep... I pretty much got that from the OP, Pradeep. I'm just trying to figure out a work around without using any 3rd party software so that...

i would have done...

read Gail's remark:

Thats the...

danfugett (9/20/2010)

---

In all fairness I have known in-house DBAs who fail to provide the level of service mentioned previously. My question is whether the company in question holds their...

take a note that running traces (even server side) will cause a performance degradation.

Good writeup. but i guess u did a typo by writing perfmon instead of...

Jeff Moden (9/20/2010)

---

Ah... that may be the key. Is there any problem with you just zipping one file at a time instead of putting a bunch of files in...

Google!!

You can start here: http://technet.microsoft.com/en-us/library/ms175047.aspx

Run a server side trace. Use profiler to script out the trace definition. Doing it manually can be error prone.

This article of Gail will help...

The file may be in middle of copy and hence u got this error.

if not, take help of windows admin guys who can find the handle to the process that...

mail4sha (9/20/2010)

---

actually in every SP i have to make a log entry of every tranction done within the SP. i have to log both success n failure of transaction.......