Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Posts Tagged ‘SQL Server 2016’

SQL server 2016 -T1117 and -T1118

Posted by Simon Cho on 11/28/2016

SQL server 기본 세팅이던 T1117 과 T1118이 SQL 2016에서 변경 되었습니다.

기본적으로 SQL server 2016 Install 시에 둘다 enable이 되는데요.

이를 확인하기 위해서는 다음 script를 실행하시면 됩니다.

Is_Mixed_Page_Allocation_on : 0 =  T1118(Enable)

Is_autogrow_all_files : 1 =  T1117(Enable)





SELECT name, is_mixed_page_allocation_on
FROM sys.databases
WHERE name=’Tempdb’

SELECT is_autogrow_all_files
FROM tempdb.sys.filegroups

SQL 2016 – It Just Runs Faster: -T1117 and -T1118 changes for TEMPDB and user databases

Posted in Common | Tagged: , , , | Leave a Comment »

SQL Server 2016 installation

Posted by Simon Cho on 06/03/2016

SQL Server 2016 is released at 6/1.


SQL Server 2014/2016 Developer edition are free after joining  Visual Studio Dev Essentials.


Before install Please read release note. They ask VC runtime update before installation.


Install Patch Requirement (GA)

Issue and customer impact: Microsoft has identified a problem that affects the Microsoft VC++ 2013 Runtime binaries that are installed as a prerequisite by SQL Server 2016. An update is available to fix this problem. If this update to the VC runtime binaries is not installed, SQL Server 2016 may experience stability issues in certain scenarios. Before you install SQL Server 2016, check to see if the server needs the patch described in KB 3138367 – Update for Visual C++ 2013 and Visual C++ Redistributable Package.

KB 3138367 is required if the build version of msvcr120.dll is not 12.0.40649.5 or higher. To check the file build version:

  1. Open Windows Explorer.
  2. Navigate to %SystemRoot%\system32\msvcr120.dll.
  3. Right-click the file and then click Properties.
  4. Click the Details tab.
  5. Verify the file version is 12.0.40649.5 or higher.

If the build version of msvcr120.dll is not 12.0.40649.5 or higher you need to install KB 3138367.

Resolution: To install this required update, download and run the appropriate vcredist_*.exe based on your system language and architecture from KB 3138367.

If you have SQL Server 2016 installed on a computer that needs KB 3138367, do the following steps in order:

  1. Download the appropriate vcredist_*exe.
  2. Stop the SQL Server service for all instances of the database engine.
  3. Install KB 3138367.
  4. Reboot the computer.


Posted in Common | Tagged: , , | Leave a Comment »