Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”
Sign in
Sign in
or
Create a new account
About
Categories
Delivery Methods
Solutions
Resources
 Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

Game changer SQL server

  • By Priyanka D.
  • on 01/29/2025

What do you like best about the product?
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 the product?
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 the product 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.

Leave a Comment

There are no comments to display