HOUR 23. Configuring, Maintaining, and Tuning SQL Server

The most attractive application can be extremely frustrating to use if its performance is less than acceptable. As a developer, you must take precautions to try to ensure that the SQL Server is as lean and efficient as possible. In this hour you’ll learn about:

How to select and tune your hardware

How to configure and tune SQL Server

How to maintain your databases

How to maintain your tables and other objects

Selecting and Tuning Hardware

Your choice of hardware can greatly affect the performance of your server. Areas of particular concern are the amount of memory, processor speed, and hard disk configuration. The network architecture is also an important factor. The sections ...

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours 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.