thanks for taking a look, yeah I would like a cleaner solution.

We have about 40 views over this table and have the potential for this to cause more problems.

It does...

it looks like informix has an ado.net provider, you should create a new connection and look for that provider in the dropdown list. Or create a DSN and use the...

I got it, there is no issue...

an order by clause on the outer query reveals the problem. :angry:

so basically the query returns rows in the most efficient way and...

Ok here is the full statement.

SELECT *

FROM (SELECT cd.empid

...

would adding a manual checkpoint after each batch slow things down considerably?

Also please suggest any code changes if you want to take the time.

ok I ran the checkpoint and log reuse is 0 now

Also I tried to run a shrink this morning and it failed, guessing that was also due to the log...

here is the proc that does the deletes:

I'm mostly curious why the log wait is indicating a backup /recovery is in progress. For all I know it's said that for...

well I'm assuming that is what it said last night but not sure, there was a differential scheduled for 4am today. but I can guarantee there is no backup/recovery happening...

is this server 2008? did you check the machine.config security?

C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG

Our sql server when they came from our tech group had machine.config locked to admin only, this needs to be all...

Check the windows application event logs as well. You might also consider running Process Monitor during the startup to get additional error info.

After reading this http://msdn.microsoft.com/en-us/library/ms151198.aspx replication would appear to be a valid solution.

My concern is the synchronization, guessing that can be controlled and the replica would be able to be manipulated...

OK, found a very simple solution to this.

I was confused originally since I thought jobs ran under the context of the job owner and my job was clearly running...

Look under MSDB at the roles db_dtsltduser,db_dtsltduser,db_dtsoperator, research and find the right one for you proxy.

Also dont forget to give reader on your config database, if you have one,...

Thanks for the replies. since we've implemented more file size monitoring we are now more aware of changes. Like you said probably best to base line it before making any...

OK, so I added the 2 indexes you suggested and the performance was the same for run time.

But, I then deleted my original index from the parsed message table and...