O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2: Tuning the Environment

In This Chapter

arrow Seeing how to survive system failures

arrow Tuning your recovery and operating systems

arrow Getting the most from your hardware

arrow Introducing new hardware

arrow Understanding multiprocessor environments

Computer systems are subject to all kinds of failures: power failures, hardware failures, operating system failures, application program failures, and even database management system (DBMS) failures. These things happen; you can count on it. The important question you should ask yourself is “What happens when a failure occurs somewhere in my environment?” In critical applications, you don’t want to lose any data, and you don’t want to lose any more time than absolutely necessary.

Failures aside, you want your system to run as efficiently as possible. Inefficiencies can hamper productivity in many ways, sometimes slowing it to a crawl. In dealing with both failures and inefficiencies, the key to optimizing performance is tuning each part of your system. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required