×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

SQL Server Query Performance Tuning Distilled
     

SQL Server Query Performance Tuning Distilled

4.0 1
by Sajal Dam, Tony Davis (Editor)
 

See All Formats & Editions

Many SQL Server-based applications perform far below expectation costing money and time. And until now, there has been very little practical information available that explains how to identify and cure performance problems in SQL Server. But this book offers essential content to fill in the gap.

SQL Server Query Performance Tuning Distilled, Second Edition

Overview

Many SQL Server-based applications perform far below expectation costing money and time. And until now, there has been very little practical information available that explains how to identify and cure performance problems in SQL Server. But this book offers essential content to fill in the gap.

SQL Server Query Performance Tuning Distilled, Second Edition includes updated material plus one new chapter, and explains how to design and tune SQL Server applications to cope with ever-increasing workloads. With proven strategy, this book teaches you how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements. Also covered are crucial issues like index analysis and tuning, preventing deadlocks, optimizing workload, and minimizing costs.

Product Details

ISBN-13:
9781590594216
Publisher:
Apress
Publication date:
10/19/2004
Edition description:
2nd ed. 2005
Pages:
608
Product dimensions:
6.13(w) x 9.25(h) x 9.25(d)

Meet the Author

Sajal Dam holds a master's of technology degree in computer science from the Indian Institute of Science, Bangalore, and has been working with Microsoft technologies for over 12 years. He has developed an extensive background in designing database applications and managing software development. Sajal also possesses significant experience in troubleshooting and optimizing the performance of Microsoft-based applications, from front-end web pages to back-end databases.

While working at Microsoft, Sajal helped many Fortune 500 companies design scalable database solutions and maximize the performance of their database environments. As an IT strategist at Dell, Sajal manages Dell's vast database infrastructure by optimizing not only the databases, but also the database management processes, tools, and use of best practices. He also works closely with the application development teams and vendors, including Microsoft, in analyzing and resolving performance bottlenecks.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews

SQL Server Query Performance Tuning Distilled 4 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
Dam starts off by describing quite general problems that might arise in any relational database. He also wants you to inject some rigour into your efforts, by defining fundamental baseline metrics for your system usage. Then, when trying ideas described later in the book, you can get objective quantitative feedback on their efficacies. Of course, the bulk of the book is specific to SQL Server. But you should keep in mind that Dam is not primarily offering a bunch of quick tips on performance improvement. To be sure, the chapters do indeed give specific suggestions that you can try. But a more sophisticated reader can get an understanding of the broad constraints of SQL Server and a rough but good idea of its internal workings. You don't need source code for this. It sbould also be said that you need a good knowledge of SQL and the theory of relational databases, before venturing into the book. Some chapters (like on blocking and deadlock analysis) will considerably test this background. But the last chapter may be welcomed by some of you. It summarises the book by offering a detailed list of best practices. If you want to quickly gauge what the book has to offer, read the last chapter first.