Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the summer 2021 version of our SQL ConstantCare® population report.
Out of the 3,808 servers sending in data recently, the most popular version of SQL Server is still 2016:
When you group versions together it makes for interesting metrics:
- Now that SQL Server 2016 mainstream support is over today, only 34% of installs are under mainstream support with 2017 & 2019.
- The combination of 2016, 2017, and 2019 make up 67% of the market, but…
- The combination of 2014, 2016, and 2017 make up 74% of market share right now, exactly the same as 6 months ago! That’s kinda wild.
SQL Server 2008 and 2008R2’s market share stayed about the same, but 2012 went down by about 1/4, and 2014 down by about 1/10th. 2016 and 2017 stayed stable.
The newer products are at the top of this chart, and the new data’s at the right, so you can see the new stuff gradually pushing down the old stuff over time:
SQL Server 2019’s adoption has almost doubled over the last 6 months. In the last report, I predicted that come mid-2021, 2019 (currently 11%) would have more market share than SQL Server 2012 (currently 9%), and that turned out to be true.
Azure SQL DB’s share has actually gone way down, not up, but I don’t think that’s an indication of the wider market. I’ve had a few Software-as-a-Service (SaaS) companies try SQL ConstantCare® and bail because they get too many recommendations, since we send them for each connection. There’s probably a small market for a SaaS-focused monitoring tool that consolidates database metrics across all your databases and gives centralized recommendations about overall index usage and query workloads, and I’ll blog about that at some point. SQL ConstantCare® definitely isn’t that tool, and I don’t intend to build that tool, either.
SQL Server 2016 is still the juggernaut, with 1 in 3 instances overall.