How to Suck at Database Admininstration

This isn’t about having a sucky job, this is about you sucking at your job. There’s a big difference. You could be sucking at your job because you hate your job and just don’t care. I get that. In that case though, you know better but choose not to do better.

I’ve encountered some people that have Senior DBA as their job title but don’t really have senior-level experience. I’ve seen some very questionable things in my career.

Signs you aren’t a Senior DBA

  1. Not checking the databases for corruption
  2. Shrinking databases on a schedule or using auto-shrink
  3. Not knowing what wait stats are or how to use them
  4. Relying on the Database Tuning Advisor to determine which indexes are needed
  5. Using Activity Monitor – I might get some flack on that one, but it’s true
  6. Thinking that 1 FULL backup and 1 LOG backup per day is sufficient for an RPO goal of anything less than 24 hours
  7. Thinking you should set MAXDOP to 1 to avoid CXPACKET waits
  8. Updating statistics after the respective index was rebuilt
  9. Not monitoring your systems – you don’t need expensive monitoring tools to monitor your systems!
  10. Manually doing a task over and over again when it can be automated
  11. Ignoring job failures and warnings/errors in the Error Log
  12. Not checking for high-value missing indexes periodically
  13. Using maintenance plans – I’m okay, though I still dislike them, if you use them for backups or DBCC CHECKDB but not for index maintenance
  14. Not patching your servers
  15. Not trying to improve your skills – don’t rely on your company to send you to training

What would you add to this list? What are the questionable things you’ve seen a Senior DBA doing or not doing?

How do you stack up?

I’ve done many of these things, but I was either a Junior DBA or an Intermediate DBA.

How many of these are you doing? The higher your number is, the less of a Senior DBA you are. It’s all fixable! Spend some time figuring out why you shouldn’t be doing these.

Brent Ozar PLF责编内容来自:Brent Ozar PLF (源链) | 更多关于

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 后端存储 » How to Suck at Database Admininstration

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录