No more typing reviews! Try our Samantha, our new voice AI agent.

InterSystems IRIS vs SQL Server comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

InterSystems IRIS
Ranking in Relational Databases Tools
14th
Ranking in Database Management Systems (DBMS)
10th
Average Rating
8.2
Reviews Sentiment
4.5
Number of Reviews
7
Ranking in other categories
No ranking in other categories
SQL Server
Ranking in Relational Databases Tools
1st
Ranking in Database Management Systems (DBMS)
2nd
Average Rating
8.4
Reviews Sentiment
6.6
Number of Reviews
275
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of October 2026, in the Relational Databases Tools category, the mindshare of InterSystems IRIS is 0.9%, up from 0.5% compared to the previous year. The mindshare of SQL Server is 10.3%, down from 15.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools Mindshare Distribution
ProductMindshare (%)
SQL Server10.3%
InterSystems IRIS0.9%
Other88.8%
Relational Databases Tools
 

Featured Reviews

reviewer2892648 - PeerSpot reviewer
Developer/Database Administrator at a transportation company with 201-500 employees
Robust multidimensional database has enabled smooth API integrations and modern data workflows
I think InterSystems IRIS is a continuation of the Caché legacy. Since I have been working with it since 2005 with Caché, I think it is a really amazing tool. It is a very robust and very scalable database. It is very good to work with, and I am already used to working with it. Where it falls a bit short is in the availability of manpower and professionals who work with InterSystems IRIS or Caché. There are few professionals who work with it. Another thing is the cost and the license cost. I think there could be some kind of package that could serve smaller companies and small and medium-sized companies. That would reach a larger slice of the market, because the cost to work with Caché, InterSystems IRIS, and so on is high. I would make this remark about putting together a package and a new product that could serve small and medium-sized companies. The area where InterSystems IRIS falls a bit short is in the cost and the licensing cost. The licensing cost is the main issue I have already mentioned.
Peter Larsson - PeerSpot reviewer
Data Warehouse Lead at Resurs Bank AB (publ.)
Ledger and seamless integrations have strengthened trusted analytics and unified workloads
SQL Server's high availability and disaster recovery features work for supporting mission-critical applications, but there is much more to wish for. These features are not quite ready yet, although they do function. However, they could be significantly better. High availability and disaster recovery features should be improved in the next releases. I have noticed that everything could be improved or enhanced in the future, particularly temporal tables and window functions. Sometimes, I believe Microsoft releases features to stay ahead of competitors, but they do not make them feature-rich or feature-complete. They release something to be ahead of leaders and then seem to forget to maintain and upgrade them. I want Microsoft to pay more attention and be more mindful about the things they implement. It is fine to do a first release that works, but you cannot simply abandon it in the following years without service packs and improvements. You must continue to build on features rather than forgetting about them.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"InterSystems IRIS has had a positive impact on my organization by improving performance and data security."
"In my opinion, the best features that InterSystems IRIS offers are its very optimized database, which I found amazing, and the observability it provides for checking messages and how the data is being transferred, which I find very interesting."
"The best features InterSystems IRIS offers, in my experience, include being a really powerful engine and a really good database."
"InterSystems IRIS as a database is very efficient, with its best features being its speed and high performance, along with an easy understanding of its data searching functionalities."
"The best features that InterSystems IRIS offers in my opinion are the speed in querying data, and due to our system, which requires a large query with a large volume of data, InterSystems IRIS stands out for its query speed, making my work easier."
"My final observation is that everyone should use InterSystems IRIS; it is an amazing tool on the market."
"The best features InterSystems IRIS offers are its powerful database and speed, which contribute greatly to my work."
"It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that."
"Since we can automate most of our tasks, it means that the management is very easy."
"I have contacted technical support, and overall my experience with technical support was okay."
"It is integrated with Microsoft tools."
"The installation is pretty straightforward."
"One of the best features of SQL Server is the efficient retrieval of information."
"If backups and alerts are configured properly, I can also rely on my restoration plan."
"It helps with moving the design of the database into reality."
 

Cons

"InterSystems IRIS can be improved by addressing the lack of libraries, mainly mathematical ones, where we would save a lot of time on some formulas that we have to build by hand every time we need them."
"The area where InterSystems IRIS falls a bit short is in the cost and the licensing cost."
"I cannot determine a very positive impact or a beneficial result from InterSystems IRIS, although this observability part is important because we were able to find problems much faster."
"Python support can be enhanced further, as it's really clunky at the moment, considering that the use of Python is pretty much all over the world and nobody knows ObjectScript really thoroughly and deeply."
"InterSystems IRIS can be improved since its studio is very poor."
"The solution could be better integrated with the SQL Server Studio tool."
"We need it to support Linux for better troubleshooting flexibility."
"From Microsoft -- poor/very expensive, but there are many other helpful resources out there."
"The solution is very expensive."
"They do not offer the SQL Server Management tool via the installation. It is a separate tool I use when I'm trying to configure the mirroring with SQL Server Mirroring. This is not supported and I'm getting some errors on the database mirroring."
"SQL Server is doing well, but I wish the optimization aspects were better."
"It would be nice if there was a feature to search for a specific value across multiple tables. This would save a lot of time for its users."
"The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on."
 

Pricing and Cost Advice

Information not available
"Pricing for this product is very reasonable."
"On a scale of one to ten, when one is cheap and ten is an expensive solution, I rate the product price as seven. The product is expensive."
"Pricing is a bit on the higher side."
"The solution is on a pay-per-use pricing model."
"I don't know the exact prices because my focus is essentially technical and not on the bills. A few years ago, they changed the billing policy for the Enterprise Edition, and it became less attractive. But I believe they are still cheaper than Oracle. SQL Server isn't cheap, but it's not expensive either."
"We are on an annual enterprise license for the solution and the cost of the license could be reduced."
"There is an annual license and it is priced reasonably."
"To scale the solution there are additional costs."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
914,938 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Outsourcing Company
30%
Comms Service Provider
18%
Healthcare Company
11%
Financial Services Firm
5%
Financial Services Firm
35%
Outsourcing Company
10%
Manufacturing Company
7%
Construction Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Midsize Enterprise3
Large Enterprise1
By reviewers
Company SizeCount
Small Business119
Midsize Enterprise60
Large Enterprise119
 

Questions from the Community

What needs improvement with InterSystems IRIS?
InterSystems IRIS can be improved by addressing the lack of libraries, mainly mathematical ones, where we would save a lot of time on some formulas that we have to build by hand every time we need ...
What is your primary use case for InterSystems IRIS?
My main use case for InterSystems IRIS is hospital integrations. In hospital integrations, I use InterSystems IRIS for object conversions. Regarding this use case, I utilize TCP/IP, REST, and SOAP ...
What advice do you have for others considering InterSystems IRIS?
My advice to others who are considering using InterSystems IRIS is to use it without fear, take advantage of all the platform's resources, and follow the community that has many tips and solutions ...
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Comparisons

 

Also Known As

No data available
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

Global Investment Bank, Parkview Medical Center
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about InterSystems IRIS vs. SQL Server and other solutions. Updated: September 2026.
914,938 professionals have used our research since 2012.