Spotlight Cloud Blog

Move from Firefighting to Fire Prevention: Efficient SQL Server Troubleshooting

June 19, 2018 7:20:00 AM PDT / by Spotlight Cloud

 

DBAs are a lot of like firefighters. You’re running around like crazy, extinguishing the latest disaster to strike your company’s SQL Server database. And with so much going on, it’s hard to even look at the forensics of why it caught fire in the first place.

A friend of mine recently moved up to the California mountains – about 6000 feet above the clouds. And, from what I’ve heard… it is beautiful and peaceful up there.

But she knew that one danger in living in the forest is the threat of fire.

When they moved in – they, of course, had smoke detectors and fire extinguishers – doesn’t everyone? They were protected – so they thought...

Well, in the summer of their first year… there was a fire. It was close. And it was scary.

As they packed up their truck with their cat, dog, and valuables, they drove toward safety and looked in the rear-view mirror at their home, everything they had worked for, and wondered if it would still be there tomorrow.

Well, it was – and they were grateful. It was a close call. They were scared. But what did they learn?

They learned that just an alarm isn’t enough. To protect yourself from disaster and loss, you need to take preventive measures. So, they cleared any brush away from the house and encouraged neighbors to do the same. They installed sprinklers in and around the house and implemented an alert system to let them know about any local conditions that might lead to fire danger.

The reality is – once there is a fire, it’s often too late to protect your investment.

As a DBA, you face the same risk – your company relies on the database you manage to support its critical applications and continue doing business. If something goes wrong, it can have a grave impact on productivity, customer confidence, and revenue.

What if you could take a proactive and preventive approach to database management and use tuning and diagnostics to resolve potential threats, preventing a disaster before it happens? The result? The ability to better ensure database uptime and stability.

ICYMI – A few weeks ago on the blog, we looked at an overview of Quest's newest database monitoring service - Spotlight Cloud – feel free to take a refresher on features that will prevent disasters from happening.   

Bottom line, having the capability to monitor your database for signs of trouble, before they become major issues for your company, is like becoming a forensic firefighting engineer.

Oh… and did you know that you can also accomplish all this while saving your company money? Purchased on a subscription basis, with no additional hardware, no software, no maintenance costs, Smokey the Bear and your boss…. will be proud.

Find the best database performance monitoring solution that has the features  you really need.

Topics: Monitoring Smarter

Spotlight Cloud

Written by Spotlight Cloud

Understand your SQL Server infrastructure health at a glance by monitoring SQL Server's relational engine, Analysis Services, Windows, VMware ESX and SQL Azure with Spotlight.