Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
36 used & new from £17.89

Have one to sell? Sell yours here
 
   
Professional SQL Server 2005 Performance Tuning (Programmer to Programmer)
 
 

Professional SQL Server 2005 Performance Tuning (Programmer to Programmer) (Paperback)

by Steven Wort (Author), Christian Bolton (Author), Justin Langford (Author), Michael Cape (Author), Joshua J. Jin (Author), Douglas Hinson (Author), Haidong Ji (Author), Paul A. Mestemaker (Author), Arindam Sen (Author)
4.0 out of 5 stars See all reviews (1 customer review)
RRP: £33.99
Price: £20.39 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £13.60 (40%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Want guaranteed delivery by Saturday, July 11? Choose Express delivery at checkout. See Details
28 new from £19.25 8 used from £17.89
Other Editions: RRP: Our Price: Other Offers:
Unknown Binding Order it used

Frequently Bought Together

Professional SQL Server 2005 Performance Tuning (Programmer to Programmer) + Professional SQL Server 2005 Administration (Wrox Professional Guides) + Professional SQL Server 2005 Programming (Programmer to Programmer)
Price For All Three: £61.97

Show availability and shipping details


Customers Who Bought This Item Also Bought

Professional SQL Server 2005 Administration (Wrox Professional Guides)

Professional SQL Server 2005 Administration (Wrox Professional Guides)

by Brian Knight
4.0 out of 5 stars (1)  £20.79
Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization

Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization

by S. Agarwal, C. Freedman, A. Machanic, R. Talmage Kalen Delaney
4.0 out of 5 stars (1)  £25.67
Professional SQL Server 2005 Programming (Programmer to Programmer)

Professional SQL Server 2005 Programming (Programmer to Programmer)

by Robert Vieira
5.0 out of 5 stars (1)  £20.79
Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

by Lubor Kollar, Dejan Sarka Itzik Ben-Gan (Solid Quality Learning)
4.8 out of 5 stars (10)  £23.07
Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning)

by Kalen Delaney (Solid Quality Learning)
4.7 out of 5 stars (3)  £24.84
Explore similar items

Product details


Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
SQL Server Performance
   www.Confio.com    Instant Optimization of SQL Server, Immediate ROI, Free Trial Download! 
Improve SQL Performance
   www.Heroix.com    Free Whitepaper Reveals The Key Drivers Behind SQL Performance
SQL Server Tuning
   www.DBSophic.com/Qure    Experiencing Performance Issues? Qure Optimizes Indexes & Syntax 
  
 

Product Description

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


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

Professional SQL Server 2005 Performance Tuning (Programmer to Programmer)
82% buy the item featured on this page:
Professional SQL Server 2005 Performance Tuning (Programmer to Programmer) 4.0 out of 5 stars (1)
£20.39
Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization
7% buy
Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization 4.0 out of 5 stars (1)
£25.67
Microsoft® SQL Server® 2008 Internals (Pro - Developer)
6% buy
Microsoft® SQL Server® 2008 Internals (Pro - Developer)
£27.62
Professional SQL Server 2005 Administration (Wrox Professional Guides)
5% buy
Professional SQL Server 2005 Administration (Wrox Professional Guides) 4.0 out of 5 stars (1)
£20.79

 

Customer Reviews

1 Review
5 star:    (0)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.0 out of 5 stars (1 customer review)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
4.0 out of 5 stars A good introduction to SQL performance tuning, 25 Jun 2009
By P. Schofield (London) - See all my reviews
(REAL NAME)   
The first couple of hundred pages are very very good, providing excellent instructions about how to get the best out of Perfmon, Profiler, DMVs - together with tuning tips.

I did delay buying this as ideally I wanted an edition for SQL2008, and especially wanted a book that included a section on the issues that SQL has on virtualisation.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Listmania!


Look for similar items by category


Feedback


Fun for Everyone

Christmas Gifts
Achieve over 15,000 RPM with our great range of Powerballs.

Shop the Powerball store

 

Let Olay Amaze You

Olay Total Effects Day Moisturiser SPF15 50ml
Amazon.co.uk sells all your favourite ranges from Olay, including Regenerist and Total Effects.

Discover Olay at Amazon.co.uk

 

Boys Smell

Lynx Africa Body Spray and After Shave Gift set
But we make sure they smell good...

Discover male grooming at Amazon.co.uk

 

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

Learn more about Gift Certificates

 
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

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
The Girl Who Played with Fire
Breaking Dawn (Twilight Saga)
The Girl with the Dragon Tattoo
The Host
The Host by Stephenie Meyer

amazon.co.uk 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