Multi-Cloud Adoption Drives Database
November 20, 2020
rise in cloud adoption, alongside the move by organizations to use a
number of different cloud vendors, will have a big impact on the way
database estates are managed and monitored in the future, research
An analysis of the data from a 2020 State of Database DevOps survey
earlier this year shows that 49% of organizations are hosting all, some,
or a combination of their servers in the cloud. In the IT & Tech sector,
this rises to 64%, with Media & Retail close behind at 60%.
This hybrid approach, with some servers on-premises and others in the
cloud makes monitoring the health of server estates and proactively
finding potential problems before they impact users more complex. It’s
also compounded by findings from Redgate’s State of Database Monitoring
survey conducted later in the year.
The survey shows that 54% of respondents now use Microsoft Azure, a big
increase of 15 percentage points compared to 2019. More importantly,
however, organizations are also using other cloud providers like Amazon
RDS in combination – a finding supported by the 2020 State of the Cloud
Report from Flexera, which shows that organizations are using an average
of 2.2 public clouds, and experimenting with an additional 1.2.
Redgate’s research has been affirmed by the latest Worldwide Quarterly
Cloud IT Infrastructure Tracker from IDC, which shows that spending on
public cloud infrastructure increased by 34.4% year on year in the
second quarter of 2020, with spending on non-cloud infrastructures
falling by 8.7% over the same period.
This is the first time this has happened, with IDC linking it to
adjustments in business activities caused by the COVID-19 pandemic. IDC
also notes that it sees the move as a ‘tipping point’ and organizations
will continue to increase their investments in cloud environments.
For database professionals in every sector, this will make the task of
monitoring their database estates even harder. Redgate’s monitoring
survey also revealed that 50% of respondents spend two hours or more
each day checking the health of their databases, which rises to five
hours for those with estates of more than 500 instances.
Jeremiah Peschka, Technical Lead on the Monitoring Team at Redgate
Software, comments: “Monitoring databases for performance issues has
always been a tough job, but it’s now common to have a mixture of
on-premises servers as well those on cloud platforms like Azure SQL
Database and Amazon RDS and EC2. That’s going to become more and more
complicated as multi-cloud adoption increases and home-grown database
monitoring solutions won’t be able to keep up.”
To help address the issue, Jeremiah Peschka and his team have been
working behind the scenes to add full support for Azure and Amazon to
Redgate’s popular SQL Server monitoring solution, SQL Monitor. Version
11 has just been released and users can now monitor all of their
servers, databases and instances, whether on-premises or anywhere in the
cloud, on one screen.
This will ease the management of hybrid, multi-cloud SQL Server estates,
allowing database professionals to maintain the performance of their
servers, wherever they are hosted.