Over the years when a performance problem comes up there is always some speculation that it’s a network issue and not the database (can’t be us!). I always ask a few quick questions to see if I can see a reason to pursue the network angle: Is the problem affecting multiple database servers? Is the […]Read more "Sometimes It IS The Network"
Most of you probably get that there will always be a bottleneck in a system. You implement a fix in one place, now something else becomes the constraint. The hard lesson to learn is that there is point of diminishing returns on optimizing (anything). Doesn’t mean you should stop, just that you should think about […]Read more "Moving The Bottleneck"
There’s a tendency to think all problems can be solved with an index or two (or partitions, or other performance trick of your choice), but sometimes the answer is to not do the work to start with. Sounds Zen, but it’s often a matter of caching in the write place. It’s a technique I’ve used […]Read more "Indexes Aren’t Always the Answer"
We put this together last year and we’re up to 270 blogs listed, but I’m sure we’re still missing some, and some have changed names (including my own). If you’re a blogger, take a minute to check that we have the right information. And if you’re a blog reader (surely you are!), grab our OPML […]Read more "Help Us Update the PASS Blog Directory"