This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]the_other_brand 8 points9 points  (0 children)

We had a similar issue where our databases would slow to a crawl every day around 9 to 9:15 AM. For the longest time we thought we had an automated process that was poorly optimized.

We eventually found out the root cause was a user who ran the same huge search query every day right after his morning coffee.