Wonderware Interactive Webinar Series

Helping you see more clearly

System Platform 4.0/Historian 10

Paul Edwards
Dial in 08006948053
Code 4381606605
What‟s New

► Application Server 3.1 SP2

► Historian 10.0

► Information Server 4.0 (Due mid April)

► Toolkits

► Related products

▪ InTouch 10.1 SP2

▪ Historian Client 10 (Due end March)
InTouch 10.1 SP2

Service Pack 2 for InTouch 10.1

• Support for Windows 2008 Server
SP2 (not R2) 32 & 64 bit
• Support for Windows Vista SP2
Business, Enterprise, or Ultimate 32 &
64 bit
• Existing O/S still supported (see
compatibility list in WDN)
• SQL Server 2008 SP1 32 bit only
• Windows 7 supported at a later date
(end 2010).
Application Server 3.1 SP2

Service Pack 2 for Application Server 3.1

• Support for Windows 2008 Server
SP2 (not R2) 32 & 64 bit
• Support for Windows Vista SP2
Business, Enterprise, or Ultimate 32 &
64 bit
• Existing O/S still supported (see
compatibility list in WDN)
• SQL Server 2008 SP1 32 bit only
• Windows 7 supported at a later date
(end 2010).
•Alarm language switching
Application Server 3.1 SP2
Historian 10

What is new
• Support for Windows 2008 Server SP2 (not R2) 32 & 64 bit
• Support for Windows Vista SP2 Business, Enterprise, or Ultimate 32 & 64 bit
• Existing O/S still supported (see compatibility list in WDN)
• SQL Server 2008 SP1 32 bit only
• Windows 7 supported at a later date (end 2010).

•Architecture option - Tiered Historians

•Archestra Namespace Integration
•New Retrieval Modes
•32 Tag Limit Unlicensed
 Historian Technology Support

Technology 9.0 10.0

Operating Windows 2000 Windows XP SP3 (32-bit only)
System Windows XP Windows Server 2003 SP2 (32)
Windows Server 2003 Windows Server 2008 SP2 (32/64)
Windows Vista SP2 (32/64)
SQL Server 2000 2005 SP3: 3.3 mSec
2005 2008 SP1 (32-bit only): 1 mSec

No cluster support planned

 Historian Compatibility
Product Release
Application Server 3.0 SP2, 3.1 SP2
InTouch 10.0 SP2, 10.1 SP2
Historian Client (ActiveFactory) 9.2*, 10.0 (expected end March)
Information Server 3.1, 4.0 (expected April)

• “In place” upgrades from Historian 9.0 (all patch levels)

• Upgrades from earlier versions require upgrade to 9.0
• V10 license will run V9 product

* Summary tags are not supported in 9.2. An unsupported patch is

posted on WDN
Historian 10 Licensing

Available in 3 Versions
• Express Edition (was Personal) – Desktop O/S with
no „late data‟. Available in 100 & 500 Tag. No
Information Server Included.
• Standard Edition – 500, 5K, 25K, 70K, 100K, 150K.
With Information Server 4.0.
• Enterprise Edition – 5K, 25K, 70K, 100K, 150K.
Required for Tier 2 Functionality. Also > 2 CPUs. With
Information Server 4.0.
• All System Platform Historian inc and above 5K will
be Enterprise.
•Existing V9 pricing still applies.
•No Clustering available.
Historian 10

What is new
• Support for Windows 2008 Server SP2 (not R2) 32 & 64 bit
• Support for Windows Vista SP2 Business, Enterprise, or Ultimate 32 & 64 bit
• Existing O/S still supported (see compatibility list in WDN)
• SQL Server 2008 SP1 32 bit only
• Windows 7 supported at a later date (end 2010).

•Architecture option - Tiered Historians

•Archestra Namespace Integration
•New Retrieval Modes
•32 Tag Limit Unlicensed
Tiered Historians
Tier-2
Centralized reporting
& system of record

Tier-1
Local troubleshooting &
buffering
Application
I/O Server
InTouch
Tiered Historians: All Data (“Simple”)
Tier 2 Example:
1-second data
Replicate all
data for selected or
all tags

Tier 1 Example: 1-second data

Tiered Historians: Summary Data
Tier 2 Example:
5-minute, hourly,
daily data

Tier 1 Example: 1-second data

Summary Tag Aggregates
► Analog
▪ Time-weighted average, standard deviation & variance
▪ Integral
▪ First/last value in period with timestamp
▪ Min/max value in period with timestamp
▪ Seconds of “good” values
► State (for each state)
▪ Number of occurrences (partial & contained)
▪ Shortest/longest/average occurrence (partial & contained)
▪ Total/percent occurrence (partial & contained)

Each summary tag has all aggregates

Local Summary Replication

Alternative to existing Summary System

Multiple Tier-2 Historians

New Orleans
Tier-2 to Tier 2 Historians

Tier 2: Site 1 Tier 2: Site 2

Robust Tiered Historians
► Store-forward between tiers
► Spread load across period when possible
► Propagate From Tier 1
▪ Store-forward events
▪ Inserts/Updates
▪ “Late” Data
► No tag count increase (150,000)
Preconfigured

Added

“Tier 1” System
“Tier 2” System
“Pushed” from Tier 1
Summary Tags In
ActiveFactory 9.2
Historian 10

What is new
• Support for Windows 2008 Server SP2 (not R2) 32 & 64 bit
• Support for Windows Vista SP2 Business, Enterprise, or Ultimate 32 & 64 bit
• Existing O/S still supported (see compatibility list in WDN)
• SQL Server 2008 SP1 32 bit only
• Windows 7 supported at a later date (end 2010).

•Architecture option - Tiered Historians

•Archestra Namespace Integration
•New Retrieval Modes
Names In Application Server
Hierarchical Name
Object Tagname

Contained Name
Attribute Reference
Hierarchical Names In
Historian Client 10.0
► Supported In
▪ Trend
▪ Query
▪ Workbook (Excel)
▪ Report (Word)
▪ Controls TagName/
Hierarchical
► In Trend Impacts Name Toggle

▪ All Tag Labels

▪ Tag Picker
Historian 10

What is new
• Support for Windows 2008 Server SP2 (not R2) 32 & 64 bit
• Support for Windows Vista SP2 Business, Enterprise, or Ultimate 32 & 64 bit
• Existing O/S still supported (see compatibility list in WDN)
• SQL Server 2008 SP1 32 bit only
• Windows 7 supported at a later date (end 2010).

•Architecture option - Tiered Historians

•Archestra Namespace Integration
•New Retrieval Modes
Summary Retrieval
► Existing 9.0 “Extension Tables”
▪ History
▪ WideHistory
▪ StateWideHistory
► New 10.0 “Extension Tables”
▪ AnalogSummaryHistory
▪ StateSummaryHistory
► Use all with conventional & summary tags
AnalogSummaryHistory
StateSummaryHistory
Broader Usage Of Data
► "Cleansing"
▪ More important further from process
▪ Instrument error can accumulate
► Expanded Industrial Aggregation
▪ More "time-in-state" aggregates
▪ Floating point "counter"
Reporting Support:
Industrial Data Cleansing

Spikes

“Gaps” or “bad” data quality

Removing Outliers
• Supported for all
modes
• Most useful for
aggregate modes
- Average
- Integral
Example: Removing Outliers
Filter Outliers (“SigmaLimit”)

SELECT DateTime,vValue,StateTime,wwFilter
FROM History
WHERE TagName IN ('Reactor1Level')
AND DateTime >= '2008-07-04 15:00:00'
AND DateTime <= '2008-07-04 17:00:00'
AND wwRetrievalMode = 'avg'
AND wwFilter = 'SigmaLimit(2)'
Estimating Missing Values
• Applies To:
- Counter
- Integral
Interpolate Across Gaps
(“Optimistic”)

SELECT DateTime,vValue,StateTime,wwFilter
FROM History
WHERE TagName IN ('Reactor1Level')
AND DateTime >= '2008-07-04 15:00:00'
AND DateTime <= '2008-07-04 17:00:00'
AND wwRetrievalMode = 'Integral'
AND wwQualityRule = 'optimistic'
How To Aggregate A Discrete?
► Measures
▪ Time in a state
▪ Number of transitions to/from a state
▪ Pulse width in time
▪ Duty cycle
► Calculations
▪ Total
▪ Minimum/Maximum
▪ Average
▪ Percent

“Saturn”
Treat Analogs As Discretes
100

1
“To Discrete”

Level
0
12 Boundary

Use with “ValueState” & “RoundTrip” retrieval

Converting Analogs To
Discretes
• Supported for all
modes
• Most useful for:
• ValueState
• RoundTrip
“ToDiscrete” Filter
SELECT DateTime,vValue,StateTime,wwFilter
FROM History
WHERE TagName IN ('Reactor1Level')
AND DateTime >= '2008-07-04 15:00:00'
AND DateTime <= '2008-07-04 17:00:00'
AND wwRetrievalMode = 'ValueState'
AND wwStateCalc = 'Total'
AND wwCycleCount = 1
AND wwFilter = 'ToDiscrete(12,>)'
Reporting Support:
Industrial Data Cleansing

• Example: Integrating flow rates

• Noise/error accumulates
 Reporting Support:
Industrial Data Cleansing

Tolerance Target Value

“Zeroing” Values
• Supported for all
modes
• Most useful for
Integral
• Base values can
be a list
“Zero” Values (“SnapTo”)
SELECT DateTime,vValue,StateTime,wwFilter
FROM History
WHERE TagName IN ('Reactor1Level')
AND DateTime >= '2008-07-04 15:00:00'
AND DateTime <= '2008-07-04 17:00:00'
AND wwRetrievalMode = 'Delta' Tolerance
AND wwStateCalc = 'Total'
AND wwFilter = 'SnapTo(0.1, 0.0, 1000.0)'
Target Values
999.9 < x < 1000.1  1000.0
-0.1 < x < 0.1  0.0
Historian 9.0 System Tags
► System Resource Monitoring
▪ Memory
▪ Processor
▪ Disk
► Historian Server Monitoring
▪ Subsystems: Event, Storage, OLE DB, Indexing, etc.
▪ Items: Status, resource usage, etc.
► Data Acquisition Monitoring by Source
▪ Item throughput
▪ “Bad” data quality
▪ “Outside real-time”
► Testing Tags (one per type, date/time)
120+ Historian 9.0 System Tags

SysConfigStatus SysInSQLIOS SysPerfIndexingHandleCount SysPerfStorageCPU

SysConfiguration SysManualStorage SysPerfIndexingPageFaults SysPerfStorageHandleCount
SysCritErrCnt SysMinutesRun SysPerfIndexingPrivateBytes SysPerfStoragePageFaults
SysDataAcq SysOLEDB SysPerfIndexingThreadCount SysPerfStoragePrivateBytes
SysDataAcq0BadValues SysPerfAvailableBytes SysPerfIndexingVirtualBytes SysPerfStorageThreadCount
SysDataAcq0OutsideRealtime SysPerfConfigCPU SysPerfInSQLIOSCPU SysPerfStorageVirtualBytes
SysDataAcq2 SysPerfConfigHandleCount SysPerfInSQLIOSHandleCount SysPerfSysDrvCPU
SysDataAcq2BadValues SysPerfConfigPageFaults SysPerfInSQLIOSPageFaults SysPerfSysDrvHandleCount
SysDataAcq2OutsideRealtime SysPerfConfigPrivateBytes SysPerfInSQLIOSPrivateBytes SysPerfSysDrvPageFaults
SysDataAcqOverallItemsPerSec SysPerfConfigThreadCount SysPerfInSQLIOSThreadCount SysPerfSysDrvPrivateBytes
SysDataAcqRxItemsPerSec2 SysPerfConfigVirtualBytes SysPerfInSQLIOSVirtualBytes SysPerfSysDrvThreadCount
SysDataAcqRxTotalItems2 SysPerfCPU0 SysPerfManualStorageCPU SysPerfSysDrvVirtualBytes
SysDateDay SysPerfCPU1 SysPerfManualStorageHandleCount SysPulse
SysDateMonth SysPerfCPU2 SysPerfManualStoragePageFaults SysRateDeadbandForcedValues
SysDateYear SysPerfCPU3 SysPerfManualStoragePrivateBytes SysRetrieval
SysErrErrCnt SysPerfCPUTotal SysPerfManualStorageThreadCount SysSpaceAlt
SysEventCritActionQSize SysPerfDataAcq2CPU SysPerfManualStorageVirtualBytes SysSpaceBuffer
SysEventDelayedActionQSize SysPerfDataAcq2HandleCount SysPerfMemoryPages SysSpaceMain
SysEventNormActionQSize SysPerfDataAcq2PageFaults SysPerfRetrievalCPU SysSpacePerm
SysEventSystem SysPerfDataAcq2PrivateBytes SysPerfRetrievalHandleCount SysStatusEvent
SysFatalErrCnt SysPerfDataAcq2ThreadCount SysPerfRetrievalPageFaults SysStatusRxItemsPerSec
SysHeadroomAnalog2 SysPerfDataAcq2VirtualBytes SysPerfRetrievalPrivateBytes SysStatusRxTotalItems
SysHeadroomAnalog4 SysPerfDiskTime SysPerfRetrievalThreadCount SysStorage
SysHeadroomAnalog8 SysPerfEventSysCPU SysPerfRetrievalVirtualBytes SysString
SysHeadroomDiscrete SysPerfEventSysHandleCount SysPerfSQLServerCPU SysSystemDriver
SysHeadroomString SysPerfEventSysPageFaults SysPerfSQLServerHandleCount SystemArea.AlarmOnCntTotal
SysHistoryCacheFaults SysPerfEventSysPrivateBytes SysPerfSQLServerPageFaults SysTimeHour
SysHistoryCacheUsed SysPerfEventSysThreadCount SysPerfSQLServerPrivateBytes SysTimeMin
SysHistoryClients SysPerfEventSysVirtualBytes SysPerfSQLServerThreadCount SysTimeSec
SysIndexing SysPerfIndexingCPU SysPerfSQLServerVirtualBytes SysWarnErrCnt
New 10.0 System Tags
SysStatusTopicsRxData
SysReplicationTierSyncQueueItemsTotal
SysReplicationSyncQueueValuesPerSecTotal
SysReplicationTotalValuesTotal
SysReplicationValuesPerSecTotal
SysReplicationValuesPerSecN
SysReplicationTotalValuesN
SysReplicationTotalTagsN
SysReplicationSyncQueueValuesPerSecN

Also sets of tags for the new services

Information Server V4.0

Platform Upgrades – SQL 2008, Windows Server 2008 and 64

bit support.

Support for Archestra Graphics using MS Silverlight

•Sharepoint integration (Multiviews) not

supported on 64 bit O/S
Information Server V4.0
Training
► Courses in all Wonderware products.
▪ http://www.wonderware.co.uk/training/course-
schedule/

▪ Most run at our Cheadle offices.

▪ Can be run on your site and can be tailored to
your application.
Our WebEx series...
► Next...Lean Energy ► Tuesday 15th April

► Then...Historian – ► Tuesday 18th May

High Level
??Questions??
Powering intelligent plant
decisions in real time.