However, the number of child cursors built back up rather quickly …
The errors in the alert log were far more frequent than the database hangs, so clearly there was another factor involved …
I therefore felt a bit sheepish that I had been investigating what was apparently not the real problem …
What was happening was that when parallelism is used the optimiser can decide to use a high level of dynamic sampling.
There were all kinds of errors in the log, but the one of most concern was …
This is more by way of amusement than an actual investigation. I had been asked to monitor a test of a new piece of application…
Whilst I was away on holiday, the primary query in a particular batch process changed plan. An appropriate baseline was create for it but this…
I was asked to look at this problem as it has been going on for a number of hours and several other DBAs had been…
I was asked to look at the a UAT database as it was performing slowly. I asked for some details of the slowness and was…