The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P12: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Installing SQL Server 2008 Chapter 2 37 The key database engine features in the Enterprise Edition address scalability high availability and security. Scalability is the ability to add more resources. In SQL Server 2008 Enterprise Edition this is achieved by scaling up servers by adding additional CPUs memory or disks to a single server or by scaling out by moving certain services or databases to other servers. The key scalability features in SQL Server 2008 database engine include Partitioning Segmenting of data in large tables and indexes into units that can be distributed across multiple filegroups in a database to improve IO performance. Partitioning is very useful in improving the performance of very large OLTP and data-warehousing databases. Data compression Reduces the size of tables indexes or partitions thereby reducing the database disk requirements. Resource governor Provides control over the amount of CPU and memory allocated to SQL Server 2008 workloads without any application changes. Partition table parallelism Improves the query processing performance on partitioned tables for parallel queries by enhancing the partitioning information in the compile-time and runtime execution plans. Multi-instance support Establishes the maximum number of SQL Server 2008 instances that can be created on a server. Enterprise Edition supports up to 50 instances on a server Compact Edition only supports one instance and all the other editions support up to 16 instances. Log shipping Allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. Log shipping supports the high availability option of database mirroring. The Express and Mobile editions do not support this feature. Replication Enables a primary database server to distribute data to one or more secondary servers. Partitioning data compression and partition table parallelism are exclusive
