My own story:
I was devising a sort of demographics program, and while planning how it would work, I visualized all of the different kinds of people and their relationships to each other. The quick and dirty is that I was trying to hold the basic data and the relationship structures for every person in the US in my mind at once.
The effects were similar to early-onset dementia. You know the absent-minded professor trope? This was that on steroids. I forgot to cook the chicken one night. Luckily, my girlfriend instinctively refused to eat a raw, frozen chicken breast. Then I couldn’t recall her name, and never you mind that we’d been living together for over a decade. I was becoming a hazard to myself and to others.
ETA: and my girlfriend’s favorite symptom–I would repeat the same thing two or three times in our conversations. She was really getting scared for me.
But it was only a problem while or immediately after I was turning the data over in my head. Distract me with something else for fifteen minutes, and I was back to normal. Though, during that period, I could not recall what happened on the last episode of any of the TV shows we watched together. I had to rewatch whole seasons of some of them.
I’m sure that I didn’t actually exceed my brain’s “memory limit.” And (if we’re continuing the comparison to computers), it was probably more an issue with the CPU than with the RAM. Or maybe it would have been closer to bad database indexing or even disc access. The memories and the knowledge were still there, but for whatever reason, I could not always access it.