Case Study: SQL Diagnostic Manager for SQL Server

One DBA, 21 SQL Servers and A Limited Budget

SQL Mobile Manager is now part of SQL Diagnostic Manager as its mobile console.

The top 5 ways this SQL Server DBA is saving time with SQL Mobile Manager:

  1. Viewing the status of SQL Servers (anytime, anywhere)
  2. Getting immediate notifications if issues arise (anytime, anywhere)
  3. Checking reports to see if any errors have occurred (anytime, anywhere)
  4. Checking the status of the systems as I’m driving to the office (so I'm not surprised when I get there!)
  5. Quickly troubleshooting and fixing performance issues in the event of an emergency (anytime, anywhere!)

Problem:

“I was using the native management tools in SQL Server which were often very time consuming and inconvenient to use. I needed a solution that would help me consolidate administrative tasks and make it easier for me to manage multiple SQL Servers. I was also hoping to find a solution that would allow me to manage remotely. That’s when I found out about SQL Mobile Manager, so I decided to give it a try.”

Answer: SQL Mobile Manager

“Right off the bat, I was amazed at the SQL Server management power that SQL Mobile Manager provides and how easy it was to use. It is also very intuitive, it didn’t take me long to install or begin using it at all.”

Fixing issues remotely

I recently used SQL Mobile Manager to fix a performance issue while I was out of the office. We had a blocking process that was blocking everything. I received a notification from SQL Mobile Manager, I then used my Windows Mobile Device to fix it in just minutes! However, if I had NOT been using SQL Mobile Manager, it would have taken me a lot longer to fix the issue. First, I would have had to get to a PC that was connected to the internet, call in, then walk someone through the steps to fix the issue on my behalf. Depending on my location, it could have taken an hour or more to fix this simple issue.

Powerful & fast diagnostics & reporting

Surprisingly, I have really been impressed with the reporting that SQL Mobile Manager provides. If there is an issue, SQL Mobile Manager provides several days worth of historical information that allows me to pinpoint where the issue started so that I can diagnose more effectively.

I am also really impressed with the speed at which SQL Mobile Manager is able to operate. Of course, that has to do with the wireless connection, but I have been pleasantly surprised at how fast I could get SQL Server information through SQL Mobile Manager. It’s also caused no noticeable drag on my systems.

Summary – DBA takes a vacation!

In a nutshell, SQL Mobile Manager saves me a lot of time and it makes my job a lot easier. It has allows me to provide 24x7 support for our systems without being chained to my desk. In fact, I’m hoping to be able to take a vacation sometime soon! Since I’m the only DBA on staff, I worry about leaving for an extended period of time, but now I don’t have to with SQL Mobile Manager.

Download This Case Study Start a FREE Trial of SQL Diagnostic Manager
Share This
Contact IDERA:
+1 (713) 523-4433