Redgate's third annual survey on the state of database monitoring provides new insights into how the world of server, instance, and database monitoring is adjusting and adapting to the emerging challenges of 2020.
Over 971 database professionals across a range of sectors, in organizations of every size around the globe, told us how they monitor their estates, the technologies they work with, what their biggest challenges are, and what the future trends for the industry are likely to be.
Download our free 34-page report to discover the results, including:
- The impact COVID-19 has had on the industry
- The biggest challenges database management teams face in 2020
- How monitoring is aligning with wider DevOps processes
1. Which of these causes issues most frequently?
Last year we saw that human error was problematic, and that has remained in 2020 with 23% of respondents reporting it as the most frequent cause of issues.
Interestingly "Ad hoc user access" has increased by over 10% to become the second biggest cause. This could be related to human error, and could also be the result of greater remote working this year, with the result that tasks become more widely distributed.
Capacity problems and bad deployments continue to effect database management, and these are exactly the points where a third-party tool can help: they can provide alerting around each of these areas, and long-term tracking of trends of things such as growth in database size, providing ample warning before the problem becomes critical, and identifying who has access to your data. They can also help to identify issues with queries where human error has caused problems, understand where and what to fix, and prevent them happening again.
2. Which database platforms are currently in use on your estate?
Despite asking a larger audience about a wider range of databases in our 2020 survey, SQL Server on Windows is by far the most used platform. It is also most used as the sole platform on an estate, with over 21% of SQL Server users saying it makes up 100% of their servers, and 77% reporting that it makes up the majority of their estate.
The other popular platforms are MySQL, Oracle, and PostgreSQL. In most cases organizations are opting to use a range of databases for their operations. There are multiple layers to monitoring complex estates, from an infrastructure level to establish the overall health, down to specialist tools to help those managing those particular servers and databases.
3. How many on premises and cloud instances are currently in use on your organization’s estate?
Continuing the trend from our 2019 survey, there has been a big shift towards larger estates, with those reporting fewer than 100 instances dropping while those with over 100 on their estate increasing. The biggest increase has been those estates with over 1000 instances, which is up 9 percentage points year-on-year.