Amazon ElastiCache vs Microsoft SQL Server

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Amazon ElastiCache
Amazon ElastiCache

789
332
+ 1
140
Microsoft SQL Server
Microsoft SQL Server

3.8K
2.7K
+ 1
525
Add tool

Amazon ElastiCache vs Microsoft SQL Server: What are the differences?

Developers describe Amazon ElastiCache as "Deploy, operate, and scale an in-memory cache in the cloud". ElastiCache improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory caches, instead of relying entirely on slower disk-based databases. ElastiCache supports Memcached and Redis. On the other hand, Microsoft SQL Server is detailed as "A relational database management system developed by Microsoft". Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

Amazon ElastiCache belongs to "Managed Memcache" category of the tech stack, while Microsoft SQL Server can be primarily classified under "Databases".

"Redis" is the top reason why over 53 developers like Amazon ElastiCache, while over 134 developers mention "Reliable and easy to use" as the leading cause for choosing Microsoft SQL Server.

According to the StackShare community, Microsoft SQL Server has a broader approval, being mentioned in 470 company stacks & 425 developers stacks; compared to Amazon ElastiCache, which is listed in 342 company stacks and 79 developer stacks.

- No public GitHub repository available -
- No public GitHub repository available -

What is Amazon ElastiCache?

ElastiCache improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory caches, instead of relying entirely on slower disk-based databases. ElastiCache supports Memcached and Redis.

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Amazon ElastiCache?
Why do developers choose Microsoft SQL Server?

Sign up to add, upvote and see more prosMake informed product decisions

    Be the first to leave a con
    What companies use Amazon ElastiCache?
    What companies use Microsoft SQL Server?

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Amazon ElastiCache?
    What tools integrate with Microsoft SQL Server?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Amazon ElastiCache and Microsoft SQL Server?
    Redis
    Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets.
    Elasticsearch
    Elasticsearch is a distributed, RESTful search and analytics engine capable of storing data and searching it in near real time. Elasticsearch, Kibana, Beats and Logstash are the Elastic Stack (sometimes called the ELK Stack).
    Memcached
    Memcached is an in-memory key-value store for small chunks of arbitrary data (strings, objects) from results of database calls, API calls, or page rendering.
    Azure Redis Cache
    It perfectly complements Azure database services such as Cosmos DB. It provides a cost-effective solution to scale read and write throughput of your data tier. Store and share database query results, session states, static contents, and more using a common cache-aside pattern.
    MemCachier
    MemCachier provides an easy and powerful managed caching solution for all your performance and scalability needs. It works with the ubiquitous memcache protocol so your favourite language and framework already supports it.
    See all alternatives
    Decisions about Amazon ElastiCache and Microsoft SQL Server
    Amazon ElastiCache
    Amazon ElastiCache
    Amazon Elasticsearch Service
    Amazon Elasticsearch Service
    AWS Elastic Load Balancing (ELB)
    AWS Elastic Load Balancing (ELB)
    Memcached
    Memcached
    Redis
    Redis
    Python
    Python
    AWS Lambda
    AWS Lambda
    Amazon RDS
    Amazon RDS
    Microsoft SQL Server
    Microsoft SQL Server
    MariaDB
    MariaDB
    Amazon RDS for PostgreSQL
    Amazon RDS for PostgreSQL
    Rails
    Rails
    Ruby
    Ruby
    Heroku
    Heroku
    AWS Elastic Beanstalk
    AWS Elastic Beanstalk

    We initially started out with Heroku as our PaaS provider due to a desire to use it by our original developer for our Ruby on Rails application/website at the time. We were finding response times slow, it was painfully slow, sometimes taking 10 seconds to start loading the main page. Moving up to the next "compute" level was going to be very expensive.

    We moved our site over to AWS Elastic Beanstalk , not only did response times on the site practically become instant, our cloud bill for the application was cut in half.

    In database world we are currently using Amazon RDS for PostgreSQL also, we have both MariaDB and Microsoft SQL Server both hosted on Amazon RDS. The plan is to migrate to AWS Aurora Serverless for all 3 of those database systems.

    Additional services we use for our public applications: AWS Lambda, Python, Redis, Memcached, AWS Elastic Load Balancing (ELB), Amazon Elasticsearch Service, Amazon ElastiCache

    See more
    Yonas Beshawred
    Yonas Beshawred
    CEO at StackShare · | 9 upvotes · 26.5K views
    atStackShareStackShare
    Memcached
    Memcached
    Heroku
    Heroku
    Amazon ElastiCache
    Amazon ElastiCache
    Rails
    Rails
    PostgreSQL
    PostgreSQL
    MemCachier
    MemCachier
    #RailsCaching
    #Caching

    We decided to use MemCachier as our Memcached provider because we were seeing some serious PostgreSQL performance issues with query-heavy pages on the site. We use MemCachier for all Rails caching and pretty aggressively too for the logged out experience (fully cached pages for the most part). We really need to move to Amazon ElastiCache as soon as possible so we can stop paying so much. The only reason we're not moving is because there are some restrictions on the network side due to our main app being hosted on Heroku.

    #Caching #RailsCaching

    See more
    Interest over time
    Reviews of Amazon ElastiCache and Microsoft SQL Server
    No reviews found
    How developers use Amazon ElastiCache and Microsoft SQL Server
    Avatar of Brillium, Inc.
    Brillium, Inc. uses Microsoft SQL ServerMicrosoft SQL Server

    We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.

    Avatar of Andrew Miller
    Andrew Miller uses Microsoft SQL ServerMicrosoft SQL Server

    Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.

    Avatar of David Flynn
    David Flynn uses Microsoft SQL ServerMicrosoft SQL Server

    Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.

    Avatar of Volkan Özçelik
    Volkan Özçelik uses Amazon ElastiCacheAmazon ElastiCache

    I use a micro elesticache instance as a shared session store between the Node.js clusters of dojo.zerotoherojs.com and nightly.zerotoherojs.com

    Avatar of Olo
    Olo uses Microsoft SQL ServerMicrosoft SQL Server

    Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

    Avatar of Cloud Consultant
    Cloud Consultant uses Amazon ElastiCacheAmazon ElastiCache

    Audit the ElastiCache configurations for best practices and standards.

    Avatar of Binded
    Binded uses Amazon ElastiCacheAmazon ElastiCache

    We use ElastiCache to run Redis, which we use as a queue through Kue.

    Avatar of Arbor Health, LLC
    Arbor Health, LLC uses Microsoft SQL ServerMicrosoft SQL Server

    Managing script output and input, as well as data cleansing.

    Avatar of Instacart
    Instacart uses Amazon ElastiCacheAmazon ElastiCache

    We use Elasticache. Both Redis and Memchached.

    Avatar of Bùi Thanh
    Bùi Thanh uses Amazon ElastiCacheAmazon ElastiCache
    • Redis cluster for cache and session storage
    How much does Amazon ElastiCache cost?
    How much does Microsoft SQL Server cost?
    Pricing unavailable