Microsoft SQL Server 2017 Enterprise on Windows Server 2016 Reviews & Product Details

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Very powerful and scalable database engine. All necessary and essential features are included. Is enterprise ready and easily deployable. Review collected by and hosted on G2.com.

Not very beginner friendly and not suitable for small projects. Review collected by and hosted on G2.com.

Always on feature and heatbeat monitoring Review collected by and hosted on G2.com.

CPU and memory utilization where showing high, although didn't found any performance impact. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Nothing as such only thing is initial package installation size is large which can be reduced. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

The output views can be improved.

Does not have different types of color themes to make a suitable environment for the user Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Almost every feature that a enterprise needs it caters but the charges are much higher for the same. Review collected by and hosted on G2.com.

straightforward installation. Many documents for reference and the community is huge. Review collected by and hosted on G2.com.

sometimes DB seems slow and with the operating system getting stucked Review collected by and hosted on G2.com.