Share this Page URL

Chapter 15. Configuring, Maintaining, an... > Hardware Selection and Tuning - Pg. 456

456 Chapter 15. Configuring, Maintaining, and Tuning SQL Server IN THIS CHAPTER · · · · · Why This Chapter Is Important Hardware Selection and Tuning SQL Server Configuration and Tuning Database Maintenance Table and Object Maintenance · Job Maintenance · Performance Monitoring Why This Chapter Is Important The most attractive application can be extremely frustrating to use if its performance is less than acceptable. As a developer, you must try to ensure that the SQL Server is as lean and efficient as possible. This chapter focuses on several techniques for improving performance. Probably one of the easiest ways to improve performance is to modify the hardware and software environment within which SQL Server operates. You'll begin by learning how the hardware that you select influences the perform- ance of your application. By following the guidelines covered in this chapter, you can help ensure that you are not inadver- tently introducing bottlenecks into your database and, therefore, your application. Although any one of the suggestions included in this chapter might not make a difference by itself, the combined effect of these performance enhancements can be quite dramatic. Hardware Selection and Tuning Your choice of hardware can greatly affect the performance of your server. Areas of particular con- cern are the amount of memory, processor speed, and hard disk configuration. The network archi- tecture is also an important factor. The sections that follow cover the details of each of these items. Memory--The More RAM, the Better! SQL Server uses memory (RAM) to hold all data pages, index pages, and log records. It also uses memory to hold compiled queries and stored procedures. Needless to say, that memory is vital to the performance of the server.