Ultimately, when you negotiate how many licenses you need, you always find the most problematic instances. You also have to also evaluate the culture and maturity of an organization. Unfortunately, there is often a lot of legacy code to maintain. It's not always easy to identify those things quickly.

In that context, Foglight has been pretty spectacular in terms of the number of times I have been able to answer questions that nobody could answer before. I used the tool and showed my team how you use the tool to answer a lot of those questions, and some of those questions were pretty complex. We'll have deadlocks, we'll have locking conflicts, we will have blocking, and we'll have unexpected CPU spikes. Obviously, there is some complexity involved with the architecture and that is not always clear, but the tool is phenomenally helpful in enabling us to change and repair things.

We have also been able to predict a problem. A lot of times you can see a particular process starting to misbehave. Visually, you can see the spike, and it is something that could potentially lead to a bigger problem because the process will not scale. It gives you an opportunity to address things before they become real problems.

When it comes to displaying intensive database queries, Foglight is the best tool. Spotlight does not do that very well and Foglight is fantastic. It enables what they call a multidimensional analysis. You have a visual presentation of query resource utilization and you can slice it by the type of resource. You can also slice it by the number of executions.

For example, a few times I've seen a server running very hot, the CPU would be 80-plus percent, and people are starting to freak out. But in reality, the box is very healthy. It has no locks or blocking. Rather, it's utilizing the CPU because that's what you want it to do. You always need to juxtapose multiple metrics simultaneously, and Foglight is really good for that. It has a dashboard where you can look at multiple parameters and components at the same time. If I see the CPU goes up and I also see the number of connections goes up and the number of batches per second goes up, to me it just means that SQL Server is working hard because we are processing fast and we are able to have more work done in a particular time frame.

A lot of times, when you do have problems, you actually see the CPU go down. People say, "Well, what's the problem?" The problem is that you have some internal blocking or locking, or some kind of resource contention, and the CPU cannot process as many batches per second.

When it comes to identifying the least performant queries, or queries that are performant but that are just very hyper with a lot of calls to them, that is where the tool really shines. It allows you to identify those things quickly.

There is something called SQL PI which Foglight offers, although it is only used for Oracle and SQL servers at this point in time. But that feature is really helpful for us in terms of assessing the performance of a database, or to see what kind of consumption is happening which could cause performance issues in a database. To an extent, Foglight is helping us to find the root cause. From a very high-level overview, across the whole Lowe's organization, if you ask me what kind of SQL query is taking a very long time to run and that might trigger a performance issue, we are able to access that from Foglight. In terms of metrics, we look at the tablespace data, the database space, the log space, as well as the availability rates of the databases, up or down, and how often downtime is occurring. These are some of the critical metrics which help us to measure the performance and increase the performance of the databases if required.

We have more than seven different types of platforms in Foglight. The fact that it enables us to monitor multiple platforms is a really cool feature. It gives us a single pane of glass to look at all the different types of databases in one place. That helps our database teams. We are the monitoring team that provides the monitoring solutions for our customers who are the different types of DB guys or DB teams. We are monitoring Oracle, SQL, MongoDB, Db2, Sybase, and Cassandra databases. Foglight gives all these DB teams a single tool to log into and look at the databases. They can see the performance of a database at any point in time, or they can take a look at the alerts for their databases. While the teams don't use it proactively to see if there are any long-running queries, they can always pull a report for the past month or so and see what kinds of queries are taking a very long time. That can help the database guys to ensure that the SQL query performance is improved. It also has a feature, out-of-the-box, to display long-running queries, which is really helpful.

There are very specific database alerts that Foglight provides, to make us aware of an issue before it becomes a production issue. It can prevent us from having a production outage, which, if one were to happen, would increase our cost of business or decrease revenue flow. Foglight has the effect of improving our overall productivity, reducing downtime, and increasing profits.

It also enables us to monitor multiple database platforms, including Oracle, SQL Server, Db2, and MySQL. In the future, we will add Postgres to the monitoring tool. It gives us one platform with one interface to look at the entire enterprise, which promotes efficiency and ease of use.

Foglight's ability to quickly diagnose and resolve emerging issues is almost indispensable. That is especially true for SQL Server which has a very limited number of tools that you can use to drill down into issues. You can only do a limited number of things in SQL Server. Foglight has been extremely useful for us for troubleshooting emerging issues in SQL Server.

In addition, we use the solution to display intensive database queries and that has been very useful. We can find out which queries are high consumers and find out why they're using so many resources, or we can contact the user to find out what they were doing and see if they can stop what they're doing.

The solution has nothing to do with how the organization functions. It has a lot to do with how I do my job, and how I can help the organization stay on top of things. I need to know, from the ground up, what's going on and when it is happening. The tool allows me to know that. I don't know that the company realizes the value of it. Of course they do, because they're paying for it, but the DBA team, for sure, knows the value of it.

It allows me to do more than I could otherwise. The tool does your job for you in a lot of ways. If I had to collect all that information myself about 500 different instances, I'd need a year to do it. It does that every day. Now, I'm free to fight those fights and still have time to do the upgrades and do the other things, the fun stuff, including building stuff, instead of just troubleshooting all the time. It brings with it a growth factor too, for any DBA that wants to show their value. Just watching a monitored screen is not going to provide much value, in the eyes of the bosses. But when you can do that and do upgrades and other stuff in a week, then you start to show value. It provides you time to do everything else because it does so much.

We also get emails from Foglight every day about long running queries, long running jobs, and broken jobs. Again, it's really doing my job for me. I just have to respond to it. It tells me what I need to do and I do it.

We can also drill down and do root cause analysis for most things. That's a huge benefit of the tool. We mostly have Windows boxes. Between the drill-down for root cause and Event Viewer, you can decipher what the root cause of anything was, or just prove what it was. The same information comes out of Foglight that would come out of Event Viewer. It saves us tons of time. I couldn't do all of my job in one week if I didn't have the tool. The company would probably have to hire another person if we didn't have it.

It enables us to monitor multiple database platforms. We have MS SQL, Oracle, Db2, and Sybase. We also have Vertica and other platforms for which we use a custom monitoring solution from Foglight. That ability has been very helpful because the DBAs don't have to go to different vendors to get the information. It's all assembled in one place and it buys them time and makes it simple to find out what's going on with the databases.

Using it, we're also able to monitor the OS, hybrid clouds, and hardware across different platforms. For the most part, it would just be the Linux and Windows platforms, because those are the main two that we use. This ability is handy because of the resulting simplicity for the DBAs.

One of the benefits we see from it is the fact that it already has an answer for us without us really having to ask around. I jump right to that baseline chart and I can show everybody that, between this time and that time, the databases were running as they should be. That way, we know we have to look at something outside of the database as being the issue.

Foglight definitely saves us time when it comes to root cause analysis. We have one senior DBA who will also run some code within SQL Server to double-check a few things, but for the most part he will jump right into Foglight and use that to try to pinpoint where the problem is. He will then take any code he finds in there and throw it into SQL Server to decipher things there.

When we do have issues, for example, that our financial software starts having slowness, we can use the Performance Investigator module and dig into where it's actually slowing down. It allows us to do the troubleshooting and resolution at least 10 times faster and get the users back to work. I and one other senior DBA on the team have built queries that we can dig in with, but going through all the results is huge and time-consuming. This solution helps us narrow in on the problem a lot faster.

Also, our AppDev team used to love to develop on production servers. By being able to show them the metrics of how they were actually affecting the performance, we were able to get them to move to a development server and not do any development work while they're on the production server. In the four-and-a-half years that we've been using it, that change has probably saved us four years' worth of time.

In general, it helps us become more proactive rather than reactive. DBAs can go in and look at the different alarms and tweak thresholds. Obviously, if we wanted to be proactive, we would want to catch some of these issues while they are still in the warning or critical stage before they become fatal alarms. So, the biggest benefit to the organization is the fact that we can proactively monitor databases and prevent downtime. For example, this could be resource contention, where we could look at memory, CPU, or storage. If it is starting to creep up and show yellow or orange on the dashboard that means the DBA needs to either troubleshoot what could be grabbing all those resources or plan to extend some resources, before they run out.

When we use the solution for monitoring databases, it enables us to drill down and see what is causing an issue, e.g., if something doesn’t look right, especially if the DBA is seeing a pattern. If it is something that recurs a couple of times, then we would definitely leverage Foglight as well to drill down and take a look at activities. We also have the Performance Investigator in the environment, which I find to be handy because you can drill down into actual connections and look up which users are connected, which workstations are connected, and which servers are connected, then try to drill down on the problematic session/query. Sometimes, if we are troubleshooting performance, then we will need to drill down into the end user or the actual client machine where the connection is coming from. We have the ability to go back and adjust the timeline to drill down to a specific time window. That is where the Performance Investigator does a great job. This has saved us lots of time with root cause analysis. It could save anywhere from hours to days. If you are trying to track things down without these types of tools, then it becomes really challenging.

The ability to monitor multiple database platforms streamlines our database operations. The single pane of glass is what we were really after when we picked Foglight. We knew we wanted something that could monitor cross-platform because it does save a lot of time to use the same tool. The one thing that I like with Foglight is that we don't have to install anything locally, like agents, directly on the database servers. That was also a big seller because it simplifies things.

Right now, we leverage the infrastructure cartridges, which come with Foglight for Oracle and SQL, for OS monitoring. This is very important because we do have to monitor the storage CPU, memory, and network.

Maintenance was not done properly for over two years before I came in. The solution crashed over the next year, then we migrated the client to another monitoring platform.