Thanks all. I downloaded a trial of Quest Benchmark Factory and started to have a little play. I will carry on playing with this, but i was pleased...

Thanks again, this is all really useful.

We will have a dedicated SSRS server (one day!) and this may need to be Enterprise Edn then from what you say. We'll...

Thanks all for your replies.

We have a combiniation of 3rd party and custom apps and the 3rd party vendor in this case (and in many of our other examples) has...

Great, thanks for this, it gives me the confidence to go through with this new approach. The agents do indeed run in continuous mode and we do have the...

If i was to look at a transaction log, say for one particular transactions, what would I see?

Taking a data update as an example, I was once told...

Thanks for your reply.

We got our power back and switched on node 1 and luckily there were no ill effects as you antipated. The cluster resources and...

If anyone is interested, I didn't get around this problem. I temporarily gave the consultant SA privileges!

An update of the user system table to marry up the SIDs following...

Oh yes, thanks. If you CROSS JOIN the sys.dm_exec_query_plan DMF to sys.dm_exec_query_stats you get a dbid. A bit of experimenting reveals that ad hoc plans don't seem to...

Thanks, these seem sensible suggestions for me to try. It's also useful to know there's no really obvious script possible so i can stop trying!

Cheers.

James

It looks like the kind of behavior I want - consistently reinitializing only articles that have changed as opposed to all articles - would come about if I make my...

Thanks very much for this. Very useful.

Thanks for this, very useful!

Many thanks for this. It makes sense now, especially when considering the limited memory example.

Cheers.

James