Table of Contents

 

Copyright

Brief Table of Contents

Table of Contents

Foreword

Preface

Acknowledgments

About this Book

About the Cover Illustration

About the Author

1. Planning and installation

Chapter 1. The SQL Server landscape

1.1. SQL Server 2008: evolution or revolution?

1.2. Editions and features

1.2.1. Enterprise

1.2.2. Standard

1.2.3. Workgroup

1.2.4. Other editions of SQL Server

1.3. SQL Server tools

1.4. DBA responsibilities

Chapter 2. Storage system sizing

2.1. Characterizing I/O workload

2.1.1. OLTP vs. OLAP/DSS

2.1.2. I/O metrics

2.2. Determining the required number of disks and controllers

2.2.1. Calculating the number of disks required

2.2.2. Bus bandwidth

2.2.3. A note on capacity

2.3. Selecting the appropriate RAID level

2.3.1. RAID 0

2.3.2. RAID 1

2.3.3. RAID 5

2.3.4. RAID 10

2.4. Selecting an appropriate storage system