A nice case study about ‘how to kill your app?’ was published under High Scalablity. I strongly recommend this reading. Not only for NoSQL fans