Global manufacturer Samsung Electronics needed more-detailed information about its energy usage. In 2012, the company deployed an 80-terabyte equipment-monitoring system based on the Microsoft SQL Server 2012 Fast Track Data Warehouse. As a result,
Samsung Electronics collects 10 times more data about energy consumption; increases storage capacity from 6 terabytes to 80 terabytes; boosts performance by 10 times with 75 percent less hardware; cuts costs; improves control; and boosts innovation to facilitate
greater efficiency and energy savings.
As a leading global manufacturer of high-tech equipment, Samsung Electronics implements energy-saving plans to minimize environmental impact and increase efficiency. To achieve these goals, the company closely monitors its energy consumption at manufacturing
facilities to track usage and identify trends.
||With the SQL Server 2012 Fast Track Data Warehouse, we can analyze 10 times more data and make more efficient and innovative decisions about energy management using trend statistics and histograms.
| Team Member
Electronics Infrastructure Technology Center
In 2009, Samsung Electronics built a 6-terabyte monitoring system at its semiconductor fabrication plant in Hwasung, South Korea. The solution collected general information about the site’s consumption of electricity, liquefied natural gas, and water. However,
soon after the system was implemented, Samsung Electronics realized that it needed more-detailed information about energy consumption and more flexibility in how employees could analyze data.
For example, fabrication sites include thermohydrostat units, air conditioners, electric heaters, and IT hardware such as servers and personal computers. To create high-efficiency policies, employees needed to measure the amount of energy used by each type
of device and analyze energy consumption at individual buildings.
To achieve these goals, Samsung Electronics decided to implement a larger-scale monitoring system at its site in Hwasung. The solution needed to be fast and highly scalable because employees wanted to collect, store, and analyze significantly more data.
In addition, the solution needed to be highly reliable and affordable.
In 2011, Samsung Electronics began to evaluate data warehouses to support its next-generation monitoring system. Ultimately, the company decided to build its solution with the Microsoft SQL Server 2012 Fast Track Data Warehouse. Samsung Electronics already
uses Microsoft SQL Server software to support existing databases. Based on research and experience with the Microsoft platform, Samsung Electronics knew that the SQL Server 2012 Fast Track Data Warehouse would deliver both high performance and low total cost
Company engineers worked with Microsoft Services consultants to evaluate server, software, and storage options and identify the configuration that could deliver the best combination of performance, scalability, and reliability. Eventually, the team chose
a design based on an HP ProLiant DL980 G7 server computer and the EMC Symmetrix VMAX storage platform.
A team of engineers from Microsoft Services, EMC, HP, and Samsung Electronics implemented the solution. Employees began to use it in the first half of 2012.
With its new solution, Samsung Electronics improves insight into energy consumption, expands storage capacity by 74 terabytes, increases performance by 10 times with 75 percent less hardware, improves control, boosts innovation, and facilitates efficiency.
Collects 10 Times More Data
Samsung Electronics can now collect and store more detailed information about the energy consumption of individual pieces of equipment in its buildings at the Hwasung plant. “With the SQL Server 2012 Fast Track Data Warehouse, we can analyze 10 times more
data and make more efficient and innovative decisions about energy management using trend statistics and histograms," says a member of the Infrastructure Technology Center team at Samsung Electronics.
Increases Performance by 10 Times with 75 Percent Less Hardware
The company has dramatically increased its capacity to store energy-related information, while reducing its hardware and expenses. “Our previous solution could only contain up to 6 terabytes of data,” says the Infrastructure Technology Center team member.
“By choosing the SQL Server 2012 Fast Track Data Warehouse, we could implement a highly reliable and affordable architecture that scales up to 80 terabytes. At the same time, we get maximum performance with 75 percent less hardware, and we have been able to
decrease the number of database instances and save money.”
Despite the smaller solution footprint, Samsung has boosted I/O so that speeds are 10 times faster. Commenting on the increased performance, the team member says, “We were able to tune the SQL Server 2012 Fast Track Data warehouse so that it processes 6
gigabytes per second on a warehouse that includes up to 45 terabytes of data. This level of performance is 10 times faster than our previous system, despite the larger amounts of data.”
Improves Operational Control and Boosts Efficiency
The deeper insight into energy consumption makes it possible for Samsung Electronics to increase control over manufacturing and boost efficiency. “In the past, we were able to monitor, at a high level, the amount of energy used at the Hwasung Campus,” says
the Infrastructure Technology Center team member. “However, with the SQL Server 2012 Fast Track Data Warehouse, we can track energy usage at a device level. Not only does this help us to identify areas for improving energy efficiency, but we also now have
insight about how devices are operating, including when it is time to replace or repair energy-related sensors.”
Facilitates Innovation and Energy Savings
Samsung Electronics expects to take advantage of its new data-collection and data-analysis capabilities to create innovative energy-saving policies that extend the life of existing investments.
“It is not easy to restrict power consumption in facilities that produce semiconductors and other technologically sophisticated products, especially compared with more general-purpose office buildings,” explains the Infrastructure Technology Center team
member. “As a result, it is more common to improve operational efficiency with new types of equipment, rather than take the simple approach of using less energy. Our new solution gives us the data we need to create innovative energy-savings plans and identify
where we can save energy using existing manufacturing equipment wherever possible.”
This case study is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.