CHAPTER |
|
20 |
Performance Tuning |
In This Chapter
• Factors That Affect Performance
• Choosing the Right Tool for Monitoring
• Other Performance Tools of the Database Engine
Improving the performance of a database system requires many decisions, such as where to store data and how to access the data. This task is different from other administrative tasks because it comprises several different steps that concern all aspects of software and hardware. If the database system is not performing optimally, the system administrator must check many factors and possibly tune software (operating system, database system, database applications) and hardware.
The performance of the Database Engine (and any other relational ...
Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
