Case Study: SQL Diagnostic Manager for SQL Server plus SQL Doctor
Oil and Gas Firm Drills Down to Quickly Resolve SQL Server Issues
The challenge for this Fort Worth-based oil and gas firm’s IT department was how to manage more servers, more efficiently.
This firm’s IT staff needed SQL Server solutions to help them monitor, diagnose, and optimize the more than 2,000 databases on 50 Microsoft SQL Servers.
THE IDERA SOLUTION
A combination of IDERA’s SQL Diagnostic Manager and SQL Doctor have empowered this IT staff to more effectively manage the health, performance, and availability of their SQL Server environment. With SQL Diagnostic Manager, they can pinpoint performance problems before they become major issues. Leveraging the corrective measures suggested by IDERA’s SQL Doctor, administrators, developers, and analysts can now drill down into solutions to quickly diagnose and cure SQL Server performance issues and potential problems.
As part of an IT group responsible for supporting the systems operations of a fast-paced oil and gas company located in Fort Worth, Texas, systems analyst Joel Rickertsen has a wide range of duties. His primary focus is on the company’s 50 SQL Servers that range in size from 1-2 TB running on virtual machines to much larger databases that are clustered for fault tolerance. “We use SQL Server for many things, including monitoring the wells, production data, and how to run the wells. We also have monitoring systems that run safety systems in case a tank overflows,” he explained. As a result, being able to diagnose performance issues and identify server resource bottlenecks to make sure SQL databases are running at peak performance is critical to the company’s success.
POWERFUL PERFORMANCE MONITORING AND DIAGNOSTICS
Working for a company that is very careful about adding additional staff, Rickertsen explained that they were seeking a SQL Server performance and monitoring solution that could help them manage more servers in a more efficient manner. The firm’s servers also house critical back-end information, such as SharePoint, financial information, and custom in-house engineering applications. “Basically, we have about 2,000 databases that we support that cover a wide range of information,” Rickertsen said. Many of the company’s smaller locations across the U.S. have print and file servers. “With 50 SQL instances, some type of solution was needed. We started looking at different things across the industry, and we came up with three or four possible solutions,” he said.
- Case Study: Ancoris extends SQL Server monitoring with Microsoft SCOM using IDERA SQL Diagnostic Manager
- Case Study: Chevron gets its SQL Pipeline under control with SQL Diagnostic Manager
- Case Study: D4 Bolsters eDiscovery Services with IDERA
- Case Study: Franciscan Health Services Keep Mission-critical Applications in Top Form
- Case Study: How IDERA streamlined SQL Server management for the family-owned recycling company
- Case Study: IDERA Helps American Fidelity Assurance Cut Database Administration Time by 50 Percent
- Case Study: IDERA Helps LC Waikiki Optimize Its SQL Server Databases
- Case Study: IDERA Helps PointClickCare Improve KPI with SQL Diagnostic Manager
- Case Study: Infineon Technologies Increases Productivity with SQL Diagnostic Manager
- Case Study: Money Management International relies on IDERA to keep SQL Server running in top form
- Case Study: National Opinion Research Center saves over 200 percent on SQL Server management and administration with Idera
- Case Study: Plexus Monitors Worldwide SQL Server Enterprise Using Mobile Device
- Case Study: Seattle Cancer Care Alliance Monitors the Health of Critical Patient Care Servers with SQL Diagnostic Manager
- Case Study: The University of Notre Dame Enriches Student Services with IDERA
- Case Study: VCE Selects IDERA Over Quest for SQL Server Monitoring and Administration
Topics : Database Diagnostics,Database Monitoring,Database Performance,SQL Query Performance,
Products : SQL Diagnostic Manager for SQL Server,SQL Doctor,