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