Advertisements

Archive

Posts Tagged ‘SQL Patches & Hotfixes’

Issues with CU6 for SQL Server 2014 SP1

June 14, 2016 2 comments

Microsoft released an update to CU6 (link) for SQL Server 2014 SP1; this update was to address an issue where even having NOLOCK hint in queries was leading to blocking and deadlocks in the default SQL Server lock-based isolation level or high levels. From the KB article:

Executing a parallelized SELECT (…) INTO Table FROM SourceTable statement, and specifically using the NOLOCK hint, under the default SQL Server lock-based isolation level or higher. In this scenario, other queries that try to access SourceTable will be blocked.

While one transaction is holding an exclusive lock on an object (for example, an ongoing table update), another transaction is executing parallelized SELECT (…) FROM SourceTable by using the NOLOCK hint. In this scenario, the SELECT query that is trying to access SourceTable will be blocked.

Reference: CU6 for SQL 2014 SP1 (Deprecated) [Link].

Therefore if you have the older build installed (12.0.4449) please update to newer build (12.0.4457).

This post is cross posted on my SQLCAN Blog, MSDN Blog, and SQL server Consultation blog.

 

Advertisements

Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable

May 19, 2015 3 comments

Corruption issue should be treated as critical, as if gone undetected they are difficult to recover from without data loss.

The corruption can happen when changing readability property of the secondary database.  However only if the database is using data compression.  Please review and test the linked CUs if you are using AlwaysOn Availability Groups and Data Compression with your environment.

Microsoft SQL Server 2012 SP2 CU6 (link) and Microsoft SQL Server 2012 SP1 CU16 (link) released.

SQL Server Patches and Hotfix Notification

December 1, 2014 3 comments

I often get asked, if there is an easy way to get notifications for Patches and Hotfixes for SQL Server.  Generally I recommend people keep an eye on http://sqlserverbuilds.blogspot.com.  However I just came across another site that can be used, http://blogs.msdn.com/b/sqlreleaseservices/default.aspx.  Unlike the SQL Server Builds website, you can subscribe to RSS feed on MSDN site, this way whenever Microsoft releases update you can review it right away.  I really give kudos to who ever is maintain SQL Server Builds website; by far the most compressive and easy to use site for SQL Server build details.  So both sites in conjunction, I think are beneficial links to have in your favorites for patching and hotfix release information.

As Microsoft best practices we recommend you keep your servers up-to-date on latest service pack level.  It can be challenging in my scenarios; however, if you know what fixes are being released and what are their impact.  Then you can have an proactive discussion with business owner and management on why certain patch level is required.

For example, lets say the patch required because of memory leak, or corruption fix, etc.  These kind of patches you don’t want to wait for until you run into issue, we need to be proactive about addressing this to maximum the availability and uptime for service provided by SQL Server.

SQL Server 2008 SP4 and SQL Server 2008 R2 SP3 Released!

September 29, 2014 2 comments

SQL Server 2008 SP4 (link) and SQL Server 2008 R2 SP3 (link) have been released.  Please note these are the final service packs for these products is now in Extended Support cycle of Product Support Life Cycles.

Update Sept. 30, 2014: Sorry for mistake, for SQL Server 2008 it would be SP4.

SQL Server 2012 SP1 CU4 Released!

June 6, 2013 Leave a comment

SQL Server Build: 11.0.3368 KB: 2833645

Lots of fixes are in this CU, in addition at least one KB talking about few new features.  One related to syspreping analysis services, integration services, etc.

SQL Server 2012 RTM CU7 Released!

April 19, 2013 Leave a comment

SQL Build: 11.0.2405 KB: 2823247

Quite a few fixes, similar to the ones in SQL 2008 R2 SP1 CU12 and SQL 2008 R2 SP2 CU6.  Some issues specific to SQL 2012 are related to SSAS, fixing performance issues with systems with more then 32-logical processors, access violation issues with FILESTREAM-enabled but data is offline. FULL JOIN, DMV, Log Shipping, etc.

SQL Server 2008 R2 SP2 CU6 Released!

April 18, 2013 Leave a comment

SQL Build: 10.50.4279 KB: 2830140

Many fixes are same as those released for SP1 CU12.  But there are some additional fixes in this CU for PowerPivot, SSRS, Cursors, Encryption, one for Database Mirroring.

SQL Server 2008 R2 SP1 CU12 Released!

April 17, 2013 Leave a comment

Build: 10.50.2874 KB: 2828727

Mostly engine fixes, few fixes for SSAS.  Some interesting fixes around SQL Server freezing on shutdown, Assertion check failed/access volition for partitioning, index size issues with RCSI, data corruption.

SQL 2008 R2 SP1 CU10 Released!

January 10, 2013 Leave a comment

Build: 10.50.2868 KB: 2783135

A few fixes have been made, however for some reason I think I have seem most of this in previous CUs.   Still fixes for the memory leak with AUTO_UPDATE_STATISTICS_ASYNC, non-yeilding schedulers for LOB objects, etc. fixes are included.  So if yo have seen similar issues might be worth looking it.

SQL Server 2008 R2 SP2 CU4 Released!

January 9, 2013 Leave a comment

Build: 10.50.4270, KB: 2777358

Many fixes are rolled up in this KB, some of the interesting ones for me (Since I primary focus on the engine) are..

KB2708012, EventID 833 logged in error log when VSS snapshot backup is taking place and write operating occurs.

This is interesting, because Error 833 is ..

SQL Server has encountered <n> occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [<full path of file>] in database [<database name.>] (<dbid>). The OS file handle is <file handle>. The offset of the latest long I/O is: <offset in hexadecimal>

This is usually you have disk I/O issues, but in this case nope. It is a “internal members of the overlapped structure is not initialized correctly”.

KB2770258, You receive in incorrect result when you run a query against a partitioned table in SQL Server 2008 R2.

There are other issues that have been fixes in this CU, might be worth a quick gander to see if any of these apply to you.

 

 

 

%d bloggers like this: