Following in Tim Ford’s (blog|twitter) footsteps, I also went non-technical with my favorite post for this awesome twelve days of SQL, which is one of Brent Ozar’s (blog|twitter) collection of bad great ideas that I’m very honored to be a part of. I struggled to pick a favorite for this series since, well, there are many of them and it’s hard for me to just pick one, but I hold this particular near and dear to my heart since this is a simple fact that we all know, but sometimes overlook (me included).
This post serves to remind me that, as a Production DBA, I need to be aware of everything that touches my servers and databases. I’m not talking about fancy Change Management process (that could be a separate post on its own) but it’s the awareness that other groups sometimes don’t have, or hey, sometimes we as a DBAs forget too.
I’m talking to maintain a centralized log about every change that happens on the server.
Don’t get me wrong, this is not just a need to keep track of the things we DBA’s and our developers do, we also need to be aware of other teams small tweaks on the server or network, such as, oh I don’t know, replacing the network card or swapping the processor, or something silly like that. Even subtle difference like changing the network cable or plugging it into a different switch port can have huge impacts and I need to know! For the network or sysadmin teams, that might be nothing, but that could have huge impact to our DB performance if we are not aware of it. Ever try and troubleshoot a port speed mismatch without the support of the netadmin? Or that pesky (but well intentioned) SAN admin who thinks you can do just fine with a RAID5 instead of a RAID10? Not to mention tools are almost designed so that notification is an afterthought, that SAN admin can do the whole thing on-line without your knowledge and there is no down time, huh. Did you ever think the marketing hype of “no down time” would be abused? How many times have you heard an admin claim, “no one will know” only to hear help desk phones start ringing without warning? Subtle changes can make a big difference in the big picture, and don’t even get me started on load testing in the test environment. Anyway…
Without further ado, here’s the post:
Coming next, a dear friend of mine who I met in person during another of Brent’s bad idea, SQL Cruise. Karen Lopez (blog|twitter) is incredibly talented and has an ocean of knowledge about database design/architecture. She’s very active in the community, a renowned speaker, an icon for Women in IT and an awesome person to hang out with (even at a character dining in Disney.) Please check on her blog tomorrow to see what her favorite post of the year.