Swedish Match Uses SentryOne to Find and Fix SQL Server Performance Problems Before They Happen
CASE STUDY
For Swedish Match—a manufacturer of tobacco and nicotine products with more than 4,000 employees and facilities worldwide—a little goes a long way when it comes to managing their hybrid SQL Server environment. The company’s small DBA team manages nearly 100 production servers and more than 75 development/test servers, with SQL Server hosted locally and about 50 SQL Server databases on Microsoft Azure.
With just two DBAs to manage more than 175 servers around the world, Swedish Match needed a more responsive, comprehensive SQL Server performance monitoring solution.
The company implemented SentryOne SQL Sentry to proactively monitor SQL Server performance and gain reliable customer service.
With SentryOne, Swedish Match can quickly discover the root cause of performance issues—and monitor their international, hybrid SQL Server environment with ease.
As expected in an environment of that size, the team was using a third-party SQL Server performance monitoring solution. But over time, they realized the solution wasn’t up to the task. The support team was slow to respond and bug fixes were intermittent, according to Swedish Match DBA Tim Martin.
“Every time we had a problem, we would put in a ticket and it would be days before we received a response,” says Martin. And promised fixes never materialized. “It became so problematic that we stopped calling; we just lived with it.”
When Martin found out one of the three DBAs on the team was retiring and that the position wouldn’t be replaced, he knew it was time to find a robust SQL Server performance monitoring solution that could help them pick up the slack with one less DBA on the team.