e-dokumen.com

CHEVRON GETS ITS SQL PIPELINE UNDERCONTROL WITH SQL DIAGNOSTIC MANAGER

PAGE 1 OF4THE CHALLENGEIderaSQL diagnostic managerChevron’s SQL Server database environment was growing fast. Up until now, theyhad simply relied on Microsoft’s native tools inside Management Studio. By thetime they hit 200 instances, Sumon Basu, Lead Database Administrator, SQL,and his team realized they needed a better solution for database management.COMPANY PROFILE—CHEVRONTHE IDERA SOLUTIONIdera’s SQL diagnostic manager proved to be the perfect solution to Chevron’sdatabase management challenge. Easy deployment and maintenance werea plus, while agent-free monitoring and minimal load on servers during datacollection helped to seal the deal.NUMBER OF EMPLOYEES: Chevron is a multinational Oil& Gas company headquartered in San Ramon, CA. Chevronhas a over 50,000 employees. The San Joaquin Valleybusiness unit has approximately 2500 employees.FOUNDED: Chevron traces its roots to 1879, with the foundingof the Pacific Coast Oil Company in Los Angeles, California.INDUSTRY: Chevron is one of the world’s leading Oil &Gas and integrated energy companies.WEBSITE: http://www.chevron.com

PAGE 2 OF 4Technical OverviewOVERVIEWCHEVRON Fortune 500 Oil & Gas company Over 50,000 employees worldwide Needed a better solution for managing its database Sumon Basu, Chevron’s Lead Database Administrator, SQL Server,was charged with finding a third-party alternative to Microsoft’snative Management Studio tools“We were not able to resolve problems effectively and in a timelymanner, especially trying to troubleshoot issues one database at atime,” Basu said. They needed something more efficient, with morerobust capabilities to fit their growing environment. They turned toIdera’s SQL diagnostic manager (SQLdm).Basu and his team saw SQLdm as an automated performance monitoringtool and a diagnostic solution in one package. “We were particularlylooking for a solution that would allow us to look back in time historically,since some issues may have happened at 3 a.m., and there wasn’t agood method to solve problems remotely on-call.” SQLdm proved tobe the right solution, offering Basu and his team the ability to analyzeperformance over time, as well as providing tools for diagnosing andresolving issues using either a desktop computer or a mobile device. The DBA Team consists of 6 members and there aremore than 150 DevelopersSumon Basu is the lead DBA of a team of 4 DBAs whooversee the SQL Server databases for ChevronThey have a multi-platform database environment,with a total of 1000 databases100 of those databases are SQL ServerSeveral SQL Server versions supported, including2005, 2008 and a few 2012There are more than 1500 system usersTheir database environment supports a multitude ofboth homegrown applications as well as third partyvendor applicationsSUMON BASULEAD DATABASE ADMINISTRATOR, SQL SERVER“We chose SQL diagnostic managerbecause it was easy to deploy andmaintain, and because it was agentless and did not put an excessive loadon the server during data collection.”—Sumon BasuLead Database Adminstrator,SQL ServerChevron

PAGE 3 OF 4SIMPLE & COMPLETEThe growing demands of critical SQL Server instances, incidents, anduser requests made it difficult to find a comprehensive solution. Meetingthese demands while proactively monitoring the SQL Server environmentwould require a third-party solution with robust and comprehensivefeatures. Additionally, Chevron needed a system that would allow DBAsto monitor several SQL servers at once. SQLdm’s enterprise-wide consolewas an attractive benefit, allowing them to monitor their growinginventory of SQL server databases from a consolidated interface.It also had to be simple to implement. “We chose SQL diagnostic managerbecause it was easy to deploy and maintain, and because it was agent-lessand did not put an excessive load on the server during data collection.”Try SQL diagnostic manager FREE for 14 c-manager/SQLdm offered features that stood out above those of competitors.“Getting alert notifications on blocked sessions and locking status of thedatabase is very helpful,” Basu said. “And the ability to drill down and seethe resource utilization during different operational times was a real eyeopener for us. “The production support team appreciates SQLdm’s micro-level control,which allows them to increase performance efficiency. “Applicationsare more fine tuned to peform in a timely manner,” Basu said, “whichincreases productivity. We save around 15-20% of our time in gatheringsystem performance data—almost the equivalent of one resource salary.”Basu and his team were so pleased with the ease and the features ofIdera’s SQL diagnostic manager, they are already considering other IderaSQL solutions. “There are potential plans to evaluate auditing solutions,so Idera’s SQL compliance manager will definitely be on our short list tocheck out.”SQL diagnostic manager offers these key features: Monitor and manage SQL Serversenterprise-wide Find and fix performance bottlenecks Analyze performance over time Diagnose and resolve issues from thedesktop or mobile device No agents or database objects required onmonitored servers

PAGE 4 OF 4ABOUT IDERAIdera provides systems and application management software for Windowsand Linux Servers, including solutions for performance monitoring, backupand recovery, security and compliance, and server administration. Ourmarket-leading product suites provide 360 degree management solutionsfor the Microsoft SQL Server and SharePoint platforms, as well as highperformance backup and recovery for server operating systems. Whetheryou have ten servers or ten thousand, we give you the best performanceand value with products that are easy to install and deploy, and that deliverreal and measureable ROI.Our products are used by over 10,000 companies worldwide, includingFortune 500 enterprises, government agencies, and some of the world’slargest datacenters and cloud infrastructure providers. Headquartered inHouston, Texas, Idera is a Microsoft Managed Partner with an internationalpresence in Europe, Asia Pacific, and Latin America.Idera is headquartered in Houston, TX with offices in Londonand Melbourne.USMonitor key performance metrics. SQL diagnostic manager givesyou a comprehensive performance monitoring solution. You canget a free, fully-functional, 14-day trial from Idera.com/SQLdmEMEAAPACMEXICOBRAZIL 1 713 523 4433877 GO IDERA (464 3372) 44 (0) 1753 218410 61 1300 307 211 52 (55) 8421 6770 55 (11) 3230 tter.com/Idera .com/groups?gid 2662613

THE IDERA SOLUTION Idera’s SQL diagnostic manager proved to be the perfect solution to Chevron’s database management challenge. Easy deployment and maintenance were a plus, while agent-free monitoring and minimal load on servers during data collection helped to sea