Datasheet

You can also partition indexes. If the partitions for data and for indexes are
aligned, you can move partitions into or out of a table. This is useful if you
have data for the last 12 months, partitioned by month. You can move the
data for 12 months ago out and create a new partition for the current month.
Database Engine Tuning Advisor
The Database Engine Tuning Advisor (DTA) is the SQL Server 2005 replace-
ment for the SQL Server 2000 Index Tuning Wizard. The Database Tuning
Advisor can help you tune performance for the whole database, not just for
indexes, as previously.
The DTA can handle partitions and can assist in tuning some operations that
involve using multiple databases. It has a high availability recommendation
mode that recommends creation of indexes only if those indexes can be built
online, which improves availability of a database during creation of indexes.
You can specify a maximum time for DTA to reach its recommendations to
avoid very long running scenarios. You can also explore what if analyses in
the Database Tuning Advisor to allow you to explore the effects of possible
approaches.
Hot-add memory support
If the demands on your SQL Server increase markedly and you have the
appropriate hardware and are running SQL Server on Windows Server 2003,
you can take advantage of hot-add memory support. This allows you to
improve performance under high load and also allows you to avoid downtime.
Replication
Replication performance has been improved in SQL Server 2005. The number
of subscribers supported in replication is increased.
Business Intelligence Enhancements
Business Intelligence is a prominent strength of SQL Server 2005. Features
have been added to Analysis Services, Integration Services has replaced Data
32
Part I: SQL Server 2005: An Overview
06_577557 ch02.qxp 12/20/05 9:43 PM Page 32