• well it sounds like an io wait .. use the function sys.fn_virtualfilestats to see what's going on initially.

    the partial script you've pasted doesn't look like it's written for sql server - commit without begin tran won't do very much one way or another.

    you might want to check for open transactions - that might cause issues.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/