As good little DBAs, we should be gathering baseline statistics for our database servers. These stats can give us insight into what’s changed when performance is suddenly in the toilet. They can also provide a basis for determining what systems can be consolidated, downsized, or virtualized, which has become quite the topic of discussion with […]
If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are reserved for data, logs, and tempdb. So it’s up to us squeeze every last bit of performance out of our backup jobs. If you’re using maintenance plans to do your backups, chances are you’re not […]
So what have I been up to? Well not writing blog posts, obviously. Everybody Panic!!! Really though, I haven’t exactly been slacking off these past couple weeks. As you may recall, one of my goals this year was to present at a SQL Saturday. To help me towards that goal, I have my very first […]
I’m happy to report that some progress has been made on my performance problem. I’m still working on it, and there will be a full progress report to come, but for now I’m simply happy to say I’ve gotten somewhere in the EXECSYNC dept. Now, that’s not to say I’ve gotten rid of them, but […]
Ever have one of those days when you feel like you know absolutely nothing? That pretty much sums up the past week for me. I’ve been fighting with a performance problem and have come up empty on all fronts. WTF? We’re in the middle of a project to upgrade one of our financial databases. The […]
