October 3, 2011 Leave a comment
Well my last project had some nightmarish moments, like getting called at midnight for a minor problem, or having a 2 am conference call.
But one developer really took the cake with the question-“the database is slow”. After looking at wait stats and finding nothing (it turned out to be a network/app issue-too many round trips), I gave the instance more memory. And wrote back saying I thought it was an app problem.
His response-“did you increase the performance in the database yet?”