If it's specifically Siebel I will ask the development team which area of the application code they changed. It might take a few days as some are off and some...

Chandra

As I said in one of my last posts, I didn't have to use the traces suggested by Lutz because the development team fixed the problem by basically reverting to...

Gail

We considered backups and there was one running during some of the problem period. But... the backup started a while after the problem began, and finished before the problem cleared....

Thanks everyone for the replies.

I have just been over with the host admin guys (separate roles here) to check disk queue lengths (Books online suggest a PAGEIOLATCH_SH could be...

Jeff

I believe from the development team (although thankfully I don't have to deal with it myself) that the code changed is in an area where customisation is allowed. The problem...

Leo & Lutz

I'd just got as far as collecting some trace data (which showed 31M rows being read instead of a couple) when the developer arrived and said they'd found...

Leo

That's very helpful thankyou.

I'm speaking to the development team now and getting access sorted so I can run the activity myself.

I'll set up a trace with the events...

Leo

Yes this is what I meant - sorry if I've bodged the explanations so far.

Taken out of the application the sql is ok. Within the app there is extra...

I'm afraid I can't get the full details at the moment as work is (or at least should be) over for the day and I would need to set up...

Thanks Leo

I appreciate that's how a cursor works (but given my original post thankyou for the explanatiion) and I've also seen a fair bit of advice saying don't use them....

Was off yesterday afternoon but come back to some useful replies. I'm glad it's not just us doing things using code, I was starting to feel a little antiquated.

Thanks all...

Ideally I would like to implement the code as it fits in better with our infrastructure - specifically we can have one script which is version controlled and implemented automatically...