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. ...

Get SQL All-in-One For Dummies®, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.