Comentario
Written by a team of expert SQL users, this comprehensive r esource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. In addition, the authors demonstrate how to make use of the key tools for SQL Server Performance tuning.
Broken into four parts, the book first walks you through how to discover bottlenecks when something is wrong and how to monitor SQL Server to see whether there is a resource bottle neck. You'll then learn how to identify and remove the probl ems that are causing poor performance. The next section expl ains the preventive measures you can take to try to avoid a performance problem entirely. Finally, you'll learn how to a chieve better performance and you'll take a look at some of the challenges involving performance tuning at the later sta ges of a product's life.
What you will learn from this book * How to use the SQL Server wait types to find resource bottlenecks and the queries that are creating them * Ways to tune and configure the schema so you can remov e bottlenecks * Techniques for creating standard workloads for use in performance testing * Benefits of storage subsystem performance and robustne ss * How to use SQLIO and SQLIOSim to their full potential * Best practices for a successful deployment | 
