Quantity:

More Buying Choices

45 used & new from �4.17

Have one to sell? Sell yours here

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.08 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save:	�13.91 (41%)
	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 Wednesday, November 18? Choose Express delivery at checkout. See Details

35 new from �10.32 10 used from �4.17

Other Editions:	RRP:	Our Price:	Other Offers:
Unknown Binding			Order it used

Frequently Bought Together

Price For All Three: �58.65

Show availability and delivery details

This item: Professional SQL Server 2005 Performance Tuning (Programmer to Programmer) by Steven Wort
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Professional SQL Server 2005 Administration (Wrox Professional Guides) by Brian Knight
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Professional SQL Server 2005 Programming (Programmer to Programmer) by Robert Vieira
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Customers Who Bought This Item Also Bought

Professional SQL Server 2005 Administration (Wrox Professional Guides)

by Brian Knight

3.0 out of 5 stars (2) �19.29

Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization

by S. Agarwal, C. Freedman, A. Machanic, R. Talmage Kalen Delaney

4.0 out of 5 stars (1) �24.17

Professional SQL Server 2005 Programming (Programmer to Programmer)

by Robert Vieira

5.0 out of 5 stars (1) �19.28

Microsoft SQL Server 2008 Internals (Pro - Developer)

by Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic, and Ben Nevarez Kalen Delaney

5.0 out of 5 stars (2) �26.08

Professional SQL Server 2005 Integration Services

by Brian Knight

4.0 out of 5 stars (3) �19.29

› Explore similar items

Product details

Paperback: 551 pages
Publisher: John Wiley & Sons (25 Jan 2008)
Language English
ISBN-10: 0470176393
ISBN-13: 978-0470176399
Product Dimensions: 23 x 18.8 x 3.6 cm

Average Customer Review: 4.0 out of 5 stars See all reviews (1 customer review)

Amazon.co.uk Sales Rank: 321,531 in Books (See Bestsellers in Books)
Popular in these categories:
#26 in Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
#36 in Books > Computing & Internet > Microsoft Windows > Programming > SQL Server

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

SQL Server Performance opens new browser window

www.Confio.com - Instant Optimization of SQL Server, Immediate ROI, Free Trial Download!

Optimize SQL Performance opens new browser window

www.Precise.com - Fix SQL Database Performance Problems Faster. Free White Paper.

SQL Server Tuning opens new browser window

www.Red-Gate.com/SQL_Refactor - Consistent Coding Across Your Team. SQL Code Tuning. Free Download.

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

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)

Tags Customers Associate with This Product

(What's this?)

Click on a tag to find related items, discussions, and people.

sql server(1)

sql server performance tuning(1)

What Do Customers Ultimately Buy After Viewing This Item?

	79% buy the item featured on this page: Professional SQL Server 2005 Performance Tuning (Programmer to Programmer) 4.0 out of 5 stars (1) �20.08
	7% buy Professional SQL Server 2005 Administration (Wrox Professional Guides) 3.0 out of 5 stars (2) �19.29
	5% buy SQL Server 2005 Practical Troubleshooting: The Database Engine 5.0 out of 5 stars (1) �33.91
	5% buy Inside Microsoft SQL Server 2005: Query Tuning & Optimization: Query Tuning and Optimization 4.0 out of 5 stars (1) �24.17

Explore similar items

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:

Create your own review

Most Helpful Customer Reviews

0 of 1 people found the following review helpful:

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

› See all customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }