5 September 2017
5 September 2017

Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn’t. But one particularly common culprit is when deployments go wrong: I don’t know a single DBA who hasn’t been burned by a bad release.

To help, hundreds of thousands of developers and DBAs use Redgate’s Database DevOps solution to automate the build, test and deployment of their database changes. By implementing reliable, scalable and repeatable processes the risk of introducing defects into production is significantly reduced. But what if the change behaves differently to expected in the production environment?

An example

Here’s the top of SQL Monitor’s Server Overview screen – the sort of screen you might be looking at after learning that a server’s running slowly. SQL Monitor raised a High CPU alert at 8:31, and it’s pretty clear that something went dramatically wrong shortly beforehand, but what?

At this point, the challenge is to narrow down the root cause as quickly as possible. As the DBA, this kind of investigation turns you into a detective, where every minute taken to find the problem has a real cost to the organisation’s productivity, as well as to your reputation.

While bad deployments can eventually be tracked down by following other avenues, SQL Monitor now makes the cause of the problem instantly obvious by surfacing deployment information generated by Redgate’s deployment tools (DLM Automation, ReadyRoll, and SQL Compare) in context within SQL Monitor.

You now see the release marked on the timeline immediately below the performance data, and upon hovering, we see which database was deployed to, as well as by what tool. This saves valuable time by instantly revealing the smoking gun, with no further exploration needed.

This capability is part of Redgate’s SQL Toolbelt – it is available today for any changes made by the latest versions of DLM Automation and ReadyRoll, and will ship in SQL Compare within the next couple of weeks. There’s zero setup needed, either in SQL Monitor or in the deployment tools, so changes made by anyone in the organisation using these tools will automatically be shown.

Sometime in the future we hope to advance this even further, with information about the user responsible for making the change, and potentially the build number in the case of automated deployments. But for now, we hope that simply being able to correlate changes in key metrics with releases at a glance will make your life a little easier.

What now?

Check out the latest version of SQL Monitor, or read more about Redgate’s Database DevOps solution. As usual, we’d love to hear your feedback. How can we improve this further? Just drop an email to sqlmonitorfeedback@red-gate.com.

Thanks!

Ben

 

Requirements

To take advantage of this capability, you’ll need to be running SQL Monitor 7.1.5+ along with SQL Compare 13.0.3+, DLM Automation 2.0.18+, or ReadyRoll 1.14.13+. Additionally the deployment tool must be licensed as part of the SQL Toolbelt, rather than as a standalone product. The user making deployments will need to have execute permission on xp_logevent (or can alternatively either have the dbowner role on the master database, or be a sysadmin).

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

Related posts

Also in DLM Automation

Database CI with Redgate DLM Automation, PowerShell and Jenkins

While the practice of Continuous Integration (CI) started with application code, you can apply the same principles to databases. Database CI is the process by which we build, test and deploy the datab...

Also in Hub

Templates and Snippets in SSMS and SQL Prompt

In SSMS, we have access to templates that provide building blocks for creating various types of query, common routines to create various schema objects, or to do common DBA tasks such as running backu...

Also in Product learning

How we used your feedback to improve parentheses formatting in SQL Prompt 8.1

After we released SQL Prompt 8, our priority was to continue to support the new formatting engine by fixing any bugs and reviewing feedback from users.

One of the recurring patterns we noticed in you...

Also in ReadyRoll

How to import an existing database to ReadyRoll

The SQL Toolbelt includes ReadyRoll, which allows you to adopt a migrations-first approach to database source control and deployment. There are a number of different ways teams can get started with Re...

Also in SQL Compare

How to examine differences with SQL Compare Summary View and SQL View

During the recent Redgate Hub Launch Livestream Steve Jones introduced the new Summary View, which is available now in SQL Compare.

The brand new Summary View is a tab that sits alongside SQL View an...

Also in SQL Monitor

SQL Monitor plans for the second half of 2017

SQL Monitor's dev team has made huge improvements to the product over the last year. In the first half of 2017 alone, they released reporting capabilities, support for collecting metrics from VMWare h...