25 Things I Wish You Knew About Databases

  1. Oracle will do what you tell it to do. I find that PEBCAK is often the root cause for many issues.
  2. DBAs get paid for performance, but we keep our jobs with recovery.
  3. HA <> DR. If you can’t recover, you can’t keep your job. See previous item.
  4. Memory, CPU, disk, and network are all finite resources. Leave room for growth.
  5. 95% of all workloads will run just fine on modest hardware. Don’t listen to fools that architect crazy solutions for edge cases that won’t happen.
  6. Backups. You need them. Store them someplace safe, and on a different server. See number 2.
  7. Maintenance is mandatory. Find, or make a maintenance window.
  8. But you can always blame the network anyway 🙂
  9. Know the RTO and RPO for your applications. See number 2.
  10. Focus on wait events and logical I/O when performance tuning. They help you find the root cause the fastest.
  11. The only way to know your backup succeeded is to test by doing a restore. See number 2.
  12. Build a recovery strategy BEFORE you build a backup strategy. See number 2.
  13. Baseline for performance. Without baselines and metrics you have no idea if something is truly a problem or not.
  14. Keep your transactions short.
  15. Triggers are awful, awful little creatures.
  16. But NULLs are far worse.
  17. If your DBA can’t work a command line, don’t let them touch your data.
  18. Great database performance starts with great database design.
  19. Deadlocks are often the result of application logic and data access patterns. The engine doesn’t just get “tired” and start deadlocking.
  20. Testing against 10, 100, and 1000 rows is not an accurate test against a production workload.
  21. Application code is responsible for 100% of all performance issues. #hardtruth
  22. Keep as many of your servers configured in the exact same way. This saves time troubleshooting.
  23. Data lasts longer than code. Treat it right.
  24. Don’t install services (SSRS, SSIS, SSAS) onto a server “just in case”. Only install the services that are needed.
  25. If your vendor requires the use of the ‘sa’ account, go find another vendor.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s