Another question. Is the recovery interval set to zero? If it not, then SQL will only shrink down transactions within the available time window. (even when set to...

Maggie,

Is the tempDB log database set to a simple recovery?

can you send an example of how you are executing the proc?

Also how you actually execute the SELECT manually might point out the problem. I'm curious if...

I believe the following would suffice:

select count(tel1) + count(tel2) + count(tel3) from table1

My guess is one of the other fields does not exist. You are checking the CLIENT_ID field but you are not checking the other fields. Are you sure...

How you implemented it is how you do it.

🙂

I'm not overly familiar with the PREEMPTIVE waits, but the LAZYWRITER_SLEEP is just SQL waiting to run the next checkpoint.

Have you tried running sp_who2 during this time?

i believe you are looking for the datediff() function.

Try this:

DECLARE @LastRun DateTime

select @LastRun = max(sitDateTime) from mfSitPosition

if datediff(mi,@LastRun,getdate()) > 30

BEGIN

EXEC yourstoredprocname

END