SQL Server – Windows 32 bit – SQL Server v2014


Reviewing Memory Utilization on one of our boxes.



Windows Version

Control Panel



  1. Windows Server 2008 Enterprise

Performance Monitor


Metrics – [ SQL Server Instance ] – Memory Manager



  1. Stolen Server Manager ( KB ) :- 448,400.000
  2. Target Server Memory ( KB ) :- 1,531,904.00
  3. Total Server Memory ( KB ) :- 1,516,648.00


SQL Server




Microsoft SQL Server 2014 (SP2-CU6) (KB4019094) – 12.0.5553.0 (Intel X86)
Jun 28 2017 14:05:44
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing on Windows NT 6.0 <X86> (Build 6002: Service Pack 2) (VM)


  1. We are running MS SQL Server 2014 / SP2 ( CU-6 )
  2. Enterprise Edition: Core-based Licensing on Windows NT 6.0 <X86>
    • Windows NT 6.0
      • Windows Server 2008
    • X86
      • 32 bit OS


In terms of Engineering, can we do more.



The “awe enabled” SQL Server feature is deprecated.


In Microsoft SQL Server 2008 R2, the configuration option, awe enabled, is deprecated. In the next version, Microsoft SQL Server 2012, this configuration option and the feature that uses this configuration option are removed from the product.

Therefore, when you upgrade from SQL Server 2008 R2 to the next version of SQL Server, you cannot use more memory than what the virtual address space limits in 32-bit instances of SQL Server. If you must have more memory for this instance of SQL Server, then you have to migrate to a 64-bit instance of SQL Server.

Operating System & SQL Server v2012+ Max Memory

SQL Server and operating system settings Maximum amount of memory used by SQL Server
32-bit SQL Server on 32-bit OS 2 GB
32-bit SQL Server on 32-bit OS with /3G boot option 3 GB
32-bit SQL Server on 64-bit OS 4 GB


As always keep in mind what your end goal is and what engineering constraints are holding you back.

SQL Server / Minimum OS Software Requirement


Wanted to tabulate the minimum MS Windows OS Requirement for the various versions of MS SQL Server.


Minimum OS Support Matrix

SQL Server Version OS Version – Server OS Version – Desktop Bitness Link
v2017  Windows Server 2012  Windows 8 Minimum: x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or fasterDoes not support 32 bit OS
v2016  Windows Server 2012  Windows 8 Minimum: x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or fasterDoes not support 32 bit OS
v2014  Windows Server 2008  Windows 7  x64 Processor
x86 Processor
v2012  Windows Server 2008  Windows Vista x86 Processor: 1.0 GHz
x64 Processor: 1.4 GHz
v2008-R2  Windows Server 2003 Windows Vista
Windows XP
x64 Processor
x86 Processor
v2008  Windows Server 2003 Windows Vista
Windows XP
x64 Processor
x86 Processor
 v2005  Windows Server 2000  Windows Vista
Windows XP
600-megahertz (MHz) Pentium III-compatible or faster processor
1-gigahertz (GHz) or faster processor recommended


 v2000  Windows NT Server 4.0  Windows 98



SQL Server 2017 – Developer Edition – ISO


Currently, I have SQL Server 2014 Developer Edition on my laptop.

Recently found out that since my machine is now Windows 10, I can have SQL Server 2017 Developer Edition.


Download ISO

Let us go download v2017 Developer Edition.

v2017 is available here.




  1. Free Trial Evaluation
  2. Developer edition
  3. Express edition

Developer Edition

If we click on the “Download now” button underneath the “Developer edition“, we will notice that the name of the file that will be availed is SQLServer2017-SSEI-Dev.exe.

Already have that file and it is a small file.

I don’t really want a small file, I want the full ISO.


Self-Prepare ISO

Download Bootstrap

To get a nice ISO, please process with downloading SQLServer2017-SSEI-Dev.exe.


Prepare ISO


  1. Select an installation type
  2. Specify SQL Server Installer download
    • Which package will you like to download
      • ISO
      • CAB
    • Click on the Browser folder button
      • Choose an existing folder or create a new folder
      • Click the OK button
    • Click the OK button
  3. Download Media

Screen shot

Select an Installation Type


Specify SQL Server Installer download

Browse Folder

Download Media

Download Successful



Once the files was packaged into a nice ISO, was able to install it.



So unfortunately, it appears that one cannot download v2017 as a nice offline ISO.

But, please do not let that overly deter you.

Go ahead and download SQLServer2017-SSEI-Dev.exe and run it.

You will be able to prepare an ISO through running that package.

SQL Server Versions / OS Requirements


Still caught in the throng of upgrading MS SQL Server instances to the latest supported by individual applications.

But, in all honesty the holding cell is more likely the age of the machine, bitness (32 or 64 bit),  and the underlying OS.

OS Requirements Matrix

SQL Server Version OS Version – Server OS Version – Desktop Link
MS Windows
SQL 2016 Windows 2012, Windows 2016 Windows 8, Windows 10  Link
SQL 2014 Windows 2016, Windows 2012/R2, Windows 2012, Windows 2008/R2, Windows 2008 Windows 8, Windows 7  Link
SQL 2012 Windows 2012, Windows 2008/R2 Windows 8, Windows 7,
Windows Vista
SQL 2008-R2  Windows 2012, Windows 2008/R2, Windows 2008, Windows  2003  Windows 7, Windows Vista  Link
SQL 2008 Windows 2012, Windows 2008/R2, Windows 2008, Windows  2003  Windows XP, Windows Vista, Windows 7  Link
SQL 2005  Windows 2003, Window 2000  Windows XP  Link



  1. Microsoft
    • Docs / SQL / SQL Server / Install
      • Hardware and Software Requirements for Installing SQL Server
        • SQL Server v2016
        • SQL Server v2014
        • SQL Server v2012
        • SQL Server v2008-R2
        • SQL Server v2008
  2. Pearson
    • Inform IT
      • v2005
        • SQL Server Robert Beatty, SQL Server 2005 Setup and Deployment


SQL Server Life Cycle Support



My Director has been behind for a while here.

The imperatives are:

  1. Prepare Inventory list of all SQL Server Installs; the server name and current Version Number
  2. Apply latest Service Packs to all SQL Server Instances that are out of compliance
  3. Chart Upgrade path for the next few years to ensure that we narrow the list of versions that we are supporting


SQL Server Life Cycle Support

Stated below are the “Release to Manufacturing” (RTM) and Last Service Pack dates for the various versions of SQL Server.

We also noted the End of Mainstream and End of Extended Support where one has been officially announced by Microsoft.


Version Service Pack Release Date End of Mainstream End of Extended
SQL 2016 SP1 RTM :-  2016-June-1st
SP1   :-   2016-Nov-16th
 SQL 2014  SP2 RTM :- 2014-April-1st
SP2   :- 2016-July-11th
 SQL 2012  Sp3 RTM :- 2012-Mar-6th
SP3 :- 2015-Nov-23rd
 SQL 2008/R2  SP3 RTM :- 2010-April-21st
SP3 :- 2014-Sept-26th
 July 8th, 2014  July 9th, 2019
 SQL 2008  SP4 RTM :- 2008-April-7th
SP4 :- 2014-Sept-30th
 Jan 14th, 2014  Jan 8th, 2019
 SQL 2005  Sp4 RTM :- 2005-Nov-7th
SP4 :- 2010-Dec-17th
 April 12th, 2011  April 12th, 2016
 SQL 2000  SP4 RTM :- 2000-Nov
SP4 :- 2005-May-6th
 April 2008  April 9th, 2013




  1. v2005, v2000
    • Upgrade all current installs to 2014 and v2016
  2. v2008 & v2008/R2
    • Identify instances running v2008 and v2008/R2
    • Consult with clients and corresponding vendors
    • Plan and target upgrade for 2nd and 3rd quarter 2017 and First half of 2018

Current Landscape

  1. We do not have any SQL Instances running v2000, v2005, v2008
  2. We have 5 instances running v2008-R2



Microsoft – SQL Server Release Services

  1. 2008 and 2008-R2
    • End of Mainstream support for SQL Server 2008 and SQL Server 2008 R2
  2. 2000
    • End of Extended Lifecycle Support for SQL Server 2000 Service Pack 4


Products & Service Pack

SQL Server 2014

  1. SQL Server 2014 – RTM
  2. Server & Tools Blogs > Data Platform Blogs > SQL Server Release Services
    SQL Server 2014 Service Pack 2 is now Available !!!


Toad World – Release Date Calendar

  1. SQL Server 2008 Release Date Calendar
  2. SQL Server 2005 Release Date Calendar
  3. SQL Server 2000 Release Date Calendar

Microsoft Build Versions

  1. All
    1. SQL Server and Updates Builds Numbers
  2.  v2016
    • SQL Server 2016 build versions
  3. v2014

Service Pack List

  1. Microsoft SQL Server Version List

SQL Server – Transact SQL – Query SQL Server for Version Info


Still amazes me that it is difficult to translate SQL Server Version Numbers to the Marketing Name.

Here is one way.


There is nothing special here, but wanted to keep it and come back and update as time goes on.

Query Code

; with cteProductVersion
			    [productVersion] = serverproperty('ProductVersion')

			 ,  [productVersionMajor] 
					= parseName
					      cast(serverproperty('ProductVersion') as sysname)
						, 4

			 ,  [productVersionMinor] 
					= parseName
					      cast(serverproperty('ProductVersion') as sysname)
						, 3

			 ,  [productVersionMajorAndMinor] 
					= cast
								cast(serverproperty('ProductVersion') as sysname)
								, 4
							+ '.'
							+ parseName
								cast(serverproperty('ProductVersion') as sysname)
								, 3
							as decimal(6, 2)


			= case ctePV.[productVersionMajorAndMinor] 
						when 12 then '2014'
						when 11 then '2012'
						when 10.5 then '2008-R2'
						when 10 then '2008'
						when 9 then '2005'
						when 8 then '2000'
						else ''
        , [edition] 
			= cast(serverproperty('edition') as sysname)

        , [engineedition] 
			= cast(serverproperty('engineedition') as sysname)

        , [productLevel] 
			= cast(serverproperty('productLevel') as sysname)

        , [ProductUpdateLevel]
			 = cast(serverproperty('productUpdateLevel') as sysname)

        , [productBuild] 
			= cast(serverproperty('productBuild') as int)

        , [productBuildType]
			 = cast(serverproperty('ProductBuildType') as sysname)

        , [ProductVersion]
            = cast(serverproperty('ProductVersion') as sysname)

        , [@@version] = @@version 

        , [ProductMajorVersion]
            = cast(serverproperty('ProductMajorVersion') as int)

        , [ProductMinorVersion]
            = cast(serverproperty('ProductMinorVersion') as int)

        , [IsXTPSupported]
            = cast(serverproperty('IsXTPSupported') as bit)

        , [InMemory]
            = case isNull(cast(serverproperty('IsXTPSupported') as bit), 0)
                    when 0 then 'No'
                    else 'Yes'

from cteProductVersion ctePV





MS SQL Server – Get Version Information – Base Product

Here are a few ways to get MS SQL Server Version information

–Version: MS SQL Server MS SQL Server v2000 and later
select serverproperty(‘productVersion’) as productVersion
select serverproperty(‘edition’) as Edition
select serverproperty(‘productLevel’) as productLevel
–Version: MS SQL Server MS SQL Server v2000 and later
exec master.dbo.xp_MSver ‘ProductVersion’
exec master.dbo.xp_MSver ‘FileVersion’
exec master.dbo.xp_MSver


Version: MS SQL Server MS SQL Server v2000 and later
exec master.dbo.sp_server_info 2  –‘DBMS_VER’
exec master.dbo.sp_server_info 500 –‘SYS_SPROC_VERSION’ 

And, of course, the venerable
  select @@version