thanks,

if it was more than 1 statement I wouldn't expect to see it multiple times in profiler? (i.e because the statement was in a stored proc I actually used the...

As I said - I'm using sql server standard .. asynchronous mirroring is not avialable in that edition I believe (correct me if I'm wrong).

Can you clarify

Another angle is to...

thanks for your help!

No triggers on the tables.

Yes it is using synchronous mirroring.

yeah I don't think evaluation will suit - it expires and we needs something permanent.

yes thats right

no its coming from a third party application.

The application is returning object not found error along with what the query is supposed to be. The same query gets shown in...

thanks mate - I'll try it out!

1023 rows

ok - I appreciate you assistance anyway:-)

with the script provided - is there anything in particular to look for . I ran the script during high memory usage and low memory usage and I don't see...

yep used perfmon memory.avialable_memory and process.workingset for all the processes - did not see anything useful from that.

(i.e nothing spike in the working sets when avilable memory reduced dramatically).

I thought...

thanks - i'll c what I can do with that.

thanks - I think I might be getting closer.. how do I check that?

I have just been monitoring the all processes working set in performance monitor for a few hours. There has been a couple of times where memory has been upto...

thanks guys,

would perfmon be betterfor checking this?

SCOM is not monitoring this server (wish it was)

Symantec endpoint protection is our av program there is a full scan every monday morning at...