The major use case I have is that whenever there's any kind of complaint about the performance of the database, I can go in. I can go back to that time and see what was happening on the database at that time. I can see if we had a high CPU or high IO, or if the memory was too high. I can go back and find the plan of the SQL and tune it as necessary.
Lets you know when your jobs are taking longer than average and allows you to go back in history and find out what was happening at certain times
What is our primary use case?
What is most valuable?
To be able to go back in history and find out what was happening at certain times is the most valuable feature of the product.
Another thing that's good about the product is that it will let you know when your jobs are taking longer than average so that you can foretell that there's going to be an issue coming up. Your SQL agent job is taking longer.
What needs improvement?
There could be some more metrics on the high availability to let us know when there are issues synchronizing between the hosts.
For how long have I used the solution?
I have been using this solution for probably three years.
What do I think about the stability of the solution?
It's fairly stable. It's just running in the background, and I use it as necessary.
How are customer service and support?
I dealt with them. They're very good.
How was the initial setup?
It's fairly straightforward. The problem with it being out of the box is that it's just very noisy. You get a lot of alerts, and you have to tune those alerts right.
What's my experience with pricing, setup cost, and licensing?
It's fairly expensive.
What other advice do I have?
Make sure that you configure your alerts so that you don't get bombarded by a whole bunch of different emails coming at you, or you can set up an alert email so that those alerts can go there.
Overall, I would rate it a nine out of ten.
