About ten years ago, I sketched out an idea for a different kind of SQL Server monitoring tool: one that gathered data just once per day, and gave you a short email with a specific list of actionable tasks to make a difference in health and performance. Richie Rump did an amazing job of building…
It's time for our quarterly update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server. There were only slight 1-2% shifts, nothing big:
SQL Server 2025: 1%
SQL Server 2022: 31%, up 2% from last quarter
SQL Server 2019: 42%, down 1%
SQL Server 2017: 9%, no change
SQL Server 2016: 9%, down 1%
SQL Server 2014 & prior: 6%, no change
Azure SQL DB and Managed Instances: 2%, no change
It's time for our quarterly update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server. In short, people are replacing SQL Server 2016 and 2017 with 2022!
SQL Server 2025: 0% (but it's 10 servers)
SQL Server 2022: 29%, up from 25% last quarter
SQL Server 2019: 43%, no change
SQL Server 2017: 9%, was 10%
SQL Server 2016: 10%, was 13%
SQL Server 2014 & prior: 6%, no change
Azure SQL DB and Managed Instances: 2%, no change
Ever wonder how big your database estate is compared to others? Whether you've got more servers, more databases, more workloads, or more problems?
Well, if you're one of my SQL ConstantCare® customers, check your email: our first set of badges just went out!
In this quarter's update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server, the data is very similar to last quarter:
SQL Server 2025: exactly 1 server being monitored, heh. God bless y'all for giving it a shot this early.
SQL Server 2022: 25%, up from 24% last quarter
SQL Server 2019: 43%, was 45%
SQL Server 2017: 10%, was 11%
SQL Server 2016: 13%, was 12%
SQL Server 2014: 5%, same as last quarter
SQL Server 2012 & prior: 1%, same
Azure SQL DB and Managed Instances: 2%, same
In this quarter's update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server, the data is very similar to last quarter. SQL Server 2019 still rules the market:
SQL Server 2022: 24%, up from 21% last quarter
SQL Server 2019: 45%, was 44%
SQL Server 2017: 11%, was 12%
SQL Server 2016: 12%, was 15%
SQL Server 2014: 5%, was 4%
SQL Server 2012 & prior: 1%, same
Azure SQL DB and Managed Instances: 2%, same
SQL ConstantCare™, our monitoring app that gives you a simple daily email with actionable tasks to make your servers faster and more reliable, is about to start sending out monthly awards! On the first weekday of each month, we'll email the winners with their gold, silver, and bronze badges.
Well, I say badges - some of them are badges of pride and honor, but some are badges of... well, let's just say you'll laugh when you'll put them on the company fridge.
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. Today it's time for the winter 2025 version of our SQL ConstantCare® population report.
SQL Server 2022 is finally seeing some good adoption with about 21% of the market. It's gradually taking market share from all other versions, including 2019, but 2019 still dominates with 44% of the market:
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. Today it's time for the fall 2024 version of our SQL ConstantCare® population report.
SQL Server 2019 is still the king of the hill with almost 3X more market share than any other version!
The short story: SQL Server 2022 finally saw some growth this quarter! Two years after the release, 1 in 10 SQL Servers is finally running the latest version.
The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s find out in the summer 2024 version of our SQL ConstantCare® population report.
You already use sp_Blitz and the rest of the free, open source First Responder Kit to give your SQL Servers a health check now and then.
But let's be honest: you don't do it often enough.
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha.
The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s find out in the winter 2023 version of our SQL ConstantCare® population report.
The short story for this quarter: SQL Server 2019 is on fire, dominating the market.
For the long story: ever wonder how fast people are adopting new versions of SQL Server, or what's "normal" out there for SQL Server adoption rates? Let's find out in the summer 2023 version of our SQL ConstantCare® population report.
The short story for this quarter: SQL Server 2022 adoption rates have stalled, even backtracked, and it doesn't appear to be due to the cloud, either.
For the long story: ever wonder how fast people are adopting new versions of SQL Server, or what's "normal" out there for SQL Server adoption rates? Let's find out in the summer 2023 version of our SQL ConstantCare® population report.
One of the things I love about SQL ConstantCare® (which happens to be free this month, by the way) is that I can keep in touch with what y'all are actually doing on your production servers.
Today's lesson was a complete shocker to me: some of y'all are changing the compatibility level on the master database.
One of the big principles of our SQL ConstantCare® monitoring product - which happens to be free this month - is that we only wanna tell you things you're actually gonna take action on.
Anytime we email you advice, there a few "Mute" links that you can click on to never hear this advice. You can mute the entire rule, or mute it for specific servers or databases.
In May, Amazon brought out a new Aurora I/O Optimized Serverless instance type. By switching to it, we cut our database costs by 43% overnight, saving us about $1,200 per month.
No strings attached. Just lower prices.
Ever wonder how fast people are adopting new versions of SQL Server, or what's "normal" out there for SQL Server adoption rates? Let's find out in the spring 2023 version of our SQL ConstantCare® population report.
Out of 3,002 monitored servers, here's the version adoption rate:
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 winter 2022 version of our SQL ConstantCare® population report.
Out of 3,679 monitored servers, here's the version adoption rate:
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 2022 version of our SQL ConstantCare® population report.
Out of the 3,151 servers sending in data recently, the most popular version of SQL Server is still 2016:
