O'Reilly logo

Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition by Craig S. Mullins

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

10. System Performance

A poorly performing system can degrade the performance of all databases and applications deployed on that system. No amount of database, application, or SQL tuning can improve performance when a poorly implemented system is causing performance problems. Applications access databases and both are implemented on an overall system environment, as shown in Figure 10.1. Therefore, a system problem can cause all databases and applications to perform poorly, just as a database problem can cause all applications that access that database to perform poorly.

Image

Figure 10.1. The tuning boxes

A system problem can cause all databases and ...

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