<% '============= Create and Open Database Connection ============= 'OPEN THE DATABASE If blnConnectToDB Then dim blnDBconnectionDown blnDBconnectionDown = false Err.Clear on error resume next set dbConn = Server.CreateObject("ADODB.Connection") 'Open the Connnection 'dbConn.Open Application("dbConn_ConnectionString") dbConn.Open "DSN=PostgreSQL30", "eere_news", "33reNews" ''New Error trapping. KC added 2/23/2012 If Err.Number <> 0 Then ''Response.Write (Err.Description& "

") dbConn.Close Set dbConn = nothing blnDBconnectionDown = true End If On Error GoTo 0 ''error trapping not working here KC removed 2/23/2012 ''tmpDBErrorNativeError = 0 '' For Each dbErr In dbConn.Errors '' strErrMsg = strErrMsg & _ '' "Source: " & dbErr.Source & vbCrLF & _ '' "Description: " & dbErr.Description & vbCrLF & _ '' "SQL State: " & dbErr.SQLState & vbCrLF & _ '' "NativeError: " & dbErr.NativeError & vbCrLF & _ '' "Number: " & dbErr.Number & vbCrLF & vbCrLF '' tmpDBErrorNativeError = dbErr.NativeError '' Next '' If (dbConn.Errors.Count > 0) AND (tmpDBErrorNativeError <> 5703) Then '' dbConn.Close '' Set dbConn = nothing '' blnDBconnectionDown = true '' Response.write(strErrMsg) '' Response.end '' End If dim arrErrors() Redim arrErrors(2,0) End If '============================================================== Public Function GetRS2(myCommand) On Error GoTo 0 'objConn: local connection object 'objRS: local recordset object 'objComm: command object passed in to the function Dim objConn, objRS, blnErrorLogged, objComm 'Create the command object Set objComm = Server.CreateObject("ADODB.Command") Set objComm = myCommand 'Create the connection object Set objConn = Server.CreateObject("ADODB.Connection") 'Open the connection object objConn.Open "DSN=PostgreSQL30", "eere_news", "33reNews" 'Set the active connection objComm.ActiveConnection = objConn 'Create the recordset object Set objRS = Server.CreateObject("ADODB.Recordset") 'Set the cursor location for disconnected recordsets 'objRS.CursorLocation = adUseClient 'Turn on error handling for just a second ' On Error Resume Next 'Open the recordset 'objRS.Open SQL, objConn, adOpenStatic, adLockOptimistic Set objRS = objComm.Execute 'Response.Write "State = " & objRS.State & "
" 'objRS.MoveLast 'objRS.MoveFirst 'Response.Write "Count = " & objRS.RecordCount & "
" 'Response.End 'Check for an error ' If Err.Number <> 0 Then ' Response.Write "Database Error Occured

" ' Response.Write "Error #" & Err.Number & "
" ' Response.Write Err.Description & "

" ' Response.Write "SQL:
" ' Response.Write SQL ' Response.End ' End If 'Turn off error handling ' On Error GoTo 0 'Disconnect the recordset 'Set objComm.ActiveConnection = Nothing 'Close the connection 'objConn.Close 'Set the connection to Nothing 'Set objConn = Nothing 'Set the Command to Nothing 'Set objComm = Nothing 'Return the recordset Set GetRS2 = objRS On Error Resume Next End Function '=============================================================== Function GetRS(sSQL) 'Declarations dim rs 'Create Recordset Object set rs = Server.CreateObject("ADODB.Recordset") If blnConnectToDB Then 'Open Recordset based on SQL rs.Open sSQL, dbConn, 1, 3, 1 End If 'Return Recordset set GetRs = rs End Function '=============================================================== Function ExecSQL(sSQL) 'Open the Command Object dim lRecordsAffected dbConn.Execute sSQL, lRecordsAffected 'Return the Records Affected ExecSQL = lRecordsAffected End Function '======================================================================== Function sendEmail(strFrom,strTo,strSubject,strMessage) Dim sch ' Schema sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(sch & "sendusing") = 2 .Item(sch & "smtpserver") = "mxrelay.doe.gov" .update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = strFrom .To = strTo .Subject = strSubject .TextBody = strMessage .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing End Function Function removeBadChars(tmpString) tmpString = Replace(tmpString , "<", "") tmpString = Replace(tmpString , ">", "") tmpString = Replace(tmpString , "'", "") tmpString = Replace(tmpString , """", "") tmpString = Replace(tmpString , ";", "") tmpString = Replace(tmpString , "(", "") tmpString = Replace(tmpString , ")", "") removeBadChars = tmpString End Function %> <% 'If there is a mobile version of this site, check the user_agent, and forward to 'the mobile version of the site (unless cookie or querystring var is set) if "true" = "true" then tmpSeeFullPage = Mid(Request.Querystring("m"),1,1) if ((isMobile) and (tmpSeeFullPage <> "1")) then tmpMobileURL = Request.servervariables("HTTP_URL") tmpMobileFileName = mid(tmpMobileURL, InStrRev(tmpMobileURL, "/")+1) tmpMobileURL = Left(tmpMobileURL, InStrRev(tmpMobileURL, "/")) tmpMobileURL = tmpMobileURL & "m/" & tmpMobileFileName Response.Clear Response.Redirect(tmpMobileURL) end if end if %>

<% ''This code is strictly when a user clicks on a left nav and needs to be forwarded to another site/program/office if ("" <> "") then Response.Clear Response.Redirect ("") end if %>

FEMP Technology Brief: Wireless Sensor Networks for Data Centers

The geometrical arrangement of your server rack in a data center to optimize heat removal can dramatically lower cooling and fan power needs.

Server rack configuration in the Data Center at the National Renewable Energy Laboratory (NREL) Research Support Facility. Photo credit: NREL PIX 18784

Technology Description
The evaluated technology consisted of a network of wireless sensors - including branch circuit power monitors, temperature sensors, humidity sensors, and pressure sensors, along with an integrated software product to help analyze the collected data. The wireless sensor network provided real-time data center conditions needed to optimize energy use and achieve substantial savings - all with minimal impact on day-to-day operations.

The waste heat emitted from institutional data center servers can be removed more efficiently when design considerations are evaluated and innovative monitoring sensor networks are installed for verification and measurement.

Hot aisle containment system in the Data Center at the NREL Research Support Facility. Photo credit: NREL PIX 18780

Technology Evaluation Program

GSA Green Proving Ground Savings/Benefits

  • 3.4-year simple payback
  • Reduced cooling load by 48%
  • Lowered PUE from 1.83 (good) to 1.51 (great)
  • 542 tons of carbon dioxide savings

Potential Applications

  • Nationwide application in any data center in all climates
  • $61 million in annual savings and an annual decrease of 532,000 metric tons of carbon dioxide if applied across the entire GSA portfolio.

"By most standards, this data center is an efficient facility. The fact that a wireless sensor network helped it significantly reduce its energy profile speaks volumes for the technology."

– Ron Jones
Facility Manager, Office of the Chief Information Officer, USDA

Regulatory Compliance
Wireless sensors for data centers can aid in compliance with Executive Order 13514, which mandates implementation of best practices for energy-efficient management of servers and Federal data centers. Reducing data center energy consumption will help meet Federal agency energy use reduction requirements, identify efficiency opportunities, and collect the performance data needed to develop improvement plans for their data centers, as they are mandated to do under the Federal Data Center Consolidation Initiative.

A Telling Test of Technical Innovation

Data centers consume roughly 2% of all energy used in the United States, and their carbon footprint is projected to exceed that of the airline industry by 2020. Nearly 50% of data center energy typically goes to non-Information Technology (IT) loads, such as cooling, fans, humidification, and lighting. In the Federal sector, agencies currently lease space from the U.S. General Services Administration (GSA) to operate more than 1,400 data centers. Improving the energy performance of data centers supports progress toward meeting federally mandated greenhouse gas emission-reduction goals, while reducing operating costs and energy use, and allowing greater flexibility in future expansion by eliminating the need to provide additional power and cooling.

Wireless sensor technology provides a cost-effective and facilities-friendly way of helping data center operators visualize and implement system changes that reduce overall energy consumption.

Agency Technology Evaluation Program

To evaluate the real-world effectiveness of wireless sensor technology, GSA's Green Proving Ground (GPG) program worked with the Energy Department's Lawrence Berkeley National Laboratory (LBNL), industry-recognized experts in state-of-the-art data center analytics. LBNL selected the U.S. Department of Agriculture (USDA) National Information Technology Center facility in St. Louis as a demonstration project location because its baseline conditions were representative of a well-designed, well-managed data center operated by an engaged facility staff. Sensors using a wireless mesh network and data management software to capture and graphically display real-time conditions for energy optimization were installed.

The study showed that providing real-time, floor-to-ceiling information on humidity, air pressure, and temperature conditions is feasible. This data, when combined with power use, leak detection, and equipment status, could enable data center operators to significantly improve the energy efficiency of even well-managed data centers.

What Were the Benefits?

The Bottom Line – Efficiency measures implemented as a result of information provided by the wireless sensor network reduced the demonstration facility's cooling load by 48%, and reduced the total data center power usage by 17%. This represented an annual savings of 657 megawatt-hours (MWh) and an improvement in the data center's power usage effectiveness (PUE) from 1.83 to 1.51.

Simplified Assessment Tools Limit Power Interruption – The data center operator at the demonstration facility found that full deployment of the permanently installed wireless sensor network provides valuable real-time information needed for the on-going optimization of data center performance. However, permanent installation of the sensor network required multiple interruptions of facility power. Recognizing this as a potentially significant barrier for some tenants, LBNL has separately piloted a smaller, portable, less disruptive "assessment kit" at four federally operated data centers, and found that the snapshot of real-time information it provides holds many of the full network's benefits.

What Were the Savings?

Savings at the USDA facility were as follows:

  • Energy cost savings were calculated at nearly $30,000 per year, even though current local utility rates were among the lowest in GSA's portfolio
  • Simple payback was calculated at 3.4 years given an initial sensor network cost of $101,000. This equates to an attractive 29% return on investment (ROI)
  • Data center annual greenhouse gas emissions were reduced by 542 metric tons of carbon dioxide.

Potential Applications

The LBNL evaluation team concluded that broad deployment represents a best practice that could help agencies meet mandated targets cost effectively. This technology could be applied to all data centers across all agencies, regardless of climate or location. Potential annual savings could be $61 million and an annual decrease of 532,000 metric tons of carbon dioxide could be achieved, an amount equal to the annual greenhouse gas emissions of approximately 104,000 passenger vehicles.

Summary of advantages for wireless sensor networks

Reduce Operating Expenses Reduce Capital Expenses Increase Capacity Reduce Failures
Granular temperature measurements allow optimized operations without compromising server reliability. Self-configuring, wireless sensors reduce deployment cost – no wires for signals and power. Extract hidden capacity by truly understanding where cooling is required. Server inlet temperature measurement provides visibility of cooling system malfunctions.

Achieving Energy Savings in Your Data Center

LBNL predicts that many data center rooms could benefit from this technology. FEMP provides information specific to data center energy efficiency. Consider how much downtime your data center can tolerate before choosing between a full wireless sensor network or LBNL's "assessment kit."

FEMP's Project Funding section provides detailed information and identifies where assistance is available to implement energy projects.

This graph shows the substantial decrease in power usage, in particular in the cooling and fan power areas, when proper power use monitoring is applied and follow-up measures described in this article are implemented.

More Information

For information about the GSA Green Proving Ground program or for technical information relating to the wireless sensor network evaluation program, contact Kevin Powell at GSA. The GSA Green Proving Ground program website can be found at: http://www.gsa.gov/gpg. Click here to read the full technical report on the wireless sensor network evaluation.

Technology Deployment Working Group

In support of the Federal government's dedication to improving its energy efficiency, an interagency advisory committee was formed to accelerate deployment of innovative clean energy technologies in the federal sector. The Senior Executive Committee for Technology Deployment, a subcommittee of the Interagency Technology Deployment Working Group, brings together leaders of technology deployment programs from across the federal government to reduce energy use in agency facilities. The Technology Briefs are produced to share knowledge gained through the various technology evaluation programs. This Technology Brief on wireless sensor networks for data centers is a compilation of experiences from the GSA's Green Proving Ground evaluation program.