SQLServerUpdates.com
  • Home – Most Recent Updates
    • SQL Server 2019 Updates
    • SQL Server 2017 Updates
    • SQL Server 2016 Updates
    • SQL Server 2014 Updates
    • SQL Server 2012 Updates
    • SQL Server 2008 R2 Updates
    • SQL Server 2008 Updates
  • Download SQL Server
  • Subscribe to Updates
  • Contact Us
    • Frequently Asked Questions

SQL Server 2012 SP3 Now Available for Download

8 years ago
Brent Ozar
SQL Server 2012, Updates
6 Comments

Can’t decide between cranberry sauce or mashed potatoes for your side dish? Consider Service Pack 3 for SQL Server 2012 instead, which brings these hot fixins:

  • Update for dm_exec_query_stats to track memory grants – adds a whole new set of fields to the DMV!
  • New query memory grant options available (min_grant_percent and max_grant_percent) – yes, new query hint options to specify RAM for a query!)
  • Access violation occurs when you enable TDE
  • Improved diagnostics for query plans with residual predicate pushdown
  • Spatial performance improvements
  • DBCC CHECKDB/CHECKTABLE performance improvements
  • Stalled dispatcher system dump forces failover
  • Improvements for AlwaysOn Lease Timeout
  • Improved tempdb spill diagnostics in the plan and XE

These are pretty doggone big improvements to go out in a service pack. Check out the full list of fixes.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
SQL Server 2012 SP2 CU9 is out
Next Post
New SQL Server 2014 CU11 and SP1 CU4 Available for Download

6 Comments. Leave new

  • SQL Server 2012 SP3 | Curated SQL
    November 23, 2015 2:20 pm

    […] Server 2012 SP3 is now available.  Brent Ozar has details.  Kendra Little has details on memory […]

    Reply
  • Mahesh Chintamani
    November 23, 2015 8:01 pm

    Ok

    Reply
  • Database Department
    June 29, 2016 9:09 am

    Thank you

    Reply
  • Dave Robinson
    August 25, 2016 2:41 pm

    Too bad that you could not also mention WHERE to download it!

    Reply
    • Dave Robinson
      August 25, 2016 2:42 pm

      Never mind…I just saw your link. Sorry for the criticism. It was unwarranted.

      Reply
      • Brent Ozar
        August 25, 2016 2:47 pm

        Hahaha, no worries.

        Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Subscribe

Want to get an email when Microsoft publishes a new SP or CU for SQL Server? Subscribe here.

Recent Updates

  • SQL Server 2022 CU3: How Stella Got Her Groove Back April 13, 2023
  • SQL Server 2022 Gets Its 2nd Update in 2 Days February 16, 2023
  • SQL Server 2022 Gets Its First Update! Plus 2019, 2017, 2016, 2014 Updates February 14, 2023
  • Announcing SQL Server 2019 CU15 January 27, 2022
  • Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements October 5, 2021

© 2021 Brent Ozar Unlimited®. All Rights Reserved. Privacy Policy