BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!

SQL Server 2008 R2 SP1 Brings Easier Schema Upgrades, Improved Query Performance

by Roopesh Shenoy on Jul 22, 2011 |

SQL Server 2008 R2 SP1 brings several features such as DAC Framework for easier schema upgrades, new DMVs and XEvents for better supportability, Improved Query Performance with ForceSeek and ForceScan and Disk space control for PowerPivot.

A brief explanation of the new features introduced -

  • Data-tier Application Component Framework (DAC Fx) DAC allows the database schema of an application to be packaged as a Data-tier Application; now using an upgrade wizard enables an in-place upgrade service, making it much easier to deploy schema changes.
  • sys.dm_query_stats Dynamic Management View is extended with additional columns to improve supportabilities over troubleshooting long-running queries. There are also some new DMVs for monitoring OS configurations and resource conditions
  • FORCESEEK now takes optional parameters to give greater flexibility. FORCESCAN hint has been added, which combines with FORCSEEK to force and index ‘scan’.
  • Disk space control in PowerPivot for SharePoint - two new configuration settings that let you determine how long cached data stays in the system. You can now specify how long an inactive database remains in memory before it is unloaded and limit how long a cached file is kept on disk before it is deleted.

There is also a list of bugs fixed in the Service Pack, which rolls up all the updates 1 through 6 for SQL Server 2008 R2.

SQL Server 2008 R2 Feature pack, which was also previewed alongside the SP1 in April, was also released recently, and is available for download. The Release announcement coincided with the CTP3 release of SQL Server 'Denali'.

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT