|
Frequently Bought Together
Customers Who Bought This Item Also Bought
Professional SQL Server 2005 Administration (Wrox Professional Guides) by Brian Knight |
Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization by S. Agarwal, C. Freedman, A. Machanic, R. Talmage Kalen Delaney |
Professional SQL Server 2005 Programming (Programmer to Programmer) by Robert Vieira |
Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) by Lubor Kollar, Dejan Sarka Itzik Ben-Gan (Solid Quality Learning) |
Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning) by Kalen Delaney (Solid Quality Learning) |
Product details
Would you like to update product info or give feedback on images?
|
Customers Viewing This Page May Be Interested in These Sponsored Links(What is this?) |
Product Description
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. The book first walks you through how to discover bottlenecks when something is wrong and you’ll then learn how to identify and remove the problems that are causing poor performance. You’ll discover preventive measures you can take to try to avoid a performance problem entirely and you’ll learn how to achieve better performance.
From the Back Cover
Professional SQL Server 2005 Performance Tuning
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.
See all Product Description
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Do Customers Ultimately Buy After Viewing This Item?
 |
82% buy the item featured on this page: Professional SQL Server 2005 Performance Tuning (Programmer to Programmer) £20.39 |
 |
7% buy Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization £25.67 |
 |
6% buy Microsoft® SQL Server® 2008 Internals (Pro - Developer)£27.62 |
 |
5% buy Professional SQL Server 2005 Administration (Wrox Professional Guides) £20.79 |
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
|
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
- Books > Computing & Internet > Software & Graphics
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
Fun for Everyone |
Let Olay Amaze You |
Treat Someone
With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is). |
||||||||
| |||||
Your Recent History
(What's this?)|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
Continue Shopping: Top Sellers
| ||||
Amazon Home | |
| International Sites: United States | Germany | France | Japan | Canada | China | |
| Business Programs: Sell on Amazon | Fulfilment by Amazon | Join Associates | Join Advantage | |
| Customer Service | Help | View Basket | Your Account | |
| About Amazon.co.uk | Careers at Amazon | |
| Conditions of Use & Sale | Privacy Notice © 1996-2009, Amazon.com, Inc. and its affiliates |