Performance Investigator module enables us to dig into issues and resolve them much faster
What is our primary use case?
We monitor quite a few database servers. The actual number jumps up and down on a regular basis, but on average we're doing 120 servers at a time. It gives us one pane of glass to be able to see which ones are having actual issues and which ones are just going along.
Pros and Cons
"The PI module allows [my colleague] to identify which new indexes or modified indexes are going to make the biggest impact."
"I get a lot of alerts that, while important, are not critical. Then I have to dig in and figure out how to turn alerts off, but not the logging. I want to be able to go back, once we get the other big issues out of the way, and start fine-tuning some of those other areas, but I don't necessarily want to receive an email for all of them."
What other advice do I have?
If you've got the time for it, the time to focus on databases in general, then Foglight is definitely worth the expense because of the information that it can provide for you. The biggest lesson I have learned from using this solution is that it's worth it. It enables you to pin down troubleshooting within 30 minutes to an hour, whereas before, you'd be pouring over reports or data from queries for days. That's huge. The CIO has told me that since we've started using Foglight, we've actually gotten ahead of some of these issues and we're actually being proactive instead of reactive. We're in…