Rockwell Automation Energy Management Accelerator Toolkit Quick Start - Manual (Page 53)

Rockwell Automation Publication IASIMP-QS016C-EN-P - October 2014 53
System Configuration and Wiring Chapter 2
Server Requirements
We recommend, but do not require, that you install FactoryTalk EnergyMetrix software on a dedicated server with a local
installation of Microsoft SQL Server.
Server Software Requirements for Installing FactoryTalk EnergyMetrix Software
• Windows 2003 Server or Windows 2008 Server, Application Server role. For 64-bit operating systems, RSLinx
Classic software version 2.57 CPR9 SR3 or later must be installed. Windows 2000 Server is not supported.
• Microsoft SQL Server 2005 or 2008, installed with mixed-mode authentication (Windows and SQL). TCP/IP
access must be enabled. A system administrator SQL login must be used for the FactoryTalk EnergyMetrix
installation.
• You must have machine administrator privileges to install FactoryTalk EnergyMetrix software.
Hardware Requirements
These are the hardware requirements that you need to use FactoryTalk EnergyMetrix software.
Definitions
The following rules of thumb are offered as a starting point for determining server sizing for FactoryTalk EnergyMetrix.
Other factors will affect the required size of a server. A higher number of tags being logged, a faster log rate, a larger number
of users, and a larger number of reports being run will require a more powerful server than the guidelines specify. These are
the server guidelines:
• A low-end server has up to 8 meters and logs up to 40 meter tags at a minimum 15 minute log rate.
• A mid-range server has up to 64 meters and logs up to 320 meter tags at a minimum 15 minute log rate.
• A high-end server has more than 64 meters and logs more than 500 meter tags at a minimum 15 minute log rate.
Database Size Guidelines
FactoryTalk EnergyMetrix writes 16 bytes of data to the database for each meter tag logged. Over time, the database can
grow to become quite large. Some examples include the following:
• A low-end server, logging 40 meter tags at 15 minute intervals, will grow the database at a rate of 2.56 KB per hour or
22 MB per year.
• A mid-level server, logging 320 meter tags at 15 minute intervals, will grow the database at a rate of 20.5 KB per hour,
or 180 MB per year.
• A high-end server, logging 1000 meter tags at 15 minute intervals, will grow the database at a rate of 240 KB per
hour, or 2.1 GB per year.
Consider these guidelines when determining hard disk requirements for a server as well as database maintenance schedules.