| Title Page | 1 |
---|
| Copyright Page | 2 |
---|
| Contents at a Glance | 4 |
---|
| Table of Contents | 5 |
---|
| Foreword | 10 |
---|
| About the Author | 12 |
---|
| About the Technical Reviewers | 13 |
---|
| Acknowledgments | 14 |
---|
| Introduction | 15 |
---|
| Chapter 1 How Did I Get Here? | 16 |
---|
| My Journey | 16 |
| Early Lessons | 17 |
| Early Career | 18 |
| Luck, Preparation, and Opportunity | 19 |
| Community | 20 |
| Other Journeys | 20 |
| Pharmacist | 21 |
| Hotel Manager | 21 |
| Estimating Supervisor | 21 |
| MUMPS Programmer | 21 |
| Your Journey | 22 |
| Get Prepared | 23 |
| Get Trained | 24 |
| Get Certified | 24 |
| Now Go and Get Your Opportunity! | 25 |
| Staying Focused | 26 |
| Chapter 2 Now What Do I Do? | 27 |
---|
| What You Have in Common with the President | 27 |
| Your Initial Checklist | 28 |
| Create a List of Servers | 30 |
| Check Database Backups | 31 |
| Verify That You Can Restore | 32 |
| Build a List of Customers | 32 |
| List the Most Important Databases | 33 |
| List Upcoming Projects and Deliverables | 34 |
| Establish Environmental Baselines | 34 |
| Compose Your Recovery Plan | 35 |
| You Have Your Info, Now What? | 36 |
| Meet with Your Manager | 36 |
| Meet with the Developers | 37 |
| Meet with the Server Administrators | 37 |
| Meet with Your Customers | 38 |
| Is That Alert Serious? | 39 |
| Should I Look Into That Alert? | 40 |
| Review the Alert System | 40 |
| Ask the Developers | 41 |
| Ask the Server Administrators | 41 |
| Ask Your Customers | 41 |
| Hi, Want to Grab Some Lunch? | 42 |
| Meeting by Eating | 42 |
| Politicking, or Not | 43 |
| Dealing with Introversion | 43 |
| Accept That Nothing Is Wrong | 43 |
| Take Care of Yourself | 44 |
| Be Open and Straightforward | 44 |
| Join Some Organizations | 44 |
| Accept That Nothing Is Wrong | 45 |
| Track Your Progress | 46 |
| Get Proactive | 46 |
| Chapter 3 Some Basics | 48 |
---|
| Introduction to RAID | 49 |
| Why Is RAID So Important? | 49 |
| RAID for Performance | 50 |
| RAID for Fault Tolerance | 51 |
| RAID 0 | 52 |
| RAID 1 | 52 |
| RAID 5 | 53 |
| RAID 1+0 | 53 |
| Which RAID Level Do You Want? | 54 |
| Your Needs | 54 |
| The ABCs of SANs for DBAs | 55 |
| Why RAID 5 Might Work for You | 56 |
| The Lost Art of Benchmarking | 57 |
| It s All About the Spindles, Baby | 58 |
| High Availability Options | 59 |
| Clustering | 59 |
| Log Shipping | 61 |
| Replication | 62 |
| Transactional Replication | 63 |
| Merge Replication | 63 |
| Snapshot Replication | 64 |
| Database Mirroring | 64 |
| Disaster Recovery Planning | 65 |
| DR Testing | 66 |
| Carnegie Hall | 67 |
| Networks Are Like Bathrooms | 68 |
| Call a Plumber | 68 |
| Fix It Now! | 69 |
| DBA Stands For . . . | 69 |
| People Will Resist Change | 70 |
| Having Standards and Processes Is Not a Bad Thing | 72 |
| People Will Blame What They Do Not Understand | 73 |
| Blame vs. Credit | 74 |
| The Need to Be Right vs. Being Liked | 75 |
| Chapter 4 A Development ServerIs a Production Serverto a Developer | 76 |
---|
| Why Developers Are So Needy | 77 |
| Under Pressure | 77 |
| Business Needs | 78 |
| SQL Knowledge | 79 |
| Service-Level Agreements | 80 |
| Being a Good Customer | 81 |
| Communication Is Key | 82 |
| Managing Expectations | 83 |
| No One Cares About Effort | 84 |
| Let s Talk | 84 |
| Get Involved Early | 85 |
| Communicate Your Actions | 86 |
| You Are Not Fast Enough | 86 |
| You Did It Wrong | 86 |
| Be Responsive and Responsible | 87 |
| Time Management | 88 |
| Develop a Routine | 88 |
| Stress Relief | 89 |
| To-Do Lists | 90 |
| Chunks | 90 |
| Know When to Say No | 91 |
| Chris Hansen and Code Reviews | 91 |
| Chapter 5 Production Support | 93 |
---|
| Service-Level Agreements | 94 |
| I Thought We Had an Agreement? | 95 |
| Get to Know What You Do | 95 |
| Be Nice | 96 |
| Establish Support Process | 97 |
| Define Process | 98 |
| Publish Process | 99 |
| Remind and Enforce | 99 |
| Work/Life Balance | 100 |
| Communication | 100 |
| Protect Your Private Time | 101 |
| Happy Fun Play Time | 101 |
| Outsourcing | 102 |
| Quality of Work | 103 |
| Language Barriers | 104 |
| Security | 105 |
| Job Security | 105 |
| All Good Things | 106 |
| Chapter 6 Basic Troubleshooting | 107 |
---|
| CSI: SQL | 107 |
| Incidents | 108 |
| Interrogations | 109 |
| Surveillance | 109 |
| Common Bottlenecks | 110 |
| Disk | 111 |
| Memory | 111 |
| CPU | 112 |
| Available Tools | 112 |
| Reliability and Performance Monitor | 112 |
| Disk I/O | 114 |
| SQLServer:PhysicalDisk | 114 |
| SQLServer:Buffer Manager | 115 |
| Memory | 115 |
| CPU | 115 |
| Activity Monitor | 116 |
| Disk I/O | 116 |
| Memory | 117 |
| CPU | 117 |
| Dynamic Management Views (DMVs) |