- Community Home
- >
- Servers and Operating Systems
- >
- ProLiant
- >
- ProLiant Servers (ML,DL,SL)
- >
- What Operating System to use for Microsoft SQL Ser...
-
-
Forums
- Products
- Servers and Operating Systems
- Storage
- Software
- Services
- HPE GreenLake
- Company
- Events
- Webinars
- Partner Solutions and Certifications
- Local Language
- China - 简体中文
- Japan - 日本語
- Korea - 한국어
- Taiwan - 繁體中文
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Latin America
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Blog, Poland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Forums
-
Blogs
-
Information
-
English
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-30-2018 06:37 AM
01-30-2018 06:37 AM
What Operating System to use for Microsoft SQL Server 2014 Standard on ProLiant DL360e
Dear Sir or Madam, Dear HPE Server Experts,
my boss has one license Microsoft SQL Server 2014 64 Bit and one HPE ProLiant DL360e with 16 GB RAM and B120i Controller.
Now I recommended him to buy additional 2x 32 GB RAM and two Server SSDs as well as the Microsoft Windows 2012 R2 Server ROK to install for him the Microsoft SQL 2014 Standard and copy his database of the ERP to the "new" Serverhardware.
I was wondering if I should install Microsoft Windows 2012 R2 Server with GUI or as core installation to get best performance as dedicated database server?
I am looking forward also to move from SQL Server Management Studio report the recommended tables to in memory with OLTP.
Any other recommondations from HPE server experts to get quick server for the 20 GB database (current size) running with max. possible speed on DL360e maybe by installing some other additional hardware or software?
Thinking also about to let Microsoft SQL Server run on linux based os, but Microsoft SQL Version 2014 does not support this. Maybe Update to 2015 or 2016 recommended and installation on clear OS (instead Microsoft stack) to get much better performance? Are there any public benchmark comparisons, regarding this, available?
Recommondations, datasheets, whitepapers preffered in german language, because boss is not used englisch language so good.
Seeing forward to get feedback from the HPE server experts.
Dirk
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-30-2018 07:57 AM
01-30-2018 07:57 AM
Re: What Operating System to use for Microsoft SQL Server 2014 Standard on ProLiant DL360e
Hello Dirk,
- Unless your server has a very high resource usage for SQL server, you will probably not see a performance difference between the GUI installation and the Core installation. The benefits to the core installation are a smaller attack surface, and smaller and less frequent updates. The core installation will not be as easy (initially) for installation, configuration, and maintenance of the OS and applications. This will depend on your current experience with Core and using Powershell and remote consoles for configuration.
- For running SQL on linux as compared to Windows, the differences will be in hardware and configuration, and not so much in the OS difference. I have not found any benchmark testing yet, but I will update you if I find some new information.
Geo
If this helps you with your issue, please click the thumb to register a Kudo.
If it resolves the issue, please consider marking it as an Accepted Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-30-2018 08:08 AM
01-30-2018 08:08 AM
Re: What Operating System to use for Microsoft SQL Server 2014 Standard on ProLiant DL360e
Hello dirklehmannkg
SQL 2014 can be ran on any of the following O/S's. see https://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx:
Windows Server 2016 Datacenter
Windows Server 2016 Standard
Windows Server 2012 R2 Datacenter 64-bit
Windows Server 2012 R2 Standard 64-bit
Windows Server 2012 R2 Essentials 64-bit
Windows Server 2012 R2 Foundation 64-bit
Windows Server 2012 Datacenter 64-bit
Windows Server 2012 Standard 64-bit
Windows Server 2012 Essentials 64-bit
Windows Server 2012 Foundation 64-bit
Windows Server 2008 R2 SP1 Datacenter 64-bit
Windows Server 2008 R2 SP1 Enterprise 64-bit
Windows Server 2008 R2 SP1 Standard 64-bit
Windows Server 2008 R2 SP1 Web 64-bit
Windows Server 2008 SP2 Datacenter 64-bit
Windows Server 2008 SP2 Enterprise 64-bit
Windows Server 2008 SP2 Standard 64-bit
Windows Server 2008 SP2 Web 64-bit
A core installation is possible with the following O/S's:
Windows Server 2012 R2 Datacenter 64-bit
Windows Server 2012 R2 Standard 64-bit
Windows Server 2012 Datacenter 64-bit
Windows Server 2012 Standard 64-bit
Windows Server 2008 R2 SP1 Datacenter 64-bit
Windows Server 2008 R2 SP1 Enterprise 64-bit
Windows Server 2008 R2 SP1 Standard 64-bit
Windows Server 2008 R2 SP1 Web 64-bit
The addition of extra RAM usually leads to improved performance, but the actual gains will depend on the load that is placed on the server by SQL. SSD's also will improve boot times and operations.
A 20 GB database, along with the additional memory should allow the entire database to operate from memory, thereby limiting disk swapping dramatically.
As to using a Core installation as opposed to a GUI, the Core will indeed function faster, but at the cost of somewhat more difficult management.
So much depends on the actual utilization of the server -- I/O load, overhead, transactions per second, etc. It is not possible to accurately predict how a particular SQL implementation will perform, since the variability of the load will be dependent on the customers specific environment and needs.
Here is a Microsoft article that explores some of the basics regarding memory sizing for SQL 2014:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-30-2018 08:21 AM - edited 01-30-2018 08:22 AM
01-30-2018 08:21 AM - edited 01-30-2018 08:22 AM
Re: What Operating System to use for Microsoft SQL Server 2014 Standard on ProLiant DL360e
Further information:
- Microsoft SQL Server 2017 is the version needed to run on Linux.
- Here is an official benchmark I was able to find:
https://www.microsoft.com/en-us/sql-server/sql-server-benchmarks-industry
Geo
If this helps you with your issue, please click the thumb to register a Kudo.
If it resolves the issue, please consider marking it as an Accepted Solution.
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2022 Hewlett Packard Enterprise Development LP