"We had no way of telling what the actual performance was at that point or what caused the issue."
The performance of the servers used to be monitored using hand-written custom queries. As required, George would go into the servers to run the queries to see current performance.
This not only took time to run but didn’t give him the full picture:
"If I want to share the information with other team members, I just give them a URL"
"We have the answers to questions, especially when people ask about historical issues."
In a very short amount of time Prudential has already seen the value SQL Monitor can deliver.
They recently had an issue with a deadlock on one of the servers. SQL Monitor alerted them and pinpointed where the problem was, so they were able to resolve it quickly.
It's not just the alerting that George likes. He also uses SQL Monitor in a proactive way to carry out health checks on his servers.
Another feature that George finds invaluable is the ability to see if the system is running within normal parameters using the baseline function.
The value of SQL Monitor within Prudential has spread wider than just the DBA team.
SQL Monitor has also helped add value to the service the DBAs provide to developers.
SQL Monitor has proved to be an invaluable tool for George and his DBA colleagues at Prudential. It has saved them time, improved their working relationships with other parts of the company, and made them look more professional. They are able to see what is happening with the servers now and in the past, giving them a complete overview and making them more effective DBAs.