# Microsoft SQL Server 2017 Enterprise on Windows Server 2016 Reviews **Vendor:** Amazon Web Services (AWS) **Category:** [AWS Marketplace Software](https://www.g2.com/categories/aws-marketplace) **Average Rating:** 4.4/5.0 **Total Reviews:** 8 ## About Microsoft SQL Server 2017 Enterprise on Windows Server 2016 The SQL Server Amazon Machine Images (AMI) is built, updated, and fully-patched by AWS within five business days of Microsoft's patch Tuesday (the second Tuesday of each month). Launching an instance from this AMI enables you to run the instance as a database server and saves you the effort to install SQL Server software. This AMI comes with following software and drivers including AWS Systems Manager, AWS CloudFormation, AWS Tools for Windows PowerShell, Network drivers, and Storage drivers. You can use AWS Launch Wizard to easily size, configure, and deployment SQL Server applications on AWS. Launch Wizard for SQL Server supports both single instance and high availability deployments according to AWS and SQL Server best practices. ## Microsoft SQL Server 2017 Enterprise on Windows Server 2016 Pros & Cons **What users like:** - Users value the **performance enhancements** of SQL Server 2017, noting improved memory management and efficient query processing. (2 reviews) - Users value the **robust community support** of Microsoft SQL Server 2017 Enterprise, enhancing their deployment and experience. (1 reviews) - Users value the **advanced analytics capabilities** of SQL Server 2017, allowing seamless data analysis without relocation. (1 reviews) - Users find the **deployment ease** of Microsoft SQL Server 2017 Enterprise on Windows Server 2016 very beneficial and efficient. (1 reviews) - Users appreciate the **reliable and scalable database engine** of Microsoft SQL Server 2017 Enterprise for enterprise use. (1 reviews) - Scalability (1 reviews) **What users dislike:** - Users report that SQL Server 2017 can be **complex to code** , making it challenging for those with limited resources. (1 reviews) - Users find the product **not very beginner friendly** and unsuitable for small projects, adding to the overall complexity. (1 reviews) - Users find the **limited flexibility** of SQL Server 2017 challenging, especially in resource-constrained environments. (1 reviews) - Users find **performance issues** with SQL Server 2017 in limited-resource environments, impacting functionality for smaller applications. (1 reviews) - Users find the **required expertise** for SQL Server 2017 challenging, making it unsuitable for small projects. (1 reviews) - Slow Performance (1 reviews) ## Microsoft SQL Server 2017 Enterprise on Windows Server 2016 Reviews ### 1. Game changer SQL server **Rating:** 4.0/5.0 stars **Reviewed by:** Priyanka D. | Senior IT Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** January 29, 2025 **What do you like best about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** It has introduced several performance enhancements, including better memory management and more efficient query processing. It allows to run advanced analytics on data stored in SQL Server without needing to move the data elsewhere. **What do you dislike about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** SQL Server 2017 is pretty resource-intensive. While it’s designed for high-performance workloads, it can be overkill for smaller or less complex systems. If you're running on Windows Server 2016 with limited resources (especially in smaller environments), you might find performance is impacted unless you have a powerful enough setup. Even with optimizations, the memory and CPU consumption can sometimes be excessive for smaller-scale applications. **What problems is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 solving and how is that benefiting you?** SQL Server 2017 comes with Adaptive Query Processing, which helps optimize queries based on workload patterns in real-time. Features like Automatic Tuning and Intelligent Query Processing automatically adjust execution plans, helping to improve performance without manual intervention. ### 2. The best SQL Database Engine for Enterprise Applications. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 25, 2025 **What do you like best about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** Very powerful and scalable database engine. All necessary and esssential features are included. Is enterprise ready and easily deployable. **What do you dislike about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** Not very beginner friendly and not suitable for small projects. **What problems is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 solving and how is that benefiting you?** Our application is relies on complex stored procedures and complex data models. Once the schema is designed with proper indexing, we were quickly able to deploy it to SQL Server. Moreover SQL server also supports code first migrations so for newer applications, it can take the schema from the application data model (which we are using to develop new internal APIs). ### 3. Best RDBMS solution with always on features **Rating:** 5.0/5.0 stars **Reviewed by:** Viral S. | Software Solutions Architect, Enterprise (> 1000 emp.) **Reviewed Date:** December 11, 2024 **What do you like best about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** Always on feature and heatbeat monitoring **What do you dislike about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** CPU and memory utilization where showing high, although didn't found any performance impact. **What problems is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 solving and how is that benefiting you?** ensures availailability of the overall solution, we were looking for RDBMS and wanted to move from logshipping to always on feature. which SQL server 2017 did provided. ### 4. SQL Server 2017 Enterprise edition a need of an hour for large scaled businesses **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2023 **What do you like best about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** MS SQL 2017 Enterprise edition supports graph databases which are useful when search operation crucial. Enhanced security protection like Backup encryption. Support for linux and docker containers. **What do you dislike about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** Nothing as such only thing is initial package installation size is large which can be reduced. **What problems is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 solving and how is that benefiting you?** To store large amount of business data in optimized way and to perform business intelligence operation on it by making it available all the time. ### 5. Microsoft SQL Server 2017 - Simple and Good **Rating:** 4.0/5.0 stars **Reviewed by:** Mohammed Shams T. | .NET Developer, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** February 18, 2023 **What do you like best about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** It is very simple and user-friendly for beginners. Shows output in different views but can be improved. You can manage many tasks in different tabs and retrieve them if accidentally closed. **What do you dislike about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** The output views can be improved. Does not have different types of color theam to make a suitable environment for the user **What problems is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 solving and how is that benefiting you?** Manage database for software and websites. It helps in checking, and resoving issues faced any time. ### 6. Microsoft SQL Server 2017 Enterprise - Proven platform for enterprise your database operations **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Government Administration | Mid-Market (51-1000 emp.) **Reviewed Date:** August 09, 2022 **What do you like best about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** Ease of deployment and installation. Integrates very well with other Microsoft products and the cloud. Very easy administration with Microsoft SQL Manager. Ability to run SQL script on the management console. **What do you dislike about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** Sometimes databases need to be repaired/recovered after certain restoration operations when restoring from DB backup. It would have been nice to have a repair option in the interface instead of using the SQL commands to attempt recovery with the restore option. **What problems is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 solving and how is that benefiting you?** Microsoft SQL Server 2017 on Windows 2016 is our main database warehouse for managing all databases within multiple RDBMS platforms. From a single management console, we can easily operate and recover all our databases. In the past we were running several versions on different databases (including different vendors). Management of all those systems required skills as well as a learning curve. Having migrated to a single uniform platform allowed us to manage our database more efficiently and efectifely. ### 7. SQL Server 2017 - Improved Drastically **Rating:** 4.5/5.0 stars **Reviewed by:** Sayam J. | Software Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** August 27, 2022 **What do you like best about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** Easy to Use and easy to implement in the Premise. It is one of the most user-friendly DBMS which is maintaing our data securely and robustly. **What do you dislike about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** Almost every feature that a enterprise needs it caters but the charges are much higher for the same. **What problems is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 solving and how is that benefiting you?** It helped us to implement the AD, Partitioning and other DBMS features ### 8. Easy to use, very straightforward **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 16, 2021 **What do you like best about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** straightforward installation. Many documents for reference and the community is huge. **What do you dislike about Microsoft SQL Server 2017 Enterprise on Windows Server 2016?** sometimes DB seems slow and with the operating system getting stucked **Recommendations to others considering Microsoft SQL Server 2017 Enterprise on Windows Server 2016:** Design with high availability **What problems is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 solving and how is that benefiting you?** easy to manage, make life easy ## Microsoft SQL Server 2017 Enterprise on Windows Server 2016 Discussions - [What is Microsoft SQL Server 2017 Enterprise on Windows Server 2016 used for?](https://www.g2.com/discussions/what-is-microsoft-sql-server-2017-enterprise-on-windows-server-2016-used-for) - [View Microsoft SQL Server 2017 Enterprise on Windows Server 2016 pricing details and edition comparison](https://www.g2.com/products/microsoft-sql-server-2017-enterprise-on-windows-server-2016/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-12+02%3A05%3A15+-0500&secure%5Bsession_id%5D=71f184de-6fcd-484d-b8e3-cd0308d9a4a0&secure%5Btoken%5D=312a4d6444981fb066566e16a7d4e673fa16785d48f36ff08d0b231cb60274a3&format=llm_user) ## Microsoft SQL Server 2017 Enterprise on Windows Server 2016 Features **Agentic AI - AWS Marketplace** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration