|
Professional SQL Server 2008 Internals and Troubleshooting |  | Authors: Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort
Publisher: Wrox
Category: Book
List Price: $59.99
Buy New: $32.09
as of 7/30/2010 03:48 CDT details
You Save: $27.90 (47%)
New (36) Used (10) from $31.00
Seller: new_books_today
Rating:  9 reviews
Sales Rank: 38848
Media: Paperback
Pages: 624
Number Of Items: 1
Shipping Weight (lbs): 2.3
Dimensions (in): 9.2 x 7.3 x 1.3
ISBN: 0470484284
Dewey Decimal Number: 005.7585
EAN: 9780470484289
ASIN: 0470484284
Publication Date: January 7, 2010
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9780470484289 | | • | Condition: New | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
A hands-on resource for SQL Server 2008 troubleshooting methods and tools SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system. You'll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side. Topics Covered: - SQL Server Architecture
- Understanding Memory
- SQL Server Waits and Extended Events
- Working with Storage
- CPU and Query Processing
- Locking and Latches
- Knowing Tempdb
- Defining Your Approach To Troubleshooting
- Viewing Server Performance with PerfMon and the PAL Tool
- Tracing SQL Server with SQL Trace and Profiler
- Consolidating Data Collection with SQLDiag and the PerfStats Script
- Introducing RML Utilities for Stress Testing and Trace File Analysis
- Bringing It All Together with SQL Nexus
- Using Management Studio Reports and the Performance Dashboard
- Using SQL Server Management Data Warehouse
- Shortcuts to Efficient Data Collection and Quick Analysis
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
|
| Customer Reviews:
Showing reviews 1-5 of 9
Touched on a wide array of performance topics July 9, 2010
Nicholas J. Weber
I recently finished reading "Professional SQL Server 2008 Internals and Troubleshooting" and wanted to write a quick review about it. As a Production SQL DBA who is required to works with a variety of technologies like SANs, networking etc... I found this book to be a wonderful resource. All too often with SQL books the content seems to be geared towards development DBAs and the in-depth discussion of Storage seems to be some sort of black arts to a lot of DBA's. This book seems to fill in the gap in the market where a lot of SQL books fall short for the "Production DBA". I'm glad to see a book that touched on such a wide array of performance topics including disk sub-systems.
@Toshana
This book will make you flip its page instead of going to search engine online. March 9, 2010
Pinalkumar Dave (SQLAuthority)
6 out of 6 found this review helpful
Brief Review: Having a book on internal and associating that with real life is "almost" an impossible task. The reason for using the word "almost" is because this book has accomplished this very well. This internals book is written by keeping real life scenarios as top focus. The highlight of the book is that it teaches how to use internals to troubleshoot the real life issues of performance, storage, query processing and all the other important aspects of SQL Server - A must-have book for everybody who is a hands-on DBA/Developer.
Detail Review: I planned to finish reading this book within a week. Very soon, I realized that I was going over very interesting subjects of SQL Server very quickly and understanding them very well. In fact, I finished reading this book in less than a week, and I have to accept that it offers an interesting journey for its readers. This book is also quite easy to read. This book has addressed some of the complex subjects in such a simple manner that any SQL user can understand it very easily.
The three very important components for any server are CPU, Memory and IO. This book effectively elucidates these three components. The topics usually begin by covering internals which shift to practical implementations after proper amount of internals. In other way, I can say that this book is NOT a usual boring book, which can put you to sleep. Each chapter keeps you interested till the end of it. CPU and IO, which are very important deciding factors for Query cost, are very well explained in the book. This book explains how any query can be understood in terms of internals. After explaining the query internals in terms of CPU and IO, it also explains how the physical memory affects query execution and what are the techniques to improve performance?
This book gives an in-depth explanation of Wait Types and Extended Events. I must admit that I was quite scared of Wait Types and Extended Events thus far and learned how "friendly" they can be after reading this book. In fact, I can really see that how I can use these concepts in my real life scenarios and help my servers to run better and efficiently. This book also covers some topics which do not have much available help online, i.e. SQLDiag, RML Utilities, etc. One who is new to these subjects can easily learn from the basics and soon can move to an advanced level. Again, as mentioned earlier, this book is written by taking the real world into consideration and all these subjects follow the same goal.
In fact, I liked the entire book. However, the chapters which I really enjoyed the most are Chapter 3: SQL Server Waits and Extended Events by Jonathan Kehayias; Chapter 4: Working with Storage by Brent Ozar; and Chapter 5: CPU and Query Processing by Steven Wort. Each chapter is independent of the other chapters; this way, the reader can practically start reading any chapter from anywhere and explore the book according to his/her convenience.
Databases are required because there is a large amount of data available, and keeping the data safe, secure and available is the MOST important task of any database system. The fourth chapter on Storage by Brent covers this important basic concept very thoroughly. The most impressive part of Chapter 4 is that it explains how storage works in real time. While taking about storage, Brent manages to effectively explain the concepts of High Availability and Disaster Recovery as well. Maintenance of storage has always been a challenge, and also there has been a lack of understanding on storage devices and techniques available. This chapter answers few very basic but important questions like when should SAN be used for data storage, and what is its effect on performance? This chapter also explains RAID setup; however, please note that it focuses on "practical internals." After setting up good storage, it is equally important to test it; this chapter continues discussing different tools and methodologies for testing storage. This chapter also covers Windows Server Configuration as well as tuning of software by means of storage devices. Corruption can be significant problem in case of a large database; this chapter also covers the proper usage of DBCC CHECKDB and its best practices.
There is no doubt that this book is written by experts who have extensive experience in the subject, which is covered in different chapters. Solid and thorough content, plenty of code, easy-to-understand diagrams, lots of tips along with each topic and simple language are the key highlights of this book.
Rating: 5 Stars
Summary: There is no doubt that this book is by far one of the best books available for anybody who is interested in SQL Server Internals and applying its knowledge to real world troubleshooting scenarios. I think this is one of the must-have books for understanding SQL Server, and believe me, you will find yourself flipping the pages of the book when you are facing a trouble with the SQL Server instead of using search engine!
Very Useful SQL Server Book March 8, 2010
Glenn Berry (Parker, CO)
1 out of 2 found this review helpful
This book has 16 chapters of valuable information, written by a collection of well-regarded SQL Server experts, many them Microsoft SQL MVPs. The authors include Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort, Cindy Gross, and Jonathan Kehayias.
This book is heavily focused on the database engine, with lots of low level detail on hardware and different tools for measuring and monitoring performance. I would have liked to seen a chapter on DMV queries, but other than that, I am very happy with this book. Highly recommended.
An Excellent Read February 15, 2010
Bob Pusateri (Chicago, IL USA)
1 out of 2 found this review helpful
Having read many books on SQL Server internals, this is one of my favorites. It's a great read that does an excellent job of explaining the big picture. I was able to learn a lot and didn't get bogged down with minutiae. I consider it a wonderful addition to any DBA's library.
Great book for *anyone* working with SQL Server January 25, 2010
Michael Thomas (NC, USA)
3 out of 5 found this review helpful
I recommend this book to everyone. I tell people it just came out, and they look curious because mine's getting worn. The info is clear and concise, and doesn't ramble, so I like it.
A funny example happened running a small VM with SQL Server. It was hanging infrequently and crashing because of RAM memory issues and disk swaps. I had imported the OS into VMware workstation on my laptop, but it had PAE enabled. Disabling PAE, going from 8 to 4KB pages, saved the VM 200MB total RAM utilization. After checking/setting other SQL Server memory settings, and monitoring counters, the system is stable. The memory chapter helped me do all the right things.
I also purchased the .pdf version of the book to search for terms. Its another plus on the laptop. Thanks for a great book!
Showing reviews 1-5 of 9
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
