SQL System Requirements

Supported Operating Systems:

  • Windows 7
  • Windows Server 2003
  • Windows Server 2008
  • Windows Server 2008 R2
  • Windows Vista
  • Windows Server 2003
  • Windows Server 2008
  • Windows Server 2008 R2
  • Windows 7
  • Windows Vista
  • Windows XP

Processor:

  • Pentium III – compatible processor with a minimum speed of 1 GHz or a faster processor

RAM:

  • Minimum 512 MB for SQL Server Express with Tools, and SQL Server Express with Advanced Services and 4 GB for Reporting Services that installs with SQL Server Express with Advanced Services

Hard Disk Space:

  • 2.2 GB of Disk Space

Limitations:

  • SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage

Note: For more information about Hardware and Software Requirements for Installing SQL Server 2008 R2, Please visit SQL Server 2008 R2 Requirement.

Installing SQL Server

Ensure that you have Administrative privileges on your computer

Download Microsoft® SQL Server® 2008 R2 SP1 – Express Edition with tools form here

64 bit version – SQLEXPRWT_x64_ENU.exe- 980.9 MB

32 Bit Version – SQLEXPRWT_x86_ENU.exe – 308.4 MB

After downloading reboot your computer and close all applications.

Installation

Run the downloaded SQLEXPRWT file

Select New Installation:

SQL System requirements 20

Accept the license terms and click Next:

SQL System requirements 21

Select All and Click Next:

SQL System requirements 22

Select Default Instance and select Next:

SQL System requirements 23

Select Next:

SQL System requirements 24

Select Next:

SQL System requirements 25

Select Next:

SQL System requirements 26

SQL Server installs…

Click Close:

SQL System requirements 27

Open SQL Server Management Studio

Accept the defaults and click Connect:

SQL System requirements 28

Recommended Hardware

32 Bit and 64 Bit Operating Systems

For best performance choose a 64 bit operating system.

  • Open Automation Software version 4.0 or greater will take advantage of 64 bit operating systems to use up to 1 terabyte of memory.
  • For any system that has more than 100,000 Tags a 64 bit operating system is required.
  • All versions of Open Automation Software will run on 32 bit operating systems up to 100,000 tags.

Number of Processors

Open Automation Software will take advantage of multiple processors and will evenly distribute processing of the service functions across all processors that are available.

  • It is recommended to allocate 2 processors for every 100,000 tags running in the service.
  • Allocate 1 additional processer for each set of 25,000 tags to be logged at a 1 second frequency.
  • Allocate 1 additional processor for every 50,000 tags to be trended at a 1 second rate for 1 hour of time frame.
  • Allocate an additional processer for each 25 clients or more connected to the service.

RAM

  • Allocate 4 Gigs of RAM for every 100,000 tags running in the service.
  • Allocate 4 Gigs of RAM for each set of 25,000 tags to be logged at a 1 second frequency.
  • Allocate 4 Gigs of RAM for every 50,000 tags to be trended at a 1 second rate for 1 hour of time frame.
  • Allocate 4 Gigs of RAM for each 25 Smart Clients connected to the service.

Minimum Requirements

Open Automation Software minimum hardware requirements would be a single Pentium II with 256 Megs of RAM and 100 Megabyte hard disk. This would be limited to a system that had 10,000 tags or less on the service, trending 1,000 tags, and logging 10,000 tags at a 1 second frequency. The number of clients would be limited to 10 clients for this minimum hardware configuration.

Client Applications

For client applications Smart Clients will run on all Windows operating systems.

For thin client applications hardware devices that have browsers that support JSON jQuery will work. This includes the following:

  • All versions of Windows OS
  • All versions of the iPhone
  • All versions of the Android
  • Windows Smartphone 7 and 8
  • All versions of iPads

Operating Systems

Open Automation Software has three (3) different Framework installations for compatibility for older systems. For server systems and client applications running on Windows the following frameworks are supported:

.NET Framework 3.5, 4.0, and 4.5

For use with Visual Studio 2008, 2010, 2012, 2013, and 2015

The most up to date version is for .NET Framework 3.5, 4.0, and 4.5 and will run on the following Windows Operating Systems for both 32 bit and 64 bit operating systems on all service packs.

  • Windows 10
  • Windows 8
  • Windows 7
  • Windows Vista
  • Windows XP  (with .NET Framework 3.5 SP1)
  • Server 2016
  • Server 2012
  • Server 2008 (with .NET Framework 3.5 SP1)
  • Server 2003 (with .NET Framework 3.5 SP1)

.NET Framework 2.0 (Legacy versions)

For use with Visual Studio 2005

  • Version 4.0 of OPCSystems.NET is for .NET Framework 2.0 and will run on all Windows Operating Systems for both 32 bit and 64 bit operating systems on all service packs and additional for Windows 2000 Professional (with .NET Framework 2.0)
  • Windows 2000 Professional (with .NET Framework 2.0)

.NET Framework 1.1 (Legacy versions)

For use with Visual Studio 2003

  • Version 1.1 of OPCSystems.NET is for .NET Framework 1.1 and will run on the following Windows Operating Systems for 32 bit operating systems.
  • Windows 2000 Professional (with .NET Framework 2.0)

Client Applications

For client applications Smart Clients will run on all Windows operating systems. All components are compiled for Any CPU and are 100% managed.

For thin client applications all browsers that support JSON jQuery. This includes the following but not limited to:

  • Chrome
  • Internet Explorer 8.0 or greater
  • Safari
  • Firefox
  • Mozilla

OAS System Requirements

Open Automation Software utilizes 4 Windows Services that are multi-threaded for the core communications with 100% managed components that are compiled for Any CPU for execution on both 32 bit and 64 bit operating systems.
3 of the services target the .NET Framework 4.0, and 1 targets the .NET Framework 4.5 which is only required for REST, IoT Connectors, and MongoDB database interface. All other interfaces only require the .NET Framework 4.0.

The following service attributes affect what software and hardware requirements are to be selected:

Number of Tags

The number of tags running in the service will determine the minimum RAM and recommend number of processors required to run the OAS Windows Services.  For any system that is above 100,000 tags a 64 bit operating system is required. For each 100,000 tags implemented 2 processors and 4 Gigs of RAM is recommended.

Data Logging

The data logging frequency and the number of data logging groups to be run on the service will determine how many processors are required and how much RAM will be needed to execute the data logging.

Allocate a processer and 4 Gigs of RAM for every 25,000 tags to be logged at a 1 second frequency. If the logging rate is much faster allocate more processers and more RAM.

Database Engine Requirements

If the database engine is to run on the same PC as Open Automation Software each database engine has its own system requirements that must be considered in addition to the Open Automation Software requirements. Most likely for data logging, historical replay to trends, and reports the database engine will be the most resource intensive execution above Open Automation Software.

For each 100,000 tags to be logged at a frequency of 1 second you should allocate 16 Gigs of RAM for the performance of the database engine.

Trending

The number of different time frames for real-time trending combined with the number of tags enabled for trending will impact the resources required to cache and perform trending.

Allocate a processer and 4 Gigs of RAM for every 50,000 tags to be trended at a 1 second frequency over 1 hour time frame. If there are multiple timeframe and sample rate combinations allocate more processers and more RAM.

Use Configure-Options-Trending to set the Maximum Allowed Time Frame to limit the realtime trend cache.

Client applications running on remote PCs will perform better for resource intensive trending if the graphics card is better.

Number of Clients for HMI, Trending, and Alarming

Allocate 1 processor and 4 Gigs of RAM for each set of 25 clients connected to the service. For example if 100 client systems will be communicating to the service an additional 4 processors with an additional 16 Gigs of RAM will be required.

Web Applications

Web applications are more server intensive that Smart Client applications. For Web applications that display a lot of data for more than 25 clients at a time load balancing across multiple servers may be required for web applications. For smaller web application allocate a server for each 100 clients.  For larger web applications allocate a server for each 25 concurrent clients.

Windows Presentation Foundation HMI

For client applications that are using Windows Presentation Foundation (WPF) components the best performance is on Windows 10, 8, 7, and Vista. Windows Server 2008, Server 2003, and Windows XP can also run WPF client applications, but there may be a higher CPU load for more graphic intensive animations.  Windows 2000 Professional cannot run WPF client applications.

More: