Performance Tuning and Optimization
Performance tuning is the process of modifying a computer system or software in order to make the entire system or some aspect of that system run faster. Optimization is the process of modifying a computer system in order to maximize its efficiency. Performance tuning and optimization are a regular part of administering a SQL Server database. Let’s look at some of the basics of performance tuning and optimization.
Tuning and Optimization Basics
Unlike troubleshooting and problem solving, where you have a specific problem that needs to be uncovered and solved, tuning and optimization involves more gradual changes to the system. In some cases, the performance of the system can be optimized by making changes in the ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
