SQL Server Review

Good system architecture but they need to implement load-balancing capabilities


What is our primary use case?

We are currently developing our own business application and we are using SQL Server as the database. We deploy it as a .NET application and the webserver is IIS. The SQL is a three-node clustered system.

What is most valuable?

The most valuable feature is the system architecture.

What needs improvement?

The number of concurrent users is too limited and other databases are better than SQL in this regard.

There are limitations with load balancing.

We would like to see support for in-memory processing.

For how long have I used the solution?

We have been using SQL Server for more than seven years.

What do I think about the stability of the solution?

SQL Server is a stable product.

What do I think about the scalability of the solution?

We are the largest micro-credit finance company with more than thirty companies internally. We have 25,000 employees using the business application and SQL does not scale to our requirements.

I think that Oracle is better suited to smaller applications.

How are customer service and technical support?

The supporting sites are good.

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

I have also worked with SAP HANA.

How was the initial setup?

Setting up the database clustering is too complex.

Our current deployment has been ongoing for three years and it is not yet complete because our application is still being developed.

What about the implementation team?

Our in-house team is handling the deployment.

Which other solutions did I evaluate?

We are currently searching for other products to replace this one with.

What other advice do I have?

My advice for anybody who is considering SQL Server is that it works well for small applications. However, large business applications that use a content delivery network or geographical location, it is not suitable for.

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

On-premises

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
**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 Computer Software Company
...who compared it with Oracle Database
Add a Comment
Guest