Try our new research platform with insights from 80,000+ expert users
Mohamed Ait  Salah - PeerSpot reviewer
Cloud Solutions Architect and Microsoft Principal Consultant for EMEA at a tech vendor with 10,001+ employees
Real User
Top 10
It is available in every region, allowing quick information storage and retrieval
Pros and Cons
  • "Azure Cosmos DB's resiliency is valuable. It is available in every Azure region, allowing quick information storage and retrieval. We can partition it to improve indexing, enabling us to retrieve information and recreate website content quickly."
  • "Cosmos DB has helped our organization handle large amounts of data."
  • "Cosmos DB should continue evolving in AI features. We expect Cosmos DB to lead on that. There is potential for improved security features, which is important for data storage, especially for Dell Technologies. We must ensure data security remains the top priority."
  • "We expect Cosmos DB to lead on that. There is potential for improved security features, which is important for data storage, especially for Dell Technologies."

What is our primary use case?

Our primary use case for Azure Cosmos DB is storing information for our large accounting application, which integrates several sites on SharePoint Online. We use event programming to store all calls in Cosmos DB, so we can redo them and have them persist in the database.

How has it helped my organization?

Cosmos DB has helped our organization handle large amounts of data. For example, we had a customer who collected data from 100,000 sites, and we increased that to a million without significantly increasing search query time. We can now search in nearly real-time, which has been crucial, especially with AI workloads.

What is most valuable?

Azure Cosmos DB's resiliency is valuable. It is available in every Azure region, allowing quick information storage and retrieval. We can partition it to improve indexing, enabling us to retrieve information and recreate website content quickly. 

It's easy to use for our use case because we use it to store and retrieve information, but it will be more complex if you are configuring a Redis cache or something similar. 

Cosmos DB also integrates well with Azure app services and functions, allowing us to scale by efficiently storing calls. Its ability to scale workloads is impressive, and features like partitioning and Azure replication enhance its scalability. Its interoperability with solutions is better than that of other NoSQL databases we assessed. It's native to Azure and integrates with the networks and security.

What needs improvement?

Cosmos DB should continue evolving in AI features. We expect Cosmos DB to lead on that. There is potential for improved security features, which is important for data storage, especially for Dell Technologies. We must ensure data security remains the top priority.

Buyer's Guide
Microsoft Azure Cosmos DB
June 2025
Learn what your peers think about Microsoft Azure Cosmos DB. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
860,592 professionals have used our research since 2012.

For how long have I used the solution?

I have been using Cosmos DB for over eight years, starting from its preview release.

What do I think about the stability of the solution?

There have been no notable issues with the stability of Cosmos DB. Any problems encountered were not directly related to Cosmos DB but perhaps coding errors or usage methods.

What do I think about the scalability of the solution?

Cosmos DB scales workloads impressively through features such as partitioning and Azure replication. Its design as a NoSQL database has helped us transition from traditional SQL, impacting costs positively.

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

We previously used MongoDB, but Cosmos DB's integration within Azure provided better network and security options, making it a preferred choice. I've worked on Microsoft technologies since the beginning, and I love how Microsoft solutions are integrated. Everything works together securely, and moving from one technology to another is simple.

How was the initial setup?

The initial setup was easy. The transition from MongoDB was seamless as Cosmos DB has improved upon existing NoSQL structures without reinventing them.

What was our ROI?

Cosmos DB has decreased our organization's total cost of ownership, particularly with decreasing overhead costs due to its scalable features.

What's my experience with pricing, setup cost, and licensing?

We prioritized fine-tuning operations to optimize costs, and Cosmos DB’s pricing model allows room for improvement. We are assessing its use in other areas to potentially eliminate third-party solutions.

What other advice do I have?

I rate Microsoft Azure Cosmos DB nine out of 10. To avoid migration challenges, data storage methods in Cosmos DB should be carefully considered.

Which deployment model are you using for this solution?

Public Cloud

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

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer. partner
Flag as inappropriate
PeerSpot user
reviewer2595687 - PeerSpot reviewer
Cloud Engineer at a energy/utilities company with 10,001+ employees
Real User
Top 20
Has incredible latency and availability
Pros and Cons
  • "The features most valuable to us in Microsoft Azure Cosmos DB are the auto scale and change feed. These features allow us to do some operations that are not possible with SQL Server."
  • "Latency and availability are incredible."
  • "One of our biggest pain points is the backup and restore functionality needs improvement. They've gotten a little better in this area. SQL Server's long-term retention is amazing, and you can restore data from years ago. You need to open a support Microsoft ticket to restore your Cosmos DB backup, and it comes in on a different Cosmos account. It's just kind of a headache to restore data."
  • "One of our biggest pain points is the backup and restore functionality needs improvement."

What is our primary use case?

We primarily use Microsoft Azure Cosmos DB as a transactional data store and for some event-driven applications. We utilize the change feed, and the function app triggers quite a bit. MPerks, our customer loyalty application, uses it. It has become our go-to database, and we hardly touch SQL Server for new stuff.

How has it helped my organization?

Our developers find Microsoft Azure Cosmos DB easy to use and more scalable. The whole cloud model of only paying for what you use fits our organization well. 

What is most valuable?

The features most valuable to us in Microsoft Azure Cosmos DB are the auto scale and change feed. These features allow us to do some operations that are not possible with SQL Server. It is super configurable, allowing us to pick and choose the different Cosmos databases we need, whether or not dynamic scaling is the right thing for that workload.

Latency and availability are incredible. Given that our data is partitioned and indexed correctly, we can run queries and get results in less than five milliseconds. This has resulted in happier customers.

Cosmos is super-easy to use. It adopts a whole document database strategy with no relational data, so what you see is what you get. It's straightforward to understand, and you no longer need to worry about entity diagrams.

What needs improvement?

One of our biggest pain points is the backup and restore functionality needs improvement. They've gotten a little better in this area. SQL Server's long-term retention is amazing, and you can restore data from years ago. You need to open a support Microsoft ticket to restore your Cosmos DB backup, and it comes in on a different Cosmos account. It's just kind of a headache to restore data.

CosmosDB's ability to search through large amounts of data isn't great. It kills the RUs if you're using the transactional store. We use Synapse Analytics for our more analytical workloads. We love Synapse for that purpose.

For how long have I used the solution?

I have been using Microsoft Azure Cosmos DB for about six years.

What do I think about the scalability of the solution?

There are no critical scalability issues with Microsoft Azure Cosmos DB. It scales well with RUs, and it is never an issue for us. Our issues usually lie more on the application side.

How are customer service and support?

The support experience has been pretty good, and I don't have a lot of complaints.

How would you rate customer service and support?

Positive

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

Previously, we used SQL Server. Microsoft Azure Cosmos DB was chosen because it is the go-to document data store, and our developers are familiar with SQL syntax.

How was the initial setup?

New developers are able to get jumpstarted on Microsoft Azure Cosmos DB quickly. Although we learned some lessons on how to structure and partition data, the initial setup was not problematic.

What was our ROI?

I can't specify the exact ROI, but Microsoft Azure Cosmos DB has decreased our total cost of ownership.

What's my experience with pricing, setup cost, and licensing?

We pay for what we use, with the flexibility to reserve our use. Autoscaling is a premium option, but it helps when our database isn't in high demand. It provides flexibility in configuring our RUs, whether we want to do it at the database or container level. We have lots of options to configure and pay for the solution. 

Which other solutions did I evaluate?

We evaluated AWS solutions, but ultimately chose Microsoft Azure Cosmos DB.

What other advice do I have?

I would rate Microsoft Azure Cosmos DB a nine out of 10. Both Microsoft Azure Cosmos DB and Cosmos SQL DB are familiar to our developers who come from a SQL Server background.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flag as inappropriate
PeerSpot user
Buyer's Guide
Microsoft Azure Cosmos DB
June 2025
Learn what your peers think about Microsoft Azure Cosmos DB. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
860,592 professionals have used our research since 2012.
Software developer at a insurance company with 501-1,000 employees
Real User
Offers swift data retrieval and scalability based on the workload
Pros and Cons
  • "The best features of Microsoft Azure Cosmos DB include the speed to query data; as long as you index properly, retrieving data is fast and lightweight."
  • "I would recommend Microsoft Azure Cosmos DB to other users without hesitation."
  • "Areas of improvement for Microsoft Azure Cosmos DB include indexing. While it makes data retrieval easier, it also increases costs. If there's a better way to improve indexing at a lower cost, that would be really helpful, but that's the major point for now."
  • "Areas of improvement for Microsoft Azure Cosmos DB include indexing. While it makes data retrieval easier, it also increases costs."

What is our primary use case?

In my place of work, we use Microsoft Azure Cosmos DB to store data for our services and mobile and web applications.

The problems we were trying to solve with Microsoft Azure Cosmos DB primarily involve storing data that is not relational, such as hierarchical documents and data. It helps to store data and scale up when we are pushing large amounts of data.

How has it helped my organization?

We need to scale data. With Microsoft Azure Cosmos DB, we are able to scale up when processing large amounts of data or scale down as needed. It's also lightweight.

There is ease of use, especially for managing lots of non-relational data, which is easier to use than relational data. Azure is our enterprise solution, so we utilize Microsoft Azure Cosmos DB as it offers resources to store and manage non-relational data. Given that we run an e-commerce site, we have a lot of non-relational data, especially for items and all related aspects. It's very helpful because alternative solutions using relational data would not fulfill our needs. It effectively stores hierarchical data and data without defined relationships, making it quite useful for our organization.

Using Microsoft Azure Cosmos DB is fairly easy, but most importantly, the availability of documentation and community makes it easy to research information. For instance, if there are certain queries I want to run, I could easily go online. There's also the Copilot feature that helps generate the query I need to retrieve the data I want. It's fairly easy to use, and there are many tools to assist in utilizing the resource.

What is most valuable?

The best features of Microsoft Azure Cosmos DB include the speed to query data; as long as you index properly, retrieving data is fast and lightweight. 

Additionally, the scalability to scale your RUs when pushing large amounts of data to Microsoft Azure Cosmos DB and managing the speed or latency for read and write is crucial, depending on how you set it up.

What needs improvement?

Areas of improvement for Microsoft Azure Cosmos DB include indexing. While it makes data retrieval easier, it also increases costs. If there's a better way to improve indexing at a lower cost, that would be really helpful, but that's the major point for now.

For how long have I used the solution?

I have been using Microsoft Azure Cosmos DB for almost three years.

What do I think about the stability of the solution?

I would rate Microsoft Azure Cosmos DB a seven out of ten for stability.

What do I think about the scalability of the solution?

For scalability, I would rate Microsoft Azure Cosmos DB a ten out of ten. The technology department that utilizes Microsoft Azure Cosmos DB spans approximately 500-1000 users. We have multiple locations and departments using Microsoft Azure Cosmos DB.

It offers us scalability. It saves cost because the system scales up when we have an enormous amount of data going in to allow a large flow of data. Once we are back to low traffic, it scales down, saving costs.

How are customer service and support?

I would rate the technical support for Microsoft Azure Cosmos DB a seven out of ten.

How would you rate customer service and support?

Neutral

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

I have not used other vendors; I have only worked with Microsoft. Therefore, I don't have a comparison to make.

How was the initial setup?

It took a couple of hours.

The learning curve for onboarding with Microsoft Azure Cosmos DB is quite short; as long as you get the portal, it is fairly self-explanatory on how to navigate around it.

The maintenance required for Microsoft Azure Cosmos DB is minimal. Maintenance is needed when Microsoft rolls out an update or when ensuring that our code packages are using the correct version of the Cosmos NuGet packages. It just means we need to stay up to date with the documentation.

What was our ROI?

I cannot quantify how much time or resources Microsoft Azure Cosmos DB saves me because I do not primarily work with cost management. I mainly focus on research and setup, but I think it saves costs—perhaps a few hundred pounds if we don't scale up. Putting it into perspective, it saves costs between 10% to 20%.

What's my experience with pricing, setup cost, and licensing?

It is cost-efficient as long as you understand the right setup to optimize usage. Knowing the data needs of the organization and adjusting the Microsoft Azure Cosmos DB usage accordingly helps save costs, but if you don't know, you could end up spending more than necessary.

What other advice do I have?

We do not use the built-in vector database capability of Microsoft Azure Cosmos DB; the nature of my department requires us to use the regular storage capability.

I would recommend Microsoft Azure Cosmos DB to other users without hesitation. I would rate Microsoft Azure Cosmos DB an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud

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

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flag as inappropriate
PeerSpot user
ARTURO MONTIEL - PeerSpot reviewer
Arquitecto Industrial IoT at Xignux SA de CV
Real User
Top 5
Offers developer kits for various databases but had performance issues with a data segregation query
Pros and Cons
  • "Microsoft Azure Cosmos DB is a Microsoft solution specifically, but we can develop with different developer kits for different databases."
  • "Big data, along with data analysis, is one of the valuable features."
  • "We had some performance issues with a data segregation query. We worked closely with Microsoft to solve the problem of performance where, for example, one query had a delay of almost two or three minutes for this one use case. Microsoft tried to improve the product, but in the end, the solution was to change to MongoDB. MongoDB had better performance."
  • "Our use case was a failure with Microsoft Azure Cosmos DB, and we do not have any other opportunity to use Microsoft Azure Cosmos DB."

What is our primary use case?

The main use cases involve creating some kind of dashboards in near real-time. Our use cases focus on manufacturing, where we used Microsoft Azure Cosmos DB to maintain data for the very intensive manufacturing processes. In the end, we performed data analysis on the operational processes in manufacturing.

What is most valuable?

Big data, along with data analysis, is one of the valuable features. We are able to have insights into how to make improvements in the processes for operational people.

Microsoft Azure Cosmos DB is a Microsoft solution specifically, but we can develop with different developer kits for different databases.

What needs improvement?

We had some performance issues with a data segregation query. We worked closely with Microsoft to solve the problem of performance where, for example, one query had a delay of almost two or three minutes for this one use case. Microsoft tried to improve the product, but in the end, the solution was to change to MongoDB. MongoDB had better performance. We reached the performance required using MongoDB instead of Microsoft Azure Cosmos DB.

For how long have I used the solution?

I used it for one year or less than one year.

What do I think about the stability of the solution?

Microsoft Azure Cosmos DB has good performance and latency. We only faced performance issues with the data segregation query.

What do I think about the scalability of the solution?

I would rate Microsoft Azure Cosmos DB a nine out of ten for the capability to scale workloads. 

How are customer service and support?

On a scale of one to ten, I would rate customer service a seven. For example, when I created a ticket with them, they gave us feedback very often, even each week. This went on for four or five months, but they did not solve the problem. They only gave feedback, and in the end, it did not resolve the problem.

How would you rate customer service and support?

Neutral

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

We changed from using Microsoft Azure Cosmos DB to MongoDB because Microsoft Azure Cosmos DB did not give us the correct performance for certain data segregation, so we replaced it with MongoDB.

People who helped us implement MongoDB were more specialized or had more expertise than Microsoft people.

How was the initial setup?

The setup of Microsoft Azure Cosmos DB was very easy. It took us a few weeks.

What about the implementation team?

We received help from Microsoft directly. They helped us to get started with it. 

What was our ROI?

Our use case was a failure with Microsoft Azure Cosmos DB, and we do not have any other opportunity to use Microsoft Azure Cosmos DB.

What's my experience with pricing, setup cost, and licensing?

Its pricing is not bad. It is good. 

We have a contract with Microsoft to use their technology. In my opinion, Microsoft Azure Cosmos DB is a good option for the total cost of ownership.

What other advice do I have?

I would rate Microsoft Azure Cosmos DB as seven out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flag as inappropriate
PeerSpot user
Gaurav Hombali - PeerSpot reviewer
Manager, Development Practice at All Lines Technology
MSP
Top 10
Having data in a flat file format speeds up processes
Pros and Cons
  • "Azure Cosmos DB's graph queries are its most valuable feature. Although I have not yet explored vector search, it's coming to Cosmos DB, and I plan to look into it. Having data in a flat file format in a document database speeds up processes, which is the primary purpose. Additionally, Cosmos DB's use of the Mongo platform makes it intuitive and cost-effective."
  • "Cosmos DB has helped us by providing faster response times for everything, which significantly improved our search results quality."
  • "There are no specific areas I believe need improvement as I am happy with what I am getting currently. However, I am open to new features in future versions, like possibly integrating AI features natively into Cosmos DB. Any improvement would be beneficial."

What is our primary use case?

Our primary use case is mirroring the data for reporting.

How has it helped my organization?

Cosmos DB has helped us by providing faster response times for everything, which significantly improved our search results quality.

What is most valuable?

Azure Cosmos DB's graph queries are its most valuable feature. Although I have not yet explored vector search, it's coming to Cosmos DB, and I plan to look into it. Having data in a flat-file format in a document database speeds up processes, which is the primary purpose. Additionally, Cosmos DB's use of the Mongo platform makes it intuitive and cost-effective.

I use Azure AI services, including cognitive services and OCR. I recently built a chatbot using the model. Cosmos DB integrates well with other apps. 

What needs improvement?

There are no specific areas I believe need improvement as I am happy with what I am getting currently. However, I am open to new features in future versions, like possibly integrating AI features natively into Cosmos DB. Any improvement would be beneficial.

For how long have I used the solution?

I have been using Azure Cosmos DB for more than five years.

What do I think about the stability of the solution?

I have not encountered any issues related to the stability of Cosmos DB. The challenge does not lie in the technical aspect of Cosmos DB but in the non-technical aspects.

What do I think about the scalability of the solution?

Cosmos DB has impressive scalability. We have been able to scale workloads as needed during peak hours without any issues, effectively meeting our expectations.

How was the initial setup?

The initial setup was quite quick, taking only a few days for the team to be onboarded with Cosmos DB. The primary challenge was non-technical.

What about the implementation team?

The implementation involved just the normal onboarding process for any human resource.

What was our ROI?

Our organization's total cost of ownership has been reduced by 20 percent due to the backend data mirroring for setting up the repository for reporting purposes. Dynamic scaling has also helped decrease our organization's overhead cost by automating the scaling process and reducing the need for human intervention.

What's my experience with pricing, setup cost, and licensing?

Our experience with the pricing and setup cost is that it aligns with what we expect based on the pricing we see. However, I would absolutely like it to be less if possible.

What other advice do I have?

I rate Azure Cosmos DB eight out of 10. There is always room for improvement, and the company could develop new features that could make it even better, but I am very satisfied with the current performance.

Disclosure: My company has a business relationship with this vendor other than being a customer. Partners
Flag as inappropriate
PeerSpot user
System Administrator Technology Services Engineer at a retailer with 10,001+ employees
Real User
Interactions are easy with API access and scaling is also easy
Pros and Cons
  • "The best feature of Microsoft Azure Cosmos DB is API access, which makes it very easy to interact with the database without needing to write queries."
  • "Overall, I would rate Microsoft Azure Cosmos DB a nine out of ten."
  • "They can implement a better backup system or alert system on Microsoft's end. We do receive notices for regular maintenance or updates, but sudden issues create significant problems."
  • "There is room for improvement in Microsoft's maintenance aspect. For example, we had a major incident at the end of December where the entire South Central region was down for our application, causing many problems due to a lack of access to the database."

What is our primary use case?

We use it for our internal operations, including order history and other things related to e-commerce.

We do not use the built-in vector database capabilities since they are driven by another team in our organization. We just access through the API.

How has it helped my organization?

We find Microsoft Azure Cosmos DB easy to use. We are provided APIs for each and every write or edit access, even for read operations. We don't directly query the database. API-based access makes it easy.

Previously, we used to have maintenance or server issues. We don't have those issues anymore.

What is most valuable?

The best feature of Microsoft Azure Cosmos DB is API access, which makes it very easy to interact with the database without needing to write queries. It's also fast. As it's Microsoft-provisioned, the cloud is very accessible and reliable as well.

What needs improvement?

There is room for improvement in Microsoft's maintenance aspect. For example, we had a major incident at the end of December where the entire South Central region was down for our application, causing many problems due to a lack of access to the database. It led to missing data in some systems. They can implement a better backup system or alert system on Microsoft's end. We do receive notices for regular maintenance or updates, but sudden issues create significant problems.

For how long have I used the solution?

I've been using Microsoft Azure Cosmos DB for more than one year.

What do I think about the stability of the solution?

In the past year, I have only been using Microsoft Azure Cosmos DB for a year, and previously we encountered Microsoft issues such as maintenance or server problems, but these days we are not observing that as much.

For stability and impressions of latency and availability, I would rate it an eight or nine; we have not seen significant issues recently.

What do I think about the scalability of the solution?

I rate scalability as pretty good. Because it's in the cloud, scaling is easy.

We are a very large organization. It is hard to know how many teams use Microsoft Azure Cosmos DB or still rely on the older systems. I am in India, and our team uses Microsoft Azure Cosmos DB, and I believe teams in the U.S. use it as well.

How are customer service and support?

I would rate the technical support a nine out of ten.

How would you rate customer service and support?

Positive

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

Before using Microsoft Azure Cosmos DB, we had a different database system in place. The main factor for switching was cost-related. It was a leadership decision, and as a fresher, I wasn't involved in these discussions.

How was the initial setup?

We were not part of the deployment. We were involved in migration activities, but I'm not very sure about the deployment experience. We aren't seeing any major issues now.

Maintenance of Microsoft Azure Cosmos DB is ongoing. There is a Cosmos DB team in our organization conducting maintenance, though not very frequently.

What's my experience with pricing, setup cost, and licensing?

I'm not aware of the exact costs. We received one report a long time ago regarding savings after we started using Microsoft Azure Cosmos DB, but I don't remember the details. It seems to have helped significantly. We were using a different database system previously, and one of the reasons for acquiring Microsoft Azure Cosmos DB was cost.

What other advice do I have?

I definitely recommend Microsoft Azure Cosmos DB, although I'm still learning. It's been just two years, but I've taken courses on Microsoft Azure. I recognize the advantages in scalability, availability, and cost factors, with maintenance issues being minimal as well. 

Overall, I would rate Microsoft Azure Cosmos DB a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud

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

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flag as inappropriate
PeerSpot user
Jordan Berry - PeerSpot reviewer
CEO at Interloop Data
Real User
Top 10
Enables us to handle transactional and analytical workloads in the same database
Pros and Cons
  • "We love the ability to land data with Cosmos DB easily. Cosmos is native to Azure, so everything works seamlessly with it. You need good data to have good AI, and Cosmos makes it easy to land the data."
  • "We have both our SaaS app and the analytical side running without throttling issues."
  • "We would like to see advancements in AI with the ability to benchmark vector search capabilities, ensuring it answers questions accurately. During our initial implementation, we faced challenges with indexing and sorting, which are natively available in other offerings but required specific configurations in Cosmos."
  • "We would like to see advancements in AI with the ability to benchmark vector search capabilities, ensuring it answers questions accurately. During our initial implementation, we faced challenges with indexing and sorting, which are natively available in other offerings but required specific configurations in Cosmos."

What is our primary use case?

Our corporate mission is to help companies achieve more with their data, which often means unifying your data. We have a SaaS solution and have built a Copilot with Copilot Studio on top, as well as some of the Azure AI services, which is now Foundry. We are starting to use it to allow people to use natural language to ask questions of their data. We are early in our journey, but I suspect it will work well for us.

How has it helped my organization?

By incorporating Cosmos DB into our Azure ecosystem, we have streamlined costs and improved efficiency. The integration has allowed us to manage Cosmos alongside our other services, providing a comprehensive view of resources. The inclusion of advanced capabilities has been beneficial, positively impacting our internal operations and the services we offer to clients.

We're early in our journey, but I believe it will improve the quality of our search results. We're having a lot of success with Copilot and are excited to see how it'll work in a traditional sense as well. We're in analytics, so we work with a lot of massive data and look at tens of millions of rows. We haven't had any capacity challenges or thresholds. We started with small data, so having a tool that will grow with you is great. 

What is most valuable?

We love the ability to land data with Cosmos DB easily. Cosmos is native to Azure, so everything works seamlessly with it. You need good data to have good AI, and Cosmos makes it easy to land the data.

The recently added ability to mirror to Fabric has been beneficial. Cosmos DB enables us to handle transactional and analytical workloads in the same database. 

Cosmos DB is easy to use. You can set up a database with a couple of clicks, and it's simple to scale it up and down based on your needs. Within Azure, the Explorer UX has been great for us, too. You don't have to install another tool to run a quick query or explore some data. Additionally, the ability to estimate your Cosmos costs through the portal and manage features has been useful.

Like most database tools, it takes some time to understand. If you come from SQL or even from the Mongo world, many concepts will be familiar to you. While it takes some learning and expertise, it's not a large hill to climb. You must learn the advanced capabilities, but they make your solutions more powerful.

The vector database requires an additional engineering step to move the data from a transactional database to a vector store so that you can query it and use it in AI. However, because the vector capabilities are built in, it saved us engineering time and allowed us to get our solution out faster. 

What needs improvement?

We would like to see advancements in AI with the ability to benchmark vector search capabilities, ensuring it answers questions accurately. During our initial implementation, we faced challenges with indexing and sorting, which are natively available in other offerings but required specific configurations in Cosmos.

For how long have I used the solution?

We have used Cosmos SQL for more than five years.

What do I think about the stability of the solution?

There have been no challenges with Cosmos DB's stability. We have both our SaaS app and the analytical side running without throttling issues.

What do I think about the scalability of the solution?

The scalability is great, both horizontally and vertically.

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

In the past, we've worked with traditional SQL Server and MongoDB. However, Cosmos being native to Azure and the seamless integration prompted our switch.

How was the initial setup?

The onboarding process was relatively quick for us. We were up and running within two weeks, including a pilot test.

What was our ROI?

The dynamic scaling during peak times has been crucial in cost management.

What's my experience with pricing, setup cost, and licensing?

The integration of Cosmos with our other Azure services allows us to manage costs proactively. The built-in capabilities help control costs in line with our growth expectations through the portal. 

What other advice do I have?

I rate Cosmos DB eight out of 10.

Which deployment model are you using for this solution?

Public Cloud

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

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer. Reseller
Flag as inappropriate
PeerSpot user
Balaram Vardhineedi - PeerSpot reviewer
Application Development Analyst at Accenture
Real User
Top 10
Provides multi-region storage, low latency, and automatic scaling
Pros and Cons
  • "In Microsoft Azure Cosmos DB, one valuable feature is its ability to store data in multiple regions. If one region fails, it automatically switches to a healthy region, ensuring minimal latency and disaster recovery without impacting data latency in applications."
  • "Microsoft Azure Cosmos DB is very easy to use."
  • "Currently, I have no suggestions for enhancement or new implementations in Microsoft Azure Cosmos DB. However, the cost can sometimes be high, especially during cross-partition queries with large data amounts."
  • "The cost can sometimes be high, especially during cross-partition queries with large data amounts."

What is our primary use case?

We use Microsoft Azure Cosmos DB to store document-type data, graph data, and key-value type data. It is a globally distributed database, which we mainly utilize to store document-type JSON data. 

In my project, I work with core SQL-type queries. Using the API, we are storing JSON data in Microsoft Azure Cosmos DB with a database and container-level architecture. This involves storing items using a partition key for optimized query performance.

We get data from BLOB storage. After some processing, we are storing it in the JSON format in Microsoft Azure Cosmos DB.

How has it helped my organization?

Microsoft Azure Cosmos DB automatically indexes documents. By indexing every field in the document, it is easy to get fast performance to retrieve the records. While fetching, it fetches only specific fields required for further processing, which makes it efficient. Fetching all the fields from a document takes more time.

Storing data with a partition key makes data fetching easier and faster.

Microsoft Azure Cosmos DB helps in fetching data faster. There is a single-digit millisecond response to fetch those records.

Microsoft Azure Cosmos DB supports scalability. At a peak time, it will automatically scale the RUs. When there is less data, it will decrease them.

What is most valuable?

In Microsoft Azure Cosmos DB, one valuable feature is its ability to store data in multiple regions. If one region fails, it automatically switches to a healthy region, ensuring minimal latency and disaster recovery without impacting data latency in applications. It scales automatically based on query performance and peak traffic.

Microsoft Azure Cosmos DB is very easy to use.

What needs improvement?

Currently, I have no suggestions for enhancement or new implementations in Microsoft Azure Cosmos DB. However, the cost can sometimes be high, especially during cross-partition queries with large data amounts.

For how long have I used the solution?

I have been using Microsoft Azure Cosmos DB for the last two years.

What do I think about the stability of the solution?

Microsoft Azure Cosmos DB provides high availability with 99.9% reliability. When we store documents in Microsoft Azure Cosmos DB, it stores them in multiple regions, not only at specific regions. If one region fails, it automatically switches to a healthy region. 

There is low latency. The partition key helps achieve low latency by ensuring data is stored and accessed efficiently.

What do I think about the scalability of the solution?

Microsoft Azure Cosmos DB offers both automatic and manual scaling. The automatic scaling feature adjusts RUs based on peak demands, which helps manage workloads efficiently. The dynamic scaling feature has helped reduce overhead costs by automatically managing resource utilization.

Our application is being used globally, and we have ten members in our team.

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

When I joined the organization, Microsoft Azure Cosmos DB was already in use. I have not worked with other NoSQL databases before.

How was the initial setup?

It is a Platform as a Service. It was already implemented before I joined.

I started working with it in the first month. I had the support of the senior developers of the time.

It does not require maintenance from our end.

What was our ROI?

We monitor the cost daily through Azure Monitor to evaluate how much it is costing for documents, thereby keeping track of the return on investment.

What's my experience with pricing, setup cost, and licensing?

Microsoft Azure Cosmos DB pricing is based on RUs. Reading 1 KB document costs one RU, whereas writing one document costs five RUs. Pricing for querying depends on the complexity of the query. If you increase the document size, it will automatically increase the RU cost.

What other advice do I have?

I would recommend this solution. For e-commerce applications, it is more beneficial because it can store semi-structured data. It is the best option if you want to get data quickly because it organizes the data in a good way. When a region fails, it automatically switches to a healthy region. It has backup storage, and it scales automatically based on the peak time or low time.

I would rate Microsoft Azure Cosmos DB an eight out of ten. It is a good solution, but the cost can increase with cross-partition queries due to data distribution.

Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Flag as inappropriate
PeerSpot user