Healthy SQL: A Comprehensive Guide to Healthy SQL Server Performance

Healthy SQL: A Comprehensive Guide to Healthy SQL Server Performance

by Robert Pearl

Paperback(1st ed.)

View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Friday, April 26

Product Details

ISBN-13: 9781430267737
Publisher: Apress
Publication date: 05/27/2015
Edition description: 1st ed.
Pages: 408
Product dimensions: 7.01(w) x 10.00(h) x 0.03(d)

About the Author

Robert Pearl, president and founder of Pearl Knowledge Solutions, Inc., has been a Microsoft SQL Server MVP since 2009, having received his fifth MVP recognition award. He is a solutions-oriented senior DBA with 15+ years of experience, and is considered a subject-matter expert on SQL Server technology. He also coined the terms Healthy SQL™ and SQL Fitness™ to kick off the worldwide healthy SQL campaign to highlight the need for regular health checks to ensure that everyone’s SQL Server environment has achieved a healthy state. He is a SQL Community and SQL Saturday evangelist, promoter, and speaker, and maintains his regular blog called Pearl Knows at Pearl was voted Top Blogger in the 2011 SQL Mag Community Choice Awards. He is also the creator/developer of the award-winning product SQL Centric—a web-based database monitoring and alert system for DBAs. Robert is a SQL Saturday organizer and co-chair of the successful New York Metro PASS SQL Saturdays.

Table of Contents

1. Understanding the Health Check

2. Creating a Road Map

3. Waits and Queues

4. Indexes

5. Tools of the Trade

6. Expanding the Toolset

7. Creating a Heath Repository

8. Monitoring and Reporting

9. High Availability and Disaster Recovery

10. Surviving the Audit

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews