Have you seen the latest show? (It’s free)
SelecTViews – Interview with Kalen Delaney, author of SQL Server 2008 Internals. We also have news about Hitachi Data Systems purchase of BlueArc, the upcoming PASS Summit 2011 and more.
[Watch the Show]
Are You on Auto-Pilot… and Should You Be?
In our upcoming show I get to talk about getting back to the basics and re-re-rechecking your systems for the essentials. I wanted to throw this out here too –
Are your systems largely on auto-pilot, and if so, should they be?
I’ve talked to a surprising number of people and we’ve found an odd trend. In trying to diagnose issues that have started showing up, we’ve walked through the usual suspects. Performance tuning, tweaks, changes to schemas to try to optimize, all sorts of fun things chasing down an issue.
The surprise?
Finding out that things that were automated, thought to be happening all the time as needed and long-left to the systems, had, well, issues. These aren’t always big things. Perhaps it’s an index maintenance script that runs, or an archiving routine to lighten the main processing table load. For whatever reason, these basics weren’t firing and doing their job. They’ve been successfully running for so long that no one thought to check them first. We automatically went to more dramatic tweaks.
How are your systems? Is everything on auto-pilot? Have you ever run into problems keeping those basics going? Drop me a note, let me know how you’re approaching it. Email me at swynk@sswug.org.