Welcome  |  Sign in
Skip Navigation Links
TechNet Magazine
Click to Rate and Give Feedback
Related Articles
Far too often, people who are not trained database administrators somehow end up responsible for a database. They lack the proper training and knowledge to maintain their database, and problems begin to develop. Here’s a primer for all those involuntary DBAs who need a crash course in database maintenance best practices.

By Paul S. Randal (August 2008)
Paul Randal answers your SQL Server questions, showing you how to perform consistency checks and other maintenance on very large databases, how to handle an accidental upgrade, and more.

By Paul S. Randal (August 2008)
Paul Randal answers your SQL Server questions, showing you how to create corruption in a test database, helping you avoid a shrink-grow-shrink-grow cycle, and explaining how you can determine how many databases you can mirror before performance starts to degrade.

By Paul S. Randal (June 2008)
The new version of SQL Server offers a host of new features and enhancements that promise to improve performance, increase security, and make life better for database administrators. Here’s an overview of the key changes and what you can expect from SQL Server 2008.

By Randy Dyess (April 2008)
More ...
Articles by this Author
Understanding your power consumption is now an essential part of managing an IT infrastructure. Learn about the strategies you can employ to implement power monitoring in your environment to better understand the power consumption of devices throughout your organization.

By Dave Ohara (August 2008)
When you're not using your PC, you shut it down. So why not do the same with your servers? Dave Ohara explores the strategy of powering down idle servers for significant reductions in power consumption.

By Dave Ohara (July 2008)
As the environment becomes a topic of increasing attention, many IT departments are looking for ways to reduce their energy consumption. In the first installment of our new online Sustainable Computing column, Dave Ohara discusses ways you can start to cut down on the amount of energy your organization consumes.

By Dave Ohara (May 2008)
Companies around the world are beginning to think of ways to save energy and reduce costs, yet there is little guidance on how you can take action. Get started with our introduction to planning, designing, and implementing a green datacenter in your organization.

By Dave Ohara (October 2007)
More ...
Popular Articles
Users have complained for years that clustering in Windows Server is too complicated. With the release of Windows Server 2008, clustering received a complete facelift. Explore some of the most significant advancements found in the new Failover Clustering, and see how this new implementation makes clusters much easier to set up and maintain.

By Chuck Timon (July 2008)
The latest release of IIS introduces a modular and extensible platform with improved support for common deployment and management scenarios, enabling significant performance improvements. Here’s a look at 10 key areas in IIS 7.0 that provide these improvements.

By Mike Volodarsky (September 2008)
While locking is essential to support concurrent read and write activities on a database, blocking can adversely affect system performance. Learn how to optimize your SQL Server database to minimize blocking, and see how you can monitor the system to better understand how locking impacts performance.

By Cherié Warren (April 2008)
SQL Server 2008 offers seven new built-in data types that let you work with more complex data and simplify the management of structured, semi-structured, and even unstructured data. Get an in-depth look at these new data types and find out how you can use them to improve data management in your infrastructure.

By Kelly Wilson (April 2008)
More ...
Read the Blog
Pav Cherny discusses the limitations of the built-in Directory Management Service in SharePoint and explains how you can replace this component with a custom solution that lets you synchronize SharePoint recipient information with other directory solutions. In particular, he ...
Read more!
"One of the common things that administrators must deal with on an ever-increasing basis is the regular changing of the password for shared and privileged accounts, such as the built-in administrator or root account, a firecall account, or perhaps even a process account." In the Read more!
Suppose one of the PCs you support is acting up—freezing, crashing, blue screening. Is some piece of hardware failing? Is some newly installed application causing trouble? Or could it be faulty memory? One way to find out for sure is with the free Microsoft Windows Memory Diagnostic ...
Read more!
Henrik Walther answers your questions about Microsoft Exchange. Here’s just a sample of the ones he tackles in the September issue of TechNet Magazine: ...
Read more!
Beyond traditional voice, messaging, and productivity functions, many businesses today want mobile professionals to have access to the same line of business systems they use in the office through mobile LOB applications, adding new considerations for those tasked with deploying and maintaining IT systems. In ...
Read more!
Back in the Winter 2005 issue of TechNet Magazine, when TechNet Magazine was still in its infancy, Jesper Johansson wrote a fantastic article called "Anatomy Of A Hack: How A Criminal Might Infiltrate Your Network". ...
Read more!
More ...
Sustainable Computing Learning from the Quincy Datacenter
Dave Ohara
At CeBIT 2008, which took place this past March in Germany, Steve Ballmer discussed how the Datacenter Group at Microsoft is making efforts to develop sustainable datacenters and share the best practices it learns in the process. A major example of these efforts is the Microsoft datacenter located in Quincy, WA—the facility is
powered entirely by hydroelectricity. And the facility is sizeable. If you walked around one complete building (there are currently two buildings, with more being built over time), including the space for IT, power and cooling equipment, the receiving area, and the office space, you would travel 1.3 miles.
I recently had a chance to take a tour of the Quincy datacenter, and now I get to share some of the methods used in building and operating a sustainable datacenter. (There is a video of the Quincy datacenter available at download.microsoft.com/download/8/7/d/87d2d871-471e-44a3-bfd0-c02d3248b8cb/Energy%20Efficiency%20in%20Datacenters-022808-Med.wmv.)
In the first installment of this column, I introduced the idea of "Putting IT on a Diet" (see technet.microsoft.com/magazine/cc462802). This concept, as well as other key elements of environmental sustainability, can be found in how Microsoft designs and operates its datacenters. Here is a look at eight strategies Microsoft employs to make the most out of every bit of energy the Quincy datacenter consumes.

1. Modular and Efficient
The lifespan of a datacenter can be 20 years. One key design goal is to minimize the resources required to build and operate the facility over that entire lifespan. Over a 20-year period, equipment will undoubtedly change. To simplify improvements that will lead to better efficiency over time, Microsoft designed the Quincy building in a modular fashion, allowing components to be upgraded without taking down the entire facility. With only about 50 people required to operate the facility, workflow efficiency is important to ensure the best use of those resources and allow work to happen quickly.

2. Phased Building
When you look at the Quincy datacenter building, it looks like one building. However, it is actually two separate buildings. The most efficient datacenter is a full datacenter. Microsoft, therefore, filled the first building to capacity before putting a single piece of equipment into the second building. This approach is being repeated throughout the site, as there is room for three more datacenter buildings, and one of these buildings can be built in as short a time as 10 months. By building the datacenter infrastructure when it's needed, Microsoft can improve the power and cooling efficiency of the datacenter and eliminate the waste that results from over provisioning capacity.

3. Find the Sweet Spot
One technique a Microsoft engineer explained to me is the concept of designing around the sweet spot of performance for each piece of equipment. Every piece of equipment has a range of optimal performance, and holistically achieving the right combination improves the overall efficiency.
Microsoft evaluated multiple permutations of equipment capacities and efficiencies to find the right combination for their power and cooling needs. Unfortunately, the exact combination is unique for every environment and even Microsoft continuously evaluates and optimizes the equipment combinations as new technologies are developed. So there is no magic recommendation here, other than that you'll need to test a variety of configurations to find the best configuration for your environment. And keep testing over time to find improvements.

4. Organize for Collaboration
You may be thinking, "I'm a system administrator and it sounds like the Microsoft datacenter efficiencies were done by the facilities staff." Given the dynamic IT environment and how quickly technology changes, a tight partnership exists between the IT pro and the facilities staff. In fact, facilities program management and the technical program manager report to the same datacenter manager who in turn oversees the whole datacenter operation. The accountability for sustainable and efficient operations falls under one organization.

5. Monitor and Report
The Quincy datacenter incorporates energy monitoring of all systems, providing real-time data. The data is recorded and archived for historical trending and analysis. The staff focuses on electricity as the most important resource, not space. Power stranded in one area, that therefore can't be used is one type of the waste Microsoft looks for. The reports are shared with hundreds of Microsoft employees to help them understand the efficiencies of the operations and how much energy is consumed to provide particular services.
Common questions asked by people on staff include: What is the overall efficiency of the datacenter (measured by PUE)? What are the actual versus calculated power usages? How much capacity does my group have? What are the electricity costs for my business unit?

6. Efficient Commissioning
Efficiency starts the moment servers are delivered pre-populated in racks. This eliminates the bulky packaging typical used for server shipments. The only packaging required is the wooden shipping crate, which is recyclable. Just a matter of hours after a server shipment arrives, equipment is ready to be deployed and operating. The staff estimates that they can commission the space of one of these buildings in as little as three months.

7. Prepare for High Loads
One of the downsides of running at higher efficiencies is the equipment is run at high load conditions. Since the current industry norm is underutilization, this can cause problems.
As Microsoft was filling up the server rooms, some pieces of equipment began to display problems as they neared capacity. When contacted, vendors were actually surprised to hear that Microsoft was consistently running this equipment at high load conditions, as most of their customers do not come close to capacity ratings.
So Microsoft operations recommends that if you are going to run at high loads, make a high load test part of the acceptance criteria. Keep this in mind for projects such as server consolidation, as a higher power concentration in a rack can create high loads.

8. Reduce Water Use
The Quincy datacenter is located in the middle of farmland near the Columbia River. Besides offering a good source of electricity, this provides an ample supply of water. However, water for agriculture does not provide a lot of waste water since the water evaporates or soaks into the ground.
Datacenters use a lot of water for the cooling system. After use, the water is sent to the local waste water treatment facility. Unfortunately, the waste water system in Quincy was not ready to handle the quantity of water resulting from a datacenter. In this case, Microsoft built a water treatment facility to reduce the waste water, drastically lowering the datacenters water use. For another facility (located in San Antonio, TX), Microsoft developed a plan to use gray water from other industries, making their water use a non-issue.

Wrapping Up
When you put IT on an energy diet and start designing more sustainable solutions, it's a good idea to see what you can learn from others. Seeing what issues other organizations have encountered and how they have addressed these issues will give you ideas on what to look for and what you can do to improve your operations.
One of the goals of the Microsoft Datacenter Group is to help the overall industry find ways to operate more efficiently. To help spread more efficient practices, the group participates in industry organizations such as The Green Grid (www.thegreengrid.org), Climate Savers (www.climatesaverscomputing.org), ASHRAE (www.ashrae.org), AFCOM (www.afcom.com), and The Uptime Institute (uptimeinstitute.org).
I'd like to thank the datacenter staff in Redmond, WA and Quincy for providing me with the opportunity to see how Microsoft runs a sustainable, energy-efficient datacenter.

Dave Ohara has 26 years of experience in technology. He is now working with multiple companies implementing green initiatives.
Page view tracker