Redgate's second annual State of SQL Server Monitoring survey provides new insights into how the world of SQL Server monitoring is adjusting and adapting to emerging challenges, such as compliance regulations and cloud technologies, while keeping on-top of the usual issues such as deployments, availability, and capacity.
Over 800 SQL Server professionals across a range of sectors, in organizations of every size around the globe, told us how they monitor their SQL Server 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 24-page report to discover the results, including:
- The impact the cloud is now having on SQL Server management
- The biggest challenges teams monitoring SQL Server face in 2019
- The most popular tool for managing SQL Server estates
1. Which of these causes issues most frequently?
While bad deployments and capacity problems are still causing issues, these have dropped since last year with human error having the biggest impact on SQL Servers in 2019. While there is definite overlap in these areas, human error is more frequently attributed to the development side of the process rather than the deployment and management side.
These are exactly the areas where a third-party tool can help: they can provide alerting around each of these areas, and long-term tracking of trends in areas such as growth in database size, providing ample warning before the problem becomes critical. They can also help to identify issues with queries where human error has caused problems, fix them, and prevent them happening again.
2. How many SQL Server are currently on your estate?
While estates are still relatively small, they are growing. In 2018 37% of respondents had fewer than 10 servers, and this year that has dropped to 33%. Those with 10-19 servers have also dropped by 5%, those with 20-49 by 3%.
In contrast, respondents with estates of 50-99 servers have increased by 4%, 100-199 by 3%, 200-499 by 4%, and 500-999 by 4%. Those estates with 1000+ servers have remained at 3%.
3. How frequently does your organization deploy database changes?
The frequency of deployments continues to grow with most respondents (73%) deploying database changes multiple times per month. 41% expect this rate to continue to increase over the next 12 months (up from 38% in 2018), while the number expecting a decrease is down by 1%.
This continues to reflect the general trend toward more agile ways of working, including adoption of DevOps among database and software professionals.