As far as I know, there's not any way to specify the order in which a ForEach Loop processes. I think you'd need to use a Script Task to...

What are you using to load the files? BULK INSERT, bcp, SSIS, other?

John

I can't see why 507 is blocking, given that it's AWAITING COMMAND. This is where sp_whoisactive gives you more information - it tells you wait types, wait resources and...

OK, then use DBCC INPUTBUFFER to find out whether blocking or blocked process are doing anything on the PEP database. You'll need to resolve the blocking in order for...

Now i am confused! 18th October 2014? You need to disable DBCC TIMEWARP. Was that the full output of sp_who2 that you posted? You're mostly interested...

Karen

While that script is useful for identifying which are your most expensive and/or most used queries for tuning, it doesn't help with identifying what is running at the moment. ...

Karen

Don't change your log backup interval. The log backups won't stop your processes from completing, so just let them run as normal.

You can use sp_who2 or the Activity Monitor...

Karen

Your log won't be truncated until that transaction is complete. Do you have a long-running job or some other process that's been going for a while?

John

Karen

What does this return?

SELECT log_reuse_wait_desc

FROM sys.databases

WHERE name = 'PEP'

John

Not all spaces are created equal. Maybe they're tabs or something else that could look like a space. There's a function (ASCII or something like that) that will...

Yes, good point. Thanks Lynn.

John

In your expression, there is a space at the start of the string. Is that how your data looks?

John

Oops - double post!

If Simple is involved anywhere then your backup log chain is going to be broken.

Full -> Simple -> Full: take full backup immediately after reverting to Full

Full -> Bulk Logged...

Yes. Either switch to Bulk Logged instead of Simple, or take a full backup as soon as you switch back to Full.

John