List of Tables

Chapter 1. The SQL Server landscape

Table 1.1. Scalability and high availability features in SQL Server editions

Table 1.2. Security and manageability features in SQL Server editions

Table 1.3. Management tools available in each edition of SQL Server

Chapter 2. Storage system sizing

Table 2.1. RAID level comparisons

Table 2.2. Storage system attributes

Chapter 3. Physical server design

Table 3.1. Commonly used SQLIO parameters

Table 3.2. Maximum supported CPU sockets for each SQL Server version

Table 3.3. Maximum memory for SQL Server 2008 editions

Table 3.4. Registry entries used to define NUMA nodes

Chapter 4. Installing and upgrading SQL Server 2008

Table 4.1. Upgrade options compared

Chapter 7. Configuring SQL Server

Table 7.1. Recommended memory configuration options

Table 7.2. Default worker threads created by SQL Server based on the CPU number and type

Chapter 10. Backup and recovery

Table 10.1. Grandfather–father–son tape rotation policy

Chapter 11. High availability with database mirroring

Table 11.1. A comparison of SQL Server high-availability solutions

Table 11.2. Supported failover modes by mirroring type

Table 11.3. Failure scenarios by mirroring topology and transaction safety

Table 11.4. Mirroring session states

Chapter 12. DBCC validation

Table 12.1. DBCC commands by category

Table 12.2. GAM and SGAM bit settings

Chapter 13. Index design and maintenance

Table 13.1. Fragmentation levels and options

Chapter 16. Resource Governor