Try Spotlight Cloud ProSign in

    How to Efficiently Troubleshoot SQL Server

    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 6,000 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.

    How to Efficiently Troubleshoot Your SQL Server

    As a DBA responsible for your SQL server monitoring, 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.

    Mobile SQL Server Performance Monitoring is Possible

    Mobility is no longer a trend, it’s a reality for Today’s DBA.

    Striking work life balance is even harder than ever. Today’s DBA is often asked to manage many more database instances and even participate in analytics, DevOps and cloud initiatives. Of all the ways your mobile devices give you flexibility, have you ever used them to monitor your SQL Server performance? Think of the peace of mind that would give you as a DBA.

    We call that “Mobility Tranquility” – the freedom to monitor the health of your SQL Servers anytime and from anywhere using the Spotlight Cloud mobile app.

    Why stop your life to monitor your SQL Server databases? It only makes sense to add your SQL Server performance monitoring duties to the long list of things you can do from a mobile device, where convenience reigns supreme.

    Check out this Heatmap from the Spotlight Cloud mobile app:

    image1 copy 3

    We call this the “Dilbert manager screen” because you don’t need to know anything about SQL Server to understand how it works. But I’ll tell you anyway.

    Use a Heatmap to Prioritize Issues

    We’ve put the biggest, reddest boxes at the top to show you where to focus your energy first – in this case, on the SQL Server instance named <insert name>. It’s simple but effective, because if you have tens or hundreds of instances running, your immediate question is usually, “What shall I focus on first?”

    You could be camping in the mountains, taking a selfie at Disneyland or cheering on your favorite team at the stadium while checking the Spotlight Heatmap and phoning your fellow DBAs in Chicago to have them troubleshoot.

    Lower and to the right in the Heatmap are the SQL Servers that don’t need immediate attention. You can examine them as well, but the iPad mobile app makes it clear how to set your priorities.


    When you swipe right, you see details like color- and number-coded alarms against each connected SQL Server, with their associated severity: How cool is that? Information at your fingertips to make immediate and informed decisions.

    This app offers 24x7 SQL Server performance monitoring and management capabilities, plus mobile diagnostics and issue resolution to keep your SQL Server environment humming.

    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 SQL Server 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, grab your sunscreen and start your free trial of Spotlight Cloud. It’s the modern way to monitor your SQL Server and get a tan!

     Get Spotlight Cloud now and start real time monitoring on your mobile device.

    New call-to-action
    June 19, 2018 7:20:00 AM PDT
    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.