"Sinopsis" puede pertenecer a otra edición de este libro.
Written by a team of expert SQL users, this comprehensive resource 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 bottleneck. You'll then learn how to identify and remove the problems that are causing poor performance. The next section explains the preventive measures you can take to try to avoid a performance problem entirely. Finally, you'll learn how to achieve better performance and you'll take a look at some of the challenges involving performance tuning at the later stages 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 remove bottlenecks
Techniques for creating standard workloads for use in performance testing
Benefits of storage subsystem performance and robustness
How to use SQLIO and SQLIOSim to their full potential
Best practices for a successful deployment
Who this book is for
This book is for consultants, developers, DBAs, architects, or anyone with an interest in SQL performance. A working knowledge of T-SQL and knowledge of how to perform basic SQL Server and OS administrative tasks is necessary.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
"Sobre este título" puede pertenecer a otra edición de este libro.
Gastos de envío:
EUR 5,65
De Reino Unido a Estados Unidos de America
Descripción Paperback. Condición: Good. The book has been read but remains in clean condition. All pages are intact and the cover is intact. Some minor wear to the spine. Nº de ref. del artículo: GOR006333416
Descripción paperback. Condición: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority!. Nº de ref. del artículo: S_367429686
Descripción Paperback. Condición: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less 1.77. Nº de ref. del artículo: G0470176393I5N00