O'Reilly logo

Beginning SQL Server 2008 Administration by Carmen Taglienti, Grant Fritchey, Robert E. Walters

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Performance Tuning and Optimization

SQL Server 2008 and the Windows operating systems that it runs on perform very well storing, maintaining, and presenting data to your users. Many of the processes that make them run this well are built into SQL Server 2008 and the OS. Sometimes, because of a variety of factors, such as data changes, new code, or poor design choices, performance can suffer. To understand how well your server is performing, or not, you need to understand how to measure its performance.

A number of methods of collecting performance data are available, including the Performance Monitor utility in Windows and the dynamic management views (DMVs) in SQL Server. All this server information can be automatically collected through ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required