Solutions for Every DBA

Reza Koohrang

Subscribe to Reza Koohrang: eMailAlertsEmail Alerts
Get Reza Koohrang: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Related Topics: Data Services Journal, Application Performance Management (APM)

APM: Case Study

Massimo Zanetti Simplifies and Streamlines Day-to-Day SQL Tasks

Coffee Roaster credits IDERA with delivering significant time-saving and productivity gains

Overview
Massimo Zanetti Beverage USA is among the nation's largest coffee roasters, with nationally recognized retail brands including Chock full o'Nuts®, Hills Bros.®, Segafredo Zanetti®, MJB®, and Chase & Sanborn®. With headquarters and a state-of-the art manufacturing facility in southeastern Virginia, the company produces proprietary and private label coffee, tea and drink mix for customers in all retail channels and food service throughout North America and around the world, roasting more than 150,000 tons of green coffee per year.

Challenge
Despite having more than 400 employees, four distribution hubs and a national delivery network, Massimo Zanetti USA has a small but dedicated IT team and only one database administrator (DBA) tasked with ensuring efficient operations across the company's 22 SQL Server databases.

To meet fast-growing operational demands, Massimo Zanetti's IT team needed a flexible and effective way to monitor, manage and resolve issues across it's SQL environment, including servers running critical applications such as SharePoint, JDE One World, RF Smart, Logility and more. The company also needed a solution that was affordable and did not require scripting.

"When it comes to getting coffee into the hands of our consumers, every second matters. As the company's lone DBA, I wanted a solution that could quickly provide access to server details, retrieve data and ensure top performance for all of our system users," said Monica Rathbun, senior database admin and business intelligence architect at Massimo Zanetti Beverage.

Solution
Today Massimo is using IDERA SQL Compliance Manager, SQL Admin Toolset, SQL Virtual Database, and SQL Doctor.

These solutions provide comprehensive monitoring, auditing, alerting, administrative, and diagnostics tools, allowing Massimo to simplify and streamline day-to-day admin tasks, quickly find and fix SQL performance issues, and audit their SQL servers faster than ever.

A long-time IDERA customer at previous companies, Rathbun immediately turned to IDERA's SQL Diagnostic Manger as a monitoring and performance solution, evaluating the product alongside Redgate and SQL Sentry.

Benefits and Outcomes
Massimo Zanetti credits IDERA with delivering significant time-saving and productivity gains, allowing its IT team to more efficiently manage the datacenter and focus a greater majority of it's time on higher value tasks.

"The IDERA products have saved us so much time and made our IT organization much more productive," said Rathbun. "From providing backup status to moving users and jobs to new servers, I am more confident than ever in the performance and status of our database operations. IDERA gives one DBA the ability to do the work of 20."

More Stories By Reza Koohrang

Reza Koohrangpour is a product marketing manager at Idera responsible for the company's portfolio of SQL Server management tools and network and application performance management solutions.

Prior to joining Idera, Reza worked as a field sales consultant at Condusiv Technologies, and held roles as a senior technical product marketing manager and Cloud Services product manager (SaaS) at Dell, where he was responsible for the company's $70+M campus networking business and managing its PowerConnect, as well as M-Series Blades and Chassis C-Series family. He has also held engineering and research roles at Cisco, IBM and KTH Royal Institute of Technology.

Reza was awarded a patent for System and Method for Integrating Asset Tagging with a Manufacturing Process and holds several certifications including Cisco CCNA, Advanced IP networking, PRP (SDLC) 1.0 and 2.0, and advanced switching and routing.

He has a Bachelor of Science in Electrical and Electronics Engineering from Isfahan University of Technology, a Masters of Science from Chalmers tekniska högskola, and an MBA from the Texas A&M University Mays Business School.