Jonathan Kehayias, Gail Shaw and Ted Krueger provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus of 'Troublshooting SQL Server' is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
The steps and techniques described are ones used every day to troubleshoot real SQL Server performance problems. With them, we hope you can solve performance problems quickly and accurately, and tame your unruly SQL Servers.
Red Gate Books
Red Gate Books
Red Gate Books
Red Gate Books
Most Helpful Customer Reviews
If I were a DBA stuck on a dessert island and could have only one book, I think this is it.
As the subtitle suggests ("accidental" dba) - this is especially helpful to those of us who really do know what we're doing most of the time, but may be fuzzy around the edges.
For example, I do understand how SQL Server manages memory; but over the years I've had to guess at times on machines that had been overconsolidated with multiple instances and hundreds of databases. That's covered concisely on pages 160 and 161.
Jonathan and Ted also understand well that one can't always get just what is wanted or needed for the servers, and that sometimes we need to do the best we can with what we've got.
A word of warning: when you get this book, you may have an impulse to push it in a manager's or SAN administrator's face saying "See! I didn't make this stuff up!".
That's of course a poor idea. Use this to educate and to explain the impact of...
This useful and practical book met my requirements perfectly; it has everything I needed, nothing I didn't need. I know enough about databases in general, I don't need any theory; and I know enough about SQL Server in particular to know the basics. I'm not a full time DBA, so I needed a guide to the occassional in-depth problem - troubleshooting memory issues, using Data Management Views, etc. SQL Server Management Studio is a nice front end which lets you do all the regular administration. But once you get off the beaten path, a guide is handy. After owning the paperback for a few months I bought the Kindle version as well, so I could refer to this book any time. Recommended.
I have followed Jonathan's blog for some time before purchasing this book. This book is a great collection of information centrally located and easy to get to without having to navigate Jonathan's blog or other articles he may have published around the web.
The book features a wealth of information for any of us that were born a DBA, but rather had it add as a job feature along with everything else we are currently maintaining! It is nice to be able to go through the book and have access to the code from the book to add to some of the SSIS jobs I had created.
This is a great book that is well worth the price!!
The authorised South African distributor of this product is under no obligation to honour the manufacture's guarantees/warranties or to provide after-sales service.
Please note that this item is imported from the USA, and is designed to be used in the USA. In addition, if the unit is powered it will come with a US plug and an adapter/transformer may be required. Please click here for more information on power requirements, or check with us if you are unsure or need any assistance!
Please also note that certain items cannot be imported, these include Alcohol, Animals, Batteries, Flammable Materials, Currency, Food, Furs, Chemicals, Explosives, Medications, Plants, Seeds, Supplements, Pressurized Cans, Tactical Equipment, Vitamins, Weaponry and Weaponry Accessories. In these cases, the item and information is displayed for reference purposes only. If you are not sure if we are permitted to bring an item, please send us an e-mail with a link to the item to confirm.
Please also ensure that you are ordering the correct item for your particular application as returns to the USA are costly. Product reviews are also provided for most of our items, which can give you a good idea for possible things to look out for and the quality of the item. By clicking Add to Cart, you are confirming that the item is correct and you accept the conditions listed here.