Home / Archives For Thomas LaRock

Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Microsoft Data Platform MVP, VMware vExpert, and former Microsoft Certified Trainer. He has over 20 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.

Why DBAs Should Take A Minimalist Approach To Performance Tuning

When I was new to my role as a database administrator (DBA), I believed that everything could be faster and more efficient. I spent my days performance tuning, to ensure that queries wouldn’t take a second longer than necessary. I even hoarded metrics—collecting all the data I could, not knowing whether it would come in useful one day. I soon realised that I was afflicted with what is called Compulsive Tuning Disorder (CTD).   In my case, CTD wasn’t a problem when I started my role, it even yielded results. My end-users enjoyed applications that ran faster, and happy end-users made for happy managers. Unfortunately, your early days as a DBA are rarely indicative of how the role pans out. While you may start with enough time to do all the tuning you want, soon you’ll need to tak...