Search This Blog

SQL Server 2008 :Online Transaction Processing(OTP) Summary Top New Features

Top New Features

  • Resource Governor

  • Support for relational data, XML, FILESTREAM, and spatial data Watch the short video.

  • Data compression and sparse columns

  • Automatic recovery of suspect pages

  • Visual designer, and add nodes to a peer-to-peer replication configuration without stopping system activity

  • Extended Events (Xevents) Watch the short video.

  • Enhanced database mirroring Watch the short video.

  • Automatic, transparent data encryption

  • Use Performance Data Collection to troubleshoot, tune, and monitor

  • Use Policy-Based Management to manage one or more instances of SQL Server 2008 Watch the short video.