I was first asked to look at this problem as a database restore was getting an error when attempting to restore the archived logs: archived…
I received an email asking for my help with a production query that was performing badly on an AWS server. Other DBAs had apparently created…
A database that had been migrated to AWS went live and was hitting serious performance problems three times every weekday. I was asked to investigate…
I was asked to investigate a problem with an application which was suddenly exhausting its connection pool. I looked at OEM: That looked interesting. Almost…
Investigation I was not directly asked to look at this, but I was included in an email trail so I took a look. This initially…
Why would performing an index fast full scan 430 times, reading 38MB and getting back 297 rows cause a query to take almost an hour?
The mongodb.log file for it showed connections coming in, but I simply could not connect to it
In fact I could find no relevant errors in any of the log files…
However this is a rather unintelligible long alphanumeric string…
A quick look at the relevant statistics showed why there was such a significant difference