Skip to main content

Introducing new learning courses and educational videos from Apress. Start watching

  • Book
  • © 2015

Healthy SQL

A Comprehensive Guide to Healthy SQL Server Performance

Apress

Authors:

  • Healthy SQL helps you put in place a rigorous routine to monitor and manage the ongoing performance health of your SQL Server database

  • 10k Accesses

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • ISBN: 978-1-4302-6772-0
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book USD 54.99
Price excludes VAT (USA)

This is a preview of subscription content, access via your institution.

Table of contents (10 chapters)

  1. Front Matter

    Pages i-xxv
  2. Introduction to Healthy SQL

    • Robert Pearl
    Pages 1-17
  3. Creating a Road Map

    • Robert Pearl
    Pages 19-41
  4. Waits and Queues

    • Robert Pearl
    Pages 43-80
  5. Much Ado About Indexes

    • Robert Pearl
    Pages 81-114
  6. Tools of the Trade: Basic Training

    • Robert Pearl
    Pages 115-147
  7. Expanding Your Tool Set

    • Robert Pearl
    Pages 149-185
  8. Creating a SQL Health Repository

    • Robert Pearl
    Pages 187-229
  9. Monitoring and Reporting

    • Robert Pearl
    Pages 231-278
  10. High Availability and Disaster Recovery

    • Robert Pearl
    Pages 279-322
  11. Surviving the Audit

    • Robert Pearl
    Pages 323-368
  12. Back Matter

    Pages 369-378

About this book

"Robert Pearl, a well-known DBA in the SQL community, explains his holistic vision of a database instance that needs regular check-ups and gives the tools, scripts, and best practices he has collected over the years." Alberto Bolchini, Computing Reviews, May 9, 2016

Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you. It's in everyone's best interest to have a healthy SQL implementation. Healthy SQL is built around the concept of a medical checkup, giving you the tools you need to assess the current health of your database and take action to improve upon that health and maintain good performance to your business.

Healthy SQL aids in developing a rigorous routine so that you know how healthy your SQL Server machines are, and how you can keep those same servers healthy and fit for duty. The book is filled with practical advice and a time-tested strategy, helping you put together a regimen that will ensure your servers are healthy, your implementation is fully optimized, your services are redundant and highly available, and you have a plan for business continuity in the event of a disaster. If your current environment doesn't match up with these criteria, then pick up a copy of Healthy SQL today and start your journey on the road to a fit and tight SQL Server deployment.

Reviews

“The book’s intended audience includes both junior and seasoned SQL Server DBAs: they will appreciate it for the hands-on approach as well as for the valuable scripts and tools … they will easily incorporate in their toolboxes.” (Alberto Bolchini, Computing Reviews, computingreviews.com, May, 2016)

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 SQLServerCentral.com. 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.

Bibliographic Information

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • ISBN: 978-1-4302-6772-0
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book USD 54.99
Price excludes VAT (USA)