MS SQL 2012 Always On + Windows 2008 R2 SP1 구성 후 패치

Windows 2008 R2 SP1 에서 MS SQL 2012 으로 Always On을 구성하였다면, 아래 패치 정보를 확인해야 합니다.

 

Windows 2008 R2

- 설치된 OS의 버전이 2008 R2에 SP1 이 적용되어 있다면, 아래의 Hotfix를 설치하셔야 합니다.

 

패치의 내용은 아래와 같습니다.

제목 : A hotfix that improves the performance of the "AlwaysOn Availability Group" feature in SQL Server 2012 is available for Windows Server 2008 R2

 

내용 : To resolve this issue, install the following hotfix. This hotfix improves the performance of the AlwaysOn Availability Group feature in SQL Server 2012 so that failover occurs more quickly.

 

http://support.microsoft.com/kb/2687741/en-us

https://support.microsoft.com/en-us/help/2687741/a-hotfix-that-improves-the-performance-of-the-alwayson-availability-gr

 

MS SQL 2012 Ent

- 설치된 MS SQL 2012의 버전이 SP1 or SP2가 적용되었다면, Hotfix 가 적용되었는지 확인해야 합니다.

 

제목 : FIX: Data corruption occurs in clustered index when you run online index rebuild in SQL Server 2012 or SQL Server 2014

 

내용 : A supported hotfix is available from Microsoft.

However, this hotfix is intended to correct only the problem that is described in this article.

Apply this hotfix only to systems that are experiencing this specific problem.

 

http://support.microsoft.com/kb/2969896/en-us

https://support.microsoft.com/en-us/help/2969896/fix-data-corruption-occurs-in-clustered-index-when-you-run-online-inde