Share via

Event Review: Technical Overview of SQL Server 2005 Scalability Features (Session TNT1-146)

  • Article
  • 10/07/2009

Welcome to the material supporting page for this session. The materials on this page have been selected as the best matches to the content covered in the live event session.

Session Outline

This session examines several new features in SQL Server 2005 that can increase the scalability of many database solutions. We will look at tables and indexes and how they can be segmented into partitions on disk so they can be accessed separately and so many operations will no longer need to read the entire object on disk. This session also covers the improvements to replication that can increase scalability in Microsoft SQL Server 2005. Merge replication, in particular, features many new improvements that can significantly improve performance. In addition, true peer-to-peer replication topologies are now possible that can increase scalability and availability for both read and write transactions. We will also look at another new feature, database snapshots, which allow for a consistent point-in-time view of data and, while not a scalability feature, can increase scalability when used with database mirroring. The session also covers locking and blocking, which are often a major obstacle for scalable database solutions. Optimistic concurrency controls reduce locking by allowing read queries to query row versions of data that are maintained in tempdb. We will also cover several other improvements to SQL Server 2005 that can also increase scalability.

Session Agenda

Use the following resources to learn more about topics covered in this briefing.

Third-Party Books

  • Microsoft SQL Server 2005 New Features

    Summary: Written by Michael Otey, senior technical editor of SQL Server Magazine, this authoritative resource introduces the new features in the Yukon release, providing a jump start for IT professionals transitioning from SQL Server 7 and SQL Server 2000.