Professional SQL Server™ 2005 Programming

23.11. Summary

Performance could be, and should be, in a book by itself. There's simply just too much to cover and get acquainted with to do it all in one or even several chapters. The way I've tried to address this is by pointing out performance issues throughout the book, so you could take them on a piece at a time.

The biggest thing is to have a plan — a performance plan. Make performance an issue from the first stages of your project. Set benchmarks early, and continually measure your system against those benchmarks to know where you are improving and what problems you might need to address.

In this chapter, we've reviewed a number of the performance considerations touched on throughout the book, plus added several new tools and ideas to consider.

In the next chapter, we'll be taking a look at administration issues. As you've seen through some of the portions of this chapter, proper administration can also be a key ingredient to performance.