Click to Rate and Give Feedback
Tips
Do you know what tools you'll need to use to prepare and deploy Windows Vista to systems throughout your environment? Here's an overview of the tools you'll need, and the ones you can forget about. ...

Read more!

If you use your laptop in more than one location, Windows 7 will let you set a different default printer for each network that you access. Find out how to do this. ...

Read more!

Files can’t be moved or deleted when they’re in use. Find out how you can move and delete those tricky files that are always in use. ...

Read more!

Windows Server 2008 simplifies the Disk Management user interface by using one set of dialog boxes and wizards for both partitions and volumes. ...

Read more!

Did you know you can use Windows 7 beta 1 to manage your Windows Server 2008 servers? Here's the download you'll need and an overview of the tools it includes. ...

Read more!

Related Articles

Logging and recovery are critical parts of SQL Server, but they are often poorly understood. Paul Randal gives an overview of how the logging and recovery features work in SQL Server and explains the transaction log and recovery models to help you maintain a better database.

Paul S. Randal

TechNet Magazine February 2009

...

Read more!

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.

Paul S. Randal

TechNet Magazine August 2008

...

Read more!

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.

Paul S. Randal

TechNet Magazine August 2008

...

Read more!

SQL Server 2008 offers more powerful relational data warehousing capabilities. Take a close look at key performancerelated data warehousing features and find out how you can use all this new technology to optimize query performance.

S. Agarwal, T. Grabs, and J. Hammer

TechNet Magazine April 2008

...

Read more!

In this installment, Paul Randal answers questions about backing up and restoring, looks at the differences between log shipping and database mirroring, and explains why the Repair function should only be used as a last resort.

Paul S. Randal

TechNet Magazine October 2008

...

Read more!

Also 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.

Dave Ohara

TechNet Magazine August 2008

...

Read more!

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.

Dave Ohara

TechNet Magazine Earth Day 2009 2009

...

Read more!

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.

Dave Ohara

TechNet Magazine May 2008

...

Read more!

A Hyper-Green virtualization system is designed to fully optimize your reduction in enegy consumption. Here are seven steps you must follow to build a Hyper-Green system.

Adam Bogobowicz and Dave Ohara

TechNet Magazine Earth Day 2009 2009

...

Read more!

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.

Dave Ohara

TechNet Magazine October 2007

...

Read more!

Popular Articles

Backup is something many people ignore until it’s too late. But there’s no excuse for this, especially now that the new Windows Vista Backup and Restore Center offers a variety of features that make it easy to protect your data against most forms of data loss. Find out how you can plan a complete recovery strategy with Windows Vista.

Christine Fok

TechNet Magazine September 2007

...

Read more!

Take a close look at SharePoint Security Accounts to see how a weak configuration can give an attacker full control over all site collections and sites.

Pav Cherny

TechNet Magazine January 2009

...

Read more!

SQL Server 2008 includes a new “eventing” mechanism called SQL Server Extended Events that enables some sophisticated troubleshooting. Get an overview of Extended Events and find out how you can use this new functionality for monitoring and troubleshooting.

Paul S. Randal

TechNet Magazine January 2009

...

Read more!

Discover how to use the Excel.Application automation model for a more powerful way to process data from your servers and take advantage of the analysis and charting tools built into Excel.

The Microsoft Scripting Guys

TechNet Magazine January 2009

...

Read more!

The upcoming release of Microsoft Identity Lifecycle Manager “2” offers many new features and enhancements. Explore the new portal experience and find out how you can cut costs with self-service tools, increase security compliance with business process modeling, and reduce development time with simplified development tools.

Aung Oo

TechNet Magazine January 2009

...

Read more!

Our Blog

NAP monitors the health of specified computers when they attempt to connect to a network and includes a number of mechanisms to enforce health requirements. In this article, Geek of All Trades Greg Shields gives readers an overview of these enforcement mechanisms and, as an example, takes a closer look at setting ...

Read more!

Use Windows PowerShell to Manage Virtual Machines Here are a few examples of how you can use Windows PowerShell scripts to manage virtual machines running on a Server Core installation. Note that these scripts are presented as samples and may need to be customized to work in your environment.

Create a New ...

Read more!

Disabling an Unused Part of Group Policy Objects One way to disable a policy is to disable an unused part of the GPO. By disabling part of a policy that isn’t used, the application of GPOs and security will be faster.

Administer Windows Server 2008 Server Core from the Command Prompt ...

Read more!

In the August 2008 issue of TechNet Magazine, Paul Randal wrote an article Top Tips for Effective Database Maintenance.  It was geared toward "involuntary  DBAs" (IT pros who inadvertently wind up responsible for a SQL Server instance).  The article had a great response from our readers so Paul has written another ...

Read more!

Microsoft Forefront is designed to deliver an integrated security solution that makes it much easier to deploy and manage security across an organization’s IT infrastructure. In this, our annual security issue, we feature two articles that describe how Forefront Security protects instant messaging and e-mail.

Protect ...

Read more!

Column Title Here
Learning from the Quincy Datacenter
Sustainable Computing
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. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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?

  1. 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.

  1. 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.

  1. 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.
Page view tracker