Troubleshooting SQL Server: A Guide for the Accidental DBA

Red Gate Software is offering another free eBook. This time “Troubleshooting SQL Server: A Guide for the Accidental DBA”, written by Jonathan Kehayias and Ted Krueger can be downloaded in pdf format along with a free trial version of SQL Monitor software.
Description
This book will help you understand how to approach troubleshooting and the essential tools you need. And explore the areas where problems regularly arise and the tools you can use to diagnose them. Also you can get practical solutions to remove the root causes of issues.
The primary audience for this book is anyone who has found themselves in charge of SQL Server “by accident;” in other words, the accidental/involuntary DBAs and system administrators who have had guardianship of SQL Server databases added to their roles, because there is a SQL Server in their environment, and someone has got to look after it.
However, the troubleshooting concepts and methodologies covered in this book can be applied by anyone, including seasoned database administrators, to identify and resolve common problems and learn new tricks for managing and maintaining SQL Server.
Contents

• A Performance Troubleshooting Methodology
• Disk I/O Configuration
• High CPU Utilization
• Memory Management
• Missing Indexes
• Blocking
• Handling Deadlocks
• Large or Full Transaction Log
• Truncated Tables, Dropped Objects and Other Accidents Waiting to Happen

Download :  Troubleshooting SQL Sever