Book description
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.
Table of contents
- Cover
- Title
- Copyright
- Dedication
- Testimonials
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Foreword
- Chapter 1: Introduction to Healthy SQL
- Chapter 2: Creating a Road Map
- Chapter 3: Waits and Queues
- Chapter 4: Much Ado About Indexes
-
Chapter 5: Tools of the Trade: Basic Training
- Build a Better Mousetrap
- Monday Morning Mania (Busiest DBA Day)
- SSMS Standard Reports
- SQL Server 2012 Performance Dashboard
- The Power of Dynamic Management Views and Function Categories
- SQL Profiler/Trace
- Performance Monitor
- Data Collector
- Management Data Warehouse: SQL Server 2008 and Higher
- Basic Training Completed
- Chapter 6: Expanding Your Tool Set
- Chapter 7: Creating a SQL Health Repository
- Chapter 8: Monitoring and Reporting
- Chapter 9: High Availability and Disaster Recovery
- Chapter 10: Sur?viving the Audit
- Index
Product information
- Title: Healthy SQL : A Comprehensive Guide to Healthy SQL Server Performance
- Author(s):
- Release date: May 2015
- Publisher(s): Apress
- ISBN: 9781430267720
You might also like
book
Microsoft® Azure™ SQL Database Step by Step
Your hands-on guide to Azure SQL Database fundamentals Expand your expertise—and teach yourself the fundamentals of …
book
SQL Server 2012 Query Performance Tuning, Third Edition
Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book …
book
Pro SQL Server Wait Statistics
Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance …
book
SQL Server 2014 Development Essentials
Design, implement, and deliver a successful database solution with Microsoft SQL Server 2014 In Detail SQL …