The Great DBA Series [Part 2]

    By: Jeffrey Ross Garbus on Feb 04, 2013

    Readers who want to refer to Part 1 of this piece will also find Jeff’s definition between production DBAs as being responsible for making sure the system stays up, stable and in many places, scalable – and development DBAs, who work with development teams to design databases, initially tune queries, scale systems, and perform initial predictive analysis. In Part 1 Jeff also covered typical work tasks, preventative maintenance, transaction log backups and validation of database consistency.

    Application Performance
    Do you know how to identify what application components are running slowly? When users call and complain about performance, where do you look? Where are the bottlenecks? Is it CPU, memory, disk, network? Even after you’ve identified the component, what is causing the CPU to spike? Answering these questions can be... nontrivial. A common mistake here is to “throw hardware at the problem,” which will not help, may or may not mask the problem for a short period while it snowballs out of control.

    Login to read the article. Not a member? Create a free account!

    Released: February 4, 2013, 9:15 am | Updated: January 31, 2014, 9:34 pm
    Keywords: ASE DBA Article | Technical Journal | Alvin Chang | ASE | Data Management | Data Storage | Jeff Garbus | Lyle Fernquist | Performance & Tuning




    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk