Tag: workload

Blogging at SQLPerformance.com

  By ,

I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC) I will be writing occasionally for the site. You can catch my first blog post It’s Not You It’s Me (I/O Troubleshooting) through simple changes. SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, they cover both the “how” and the “why.” Continue Reading

The Shield

  By

How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are always saying no or they have to wait? I know many DBAs that have this reputation. To avoid this, I use my manager as a shield and suggest you do too. As a Lone DBA, with an extremely full plate, I learned that having that shield is necessary. It prevents me from being seen as the bad guy and protects me from work overload. We all experience what I call, “Drive Bys”, when people are asking for stuff on the fly. Telling someone… Continue Reading

Admit You Can’t Do Everything

  By

As most of you know, I have been a Lone DBA for 15+ years and during that time I have learned a thing or two about how to survive on my own in relatively large environments.  One of those things is knowing when to admit you cannot do it all.  Working alone on 56 servers you can imagine how the workload can seem insurmountable.  There are times when in one week I will do 70+ tasks, not including project work and daily monitoring.  To manage and get this type of workload accomplish you have to learn to work smarter not… Continue Reading