Database maintenance

Database maintenance

Here's a SAP screen that will tell you a lot of information about your database:

Transaction DB02 => SPACE STATISTICS => TABLES => OK => HISTORY => ALL OBJECTS ON/OFF => MONTHS

Whew! Okay, now click on the numerical entry under SIZE TOTAL, then click the SORT button - you've just located your largest database tables! A great beginning to an Archive project. Just jump into DB15 to locate which archive objects go with those big old tables.

Now double click on that monsterous table - see how it's growing every month? Wouldn't your management love to see the growth patterns of your largest tables? You know they would!

Now arrow back. This time sort on the numerical entry of EXTENTS TOTAL - look at all those tables that are reaching their maximum extent limits - why isn't your DBA reorganizing those tables!? If he did you would see an increase in performance! And while he's at it have him look up which table indicies need reorganizing also - everyone knows that inserts/deletes mess up b-tree index balancing, and that running an index optimizer process (like update statistics) will only help so much. Table and Index reorganizations can be easily done through the SAPDBA utility.

There ya go - do some simple database maintenance and watch your performance go up! Have fun SAPin'...


    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

This was first published in March 2002

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Back to top