Redgate Announces New SQL Monitor Release to Address the Promise and Pitfalls of Automated Database Deployments
Latest research from Redgate shows two thirds of businesses moving to automated database deployment processes over the next year, making deployment monitoring more important than ever
Cambridge, UK – March 25, 2020 – 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. For more information about Redgate’s SQL Monitor, visit: red-gate.com/monitor.
About Redgate Software
Redgate makes ingeniously simple software used by over 800,000 IT professionals around the world and is the leading Microsoft SQL Server tools vendor. Redgate’s philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day and help them to adopt compliant database DevOps. As well as streamlining database development and preventing the database being a bottleneck, this helps organizations introduce data protection by design and by default. As a result, more than 100,000 companies use Redgate tools, including 91% of those in the Fortune 100.
Jaime Tero for Redgate
+1 415 277 4919
Was this article helpful?