SQL Sentry | V Sentry
- New Belgium’s BI Specialist Erickson Winter was consumed with troubleshooting database performance, which hampered his ability to expand his BI expertise so he could focus on strategic initiatives.
- SentryOne solutions helped Winter reduce time spent on routine DBA tasks: SQL Sentry provides critical database performance information to simplify troubleshooting, the Environmental Health Overview dashboard presents a real-time overview of database performance, and V Sentry gives a unique view of resource utilization for VMware hosts.
- Winter now spends less than an hour each day monitoring, diagnosing, and optimizing the data platform—a task that used to consume most of his day—and can now focus on analytics projects to drive the business forward.
New Belgium Brewing Company,
Owned 100% by its 800 employees operating out of two core breweries in Colorado and North Carolina, New Belgium has a formalized commitment to environmental stewardship. The company has set goals to reduce greenhouse gas emissions, water consumption, and waste sent to landfills. One recent win: In 2016, 99.9% of the company’s waste (by weight) escaped the landfill.
This commitment to sustainability requires data collection that goes beyond what a typical company might capture. And, as the company notes on the web site, “We’ve gotta measure what we want to manage.” New Belgium gathers metrics on the amount of electricity the company produces on-site from solar and biogas sources, its greenhouse gas emissions (the company has a long-term goal toward carbon neutrality), and water use. In addition to tracking sustainability KPIs, the company collects data focused on typical business operations, such as orders, shipments, supply chain information, and sales reports.
New Belgium BI Specialist Erickson Winter is on a mission to ensure all the business-critical data flows freely from the company’s three datacenters so that he can focus on his passion for expanding the use of BI within the company to solve core business problems with technology— including using some machine learning approaches to creating visualizations for sales.
But to maintain his focus on these strategic initiatives, Winter needed to streamline routine database troubleshooting. By deploying SentryOne solutions, he has reduced his time spent on monitoring, diagnosing, and optimizing New Belgium’s data platform from an essentially full-time job to an hour or so each morning
“Before we had V Sentry, we just didn’t have enough insight into the VM host to be able to troubleshoot,” Winter says. The incident that spurred him to look for a solution was a SQL Server job that failed overnight just before an important business sales review. “It was just one of those perfect storms,” he says. “Sales leaders are going into a big meeting and needing the numbers. But, oh great, it failed today.” With V Sentry, the team had the specific information they needed to quickly solve the problem and get the data.
On a day-to-day basis, Winter has significantly cut his time spent on routine DBA tasks. He spends about 30 minutes to an hour with the Environmental Health Overview dashboard each morning going through the servers and resolving any potential database performance bottlenecks. He recently used SQL Sentry to help a team discover the source of a delay
“It took five minutes with SQL Sentry to point that out,” Winter says.“Overall, SentryOne has been a lifesaver for me in that I don’t have to spend nearly as much time doing DBA work, so I have more time for fun stuff— the career-building projects.”
SentryOne (sentryone.com, info@sentryone.com) empowers the Microsoft data professional to achieve breakthrough performance across physical, virtual, and cloud environments. The team shares its expertise at blogs.sentryone.com and sqlperformance.com.