Redgate’s new SQL Monitor now ensures that DevOps teams can monitor and track deployments at all times.
Slow development and release cycles, coupled with the inability to respond quickly to changing business requirements, are prompting companies to ditch siloed database development in favor of Database DevOps, according to the latest research from Redgate Software’s 2020 State of Database DevOps Report. As priorities shift and companies deploy database changes weekly or more frequently, Redgate’s new SQL Monitor now ensures that DevOps teams can monitor and track deployments at all times.
The desire to make the most of DevOps is encouraging companies to automate deployments to make them reliable, repeatable and consistent. This increasing pace of deployments, however, comes at a price. A deeper dive into the 2020 report shows that errors are creeping into the development process in the rush to release faster. Redgate first recognized issues arising in 2019, when the percentage of companies planning to automate database deployments within a year increased to 52% compared to 45% in the 2018 report. This indicated that more than half the users of Redgate’s own monitoring solution would need a way of tracking deployments, regardless of which automation tool they used.
In response, the latest version of Redgate’s SQL Monitor offers a new PowerShell API so that deployments from any third-party automation tool like TeamCity, Bamboo or Octopus Deploy can appear as annotations on the timeline graph for the server. Users can easily gauge whether their deployments have had any adverse effect, and drill down in seconds to the precise cause.
“We know that companies are adopting automated processes to help keep up with the pace of innovation, which is why the new SQL Monitor release enables them to deploy changes efficiently and find the root cause of a problem fast before users are ever affected,” said Kendra Little, DevOps advocate for Redgate Software. “We’re also seeing the real value of Redgate’s Database DevOps Report in its ability to track these issues over time. We can now see trends emerging, help identify where companies could hit a snag in the database DevOps process, and address it quickly. It’s like a customer feedback loop, incorporating data from over 5,000 participants over four years.”
Redgate’s 2020 Database DevOps Report shows that while 37% of companies use a third-party monitoring tool to alert them to deployment issues, another 37% still write their own monitoring scripts, and 22% rely on their customers to alert them when they have a problem. Additionally, the report found that some 30% of respondents require hotfixes for more than one in ten deployments.
This is worrying when 66% of SMBs and 60% of enterprises say they will have a fully automated database deployment process in place within a year. Without effective monitoring in place, it risks errors requiring hotfixes reaching production, and in more than one in five cases, companies being unaware of them until customer complaints start rolling in.
Download the full 2020 State of Database DevOps Report to find out more about how developers, database specialists and IT leadership across the globe are adopting DevOps, the challenges they face, and what the future looks like.