SQL Server Review

Good SSMS and profiling tools that work well for internal applications

What is our primary use case?

We use SQL Server for our internal applications.

What is most valuable?

Working with SQL Server, it is quite convenient to use the SSMS tools to write a profile. I also like the profiling tools.

I like that the new version has a memory-optimized table to improve the performance.

What needs improvement?

We had some difficulty doing the performance tuning when we migrated from the 2008 version to the 2016 version. We experienced a drop in the performance. We could not understand or figure out what caused the drop in performance. We did not change any settings to cause this effect. We tried to keep the same settings.

We feel that when running the 2008 version, it was much quicker in terms of performance. 

That is an area of SQL Server that can be improved. Moving to a new version, you shouldn't have to change the configuration.

We have not been able to utilize it fully because it is not straightforward.

I would like to see the performance improved. Migrating should be easier and the scalability needs improvement.

For how long have I used the solution?

I have been using this solution for many years. 

We are using version 2016.

What do I think about the stability of the solution?

It's a stable product.

What do I think about the scalability of the solution?

In terms of scalability, it has some room for improvement.

We have 20 people in our organization who are using this solution.

How are customer service and technical support?

We don't usually get support from Microsoft. We get it from our software vendors or we try to do it ourselves.

We are somewhat satisfied with the support that we have received from the vendor, but not fully because of the issue we faced when we moved to a newer version. But in other areas, it's okay.

Which solution did I use previously and why did I switch?

We have used SQL Server from the beginning.

How was the initial setup?

The initial setup was moderate. It was not easy but it was not difficult.

What other advice do I have?

I would rate SQL Server a nine out of ten.

Which deployment model are you using for this solution?

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More SQL Server reviews from users
...who work at a Financial Services Firm
...who compared it with Oracle Database
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: July 2021.
523,535 professionals have used our research since 2012.
Add a Comment
ITCS user