Advertisement

Healthy SQL

A Comprehensive Guide to Healthy SQL Server Performance

  • Authors
  • Robert Pearl

Table of contents

  1. Front Matter
    Pages i-xxv
  2. Robert Pearl
    Pages 1-17
  3. Robert Pearl
    Pages 19-41
  4. Robert Pearl
    Pages 43-80
  5. Robert Pearl
    Pages 81-114
  6. Robert Pearl
    Pages 115-147
  7. Robert Pearl
    Pages 149-185
  8. Robert Pearl
    Pages 187-229
  9. Robert Pearl
    Pages 231-278
  10. Robert Pearl
    Pages 279-322
  11. Robert Pearl
    Pages 323-368
  12. Back Matter
    Pages 369-378

About this book

Introduction

"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.

Bibliographic information