"Ultimately SQL Monitor doesn’t just benefit the internal IT team at Claranet, it benefits our customers too."
With so many servers and customers to look after, the potential to miss critical SQL Server problems is extremely high, which is why Nick made sure he had a third-party SQL Server monitoring tool in place.
Like SQL Monitor, it had a lot of functionality, but it became slow and clunky, and Nick realized it just wasn’t getting the basics right.
"We can jump on it and fix it before the customer even notices."
"People have been freed up to do more project work."
Since its introduction, SQL Monitor has demonstrated the value of having a monitoring tool in place that not only provides alerts about problems, but helps pinpoint their root cause too.
When, for example, there was a problem with SQL Server sending read statistics through the roof, SQL Monitor was able to quickly drill down and identify which of the multiple instances was at fault, the drive, the database, and then the specific query that was misbehaving. Using SQL Monitor’s inbuilt Query Plan viewer, the team could see that there was a missing index. They added the index, ran it through test, and it solved the problem instantly.
SQL Monitor has also helped Claranet provide a better, more complete service to customers and be much more proactive. If customers want a view of the performance of their servers and the service Claranet is providing, they can instantly be provided with a report from the SQL Monitor reporting module. This can automatically be sent to them on a regular basis.
Not only has SQL Monitor been able to cope with Nick’s large SQL Server estate, it has helped the team to respond quicker to any issues, freed up their time, and saved them from unnecessarily spending money upgrading their infrastructure.