Tag Archives: monitoring

Monitor All the Changes

Posted on November 22, 2016 by

Can you monitor every configuration change and setting on all your SQL Server instances? Can you get an alert every time code changes, or even if an option for an object changes, such as the changing of an EXECUTE AS … Continue reading →

Posted in Editorial | Tagged , ,

What is the Future of Monitoring?

Posted on September 28, 2016 by

I read Tom LaRock’s post on the future of monitoring, looking at the rise of machine learning and complex algorithms to evaluate systems. Tom notes that the data input into a system is crucial in determining whether the system can … Continue reading →

Posted in Editorial | Tagged , ,

Monitoring and Alerting

Posted on June 30, 2016 by

Monitoring your systems is important. It’s not just me that thinks so, as plenty of experienced DBAs and developers know the value of monitoring. Heck, most people have learned to build some sort of metric collection into their software. Azure … Continue reading →

Posted in Editorial | Tagged ,

Gauges and Alarms

Posted on August 8, 2015 by

I was looking through the news this week and found a piece by Michael J. Swart that I really enjoyed. It talks about different types of metrics that he has used when monitoring and alerting on his database servers. Michaal talks about … Continue reading →

Posted in Editorial | Tagged , , , | 2 Comments

Finding Production Drift

Posted on June 2, 2015 by

A few years ago when I started delivering presentations about automating database delivery with Grant Fritchey, I was surprised by something. We were rehearsing a talk and Grant mentioned that there were really only two places where we knew the … Continue reading →

Posted in Editorial | Tagged , ,

Awareness

Posted on May 18, 2015 by

How often have you been caught off guard by some issue with one of your databases? I would guess most people have received a phone call, email, or trouble ticket that alerts them to the fact that something has gone … Continue reading →

Posted in Editorial | Tagged ,

T-SQL Tuesday #66 – Monitoring SQL Server

Posted on May 12, 2015 by

This is a T-SQL Tuesday that not only makes me smile, but makes my boss happy. In fact, I’m sure that quite a few people at Redgate Software, my employer, are thrilled with this topic since we have a product … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Monitoring After Deployment

Posted on April 17, 2015 by

Deployments of database and application changes have tended to be stressful in my career. I’ve seen the actual deployment of changes fail, installation programs crash, the startup of an application error out, or the famous blue screen of death from … Continue reading →

Posted in Editorial | Tagged ,

Avoiding a DBA’s Worst Days with Monitoring

Posted on October 24, 2014 by

SQL in the City Abstract: When things go wrong with a database, it can be the start of the worst day of a DBA’s life. Join Steve Jones as he examines the problems uncovered by The DBA Team and how … Continue reading →

Posted in Presentations | Tagged , | 1 Comment

The DBA Team #1–Code and Slides

Posted on March 27, 2013 by

Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again. In the meantime, we … Continue reading →

Posted in Blog | Tagged , , , , , , | 2 Comments