·
1 min read

The Fantastic 12 of 2012: A Behind the Scenes View of Blazing Fast Performance

Last week we kicked off the Fantastic 12 of 2012: Behind the Scenes Blog Series, the first episode covering SQL Server AlwaysOn was just the beginning of this unique 12-part look into the SQL Server Engineering Team.

In this second episode of the series, Michael Rys, Principal Program Manager, SQL Server Engine Team talks about his recent trip to the SQLBits X conference in London and the feedback he received from other attendees. Michael also answers the most frequently asked question he heard while attending the event.

Lastly, this week we announced The Fantastic 12 of #SQL2012 Twitter Contest where we will be giving away the new SQL Server T-Shirts as chosen by the SQL Family. Don’t forget to join in on the fun as the contest questions come directly from the SQL Server Engineering Team members featured in the video series and sporting their favorite new shirts!

Now on to this week’s episode….

2   Blazing-Fast Performance
Gain breakthrough & predictable performance backed by industry-leading benchmarks

Accelerated Query Performance

  • ColumnStore Index: Significantly boost data warehouse query performance, by up to 10x for star join and similar queries, using the new ColumnStore Index—built-in.
  • Full Text Search: Support blazing fast queries with dramatic improvements to Full-Text Search that offer serious performance and scale advances.
  • Compression: Accelerate the performance of I/O intensive workloads by cutting growing volumes of data 50-60%1 with back up and data compression capabilities.
  • Improved Spatial Query Performance: New Indexing options, supporting nearest neighbor queries with indexes.

Proactive Performance Management

  • Resource Governor: Gain consistent performance for concurrent and mixed workloads by defining resource usage across different applications.
  • Management Tools: Analyze query execution plans, capture database activity, optimize indexes and structures, and help ensure consistent query performance within Management Studio.

Industry-Verified

  • Benchmarks: SQL Server continuously leads in industry-relevant TPC-E and TPC-H performance benchmarks.
  • SAP-Certified: Release over release SQL Server is SAP-certified to run some of the industry’s most demanding workloads.

¹Source: TechNet Books Online

Stay tuned for the next episode of this series coming every Thursday through the end of June 2012.