SQL SERVER – Drivers for DevOps – Efficient Monitoring

At SQL Authority, my main job is to work with SQL Server Performance Tuning, and every day I learn that more organizations are implementing DevOps for their database platform. DevOps is a collaborative approach to software development and delivery that is influenced by Agile development methods and Lean IT principles. The idea is to decrease time to market by looking at software development as a life cycle and finding ways to automate and increase efficiency. Today I want to talk about why Efficient Monitoring is one of the most important drivers for DevOps.

Drivers for DevOps

Recently I was reading the 2020 State of Database DevOps report from Redgate and wanted to highlight the main drivers for adopting database DevOps:

  • To increase the speed of delivery of database changes
  • To free up Developers’ time for more added value work
  • To reduce the risk of data loss during the deployment process

It’s pretty clear that DBAs want to shift from mundane error-prone work to robust automation deployment so they can spend their time doing more valuable work for their organizations.

If everything works perfectly fine during deployment, then how do we know everything works fine?

And, if something does go wrong during deployment, how do we isolate that problem and resolve it?

The answer is very simple – Monitoring!

Efficient Monitoring

It’s clear that without efficient monitoring it isn’t possible to build a good DevOps system – a key finding in the 2020 State of Database DevOps report from Redgate.

Here are the results when people were asked the following question – How do you monitor your production databases for availability, performance, and other issues?

SQL SERVER - Drivers for DevOps - Efficient Monitoring drivers-for-DevOps-800x578

If you observe the graph carefully, it’s clear that nearly 80% of DBAs value the importance of monitoring. Sadly 22% of people indicate that their organization relies on customers to alert them to problems, when it would be so much better to to invest in an optimal monitoring tool for their organization.

Call to Action

The findings from this vital report will help any team who is interested in adopting or improving their approach to database DevOps, no matter the platform they choose to work on.

Download the latest The 2020 State of Database DevOps report from Redgate and you’ll discover a wealth of other findings:

  • The impact of Change Approval Boards on lead time and defect rates
  • The average frequency organizations are making deployments to production
  • How organizations are adopting Database DevOps alongside broader DevOps initiatives – and the advantages this brings

Reference: Pinal Dave (https://blog.sqlauthority.com)

DevOps, Redgate, SQL Server
Previous Post
MySQL – Get Last Query Cost Using SHOW STATUS LIKE ‘Last_Query_Cost’
Next Post
SQL SERVER – Displaying Smiley in SSMS – Emoji

Related Posts

Leave a Reply