Showing results 1 to 2 of 2

Thread: Ideal Configuration for Evacuating to SQL Server

  1. #1
    Join Date
    28.08.2012
    Posts
    1

    Default Ideal Configuration for Evacuating to SQL Server

    Hi,

    I'm new to Zenon so I have a question about the ideal configuration for evacuating to an SQL database that is on a seperate computer. The setup will be that one computer will be running the Runtime Client and the Server, while another computer will have an SQL database that will receive the evacuated archives. My question is, is there any efficient setting for the savings cycle or the evacuation time to the SQL database? From my understanding, changing the saving cycle will dictate how often a new archive is made and the evacuation setting dictates how often those archives are deleted and evacuated (to SQL).

    Also, is this configuration ideal or am I better off having the Runtime client running off of one computer and the Server plus the SQL database on the other?

  2. #2
    Join Date
    30.05.2007
    Location
    Salzburg
    Posts
    879

    Default Re: Ideal Configuration for Evacuating to SQL Server

    The setup will be that one computer will be running the Runtime Client and the Server, while another computer will have an SQL database that will receive the evacuated archives.
    You can start the zenon Runtime (with a given project) only once on a computer. Archiving and thus also the evacuation of the archive data into a database is done only at the zenon Runtime Server (not Client). Of course you can have additional computers with zenon Runtime installed which acts as clients.

    My question is, is there any efficient setting for the savings cycle or the evacuation time to the SQL database? From my understanding, changing the saving cycle will dictate how often a new archive is made and the evacuation setting dictates how often those archives are deleted and evacuated (to SQL).
    this really depends on your needs. if you want to have the archived data in the database as fast as possible you then want to define a short archive saving cycle with a storage time "0".
    FYI: for viewing archive data (i.e. with ETM) it does not matter in which form the archived data is held. Archived data can be viewed when the data is held in binary form (*.arx files) and/or in a database

    You can find additional information on that in the help documentation:
    Manual -> Historian -> Engineering in the Editor -> Creating a new archive -> Save -> Evacuate

    regards,
    herbert


Similar Threads

  1. Priamry and Secondary Server configuration
    By talal.mubarak in forum zenon Network
    Replies: 1
    Last Post: 10th August 2011, 02:13
  2. Server & Client monitor configuration
    By roberto1978 in forum zenon Network
    Replies: 1
    Last Post: 10th January 2011, 23:19
  3. SQL Server Logdatei
    By kwb in forum zenon Supervisor
    Replies: 1
    Last Post: 3rd March 2009, 12:00
  4. Timeseries data and SQL Server
    By nsko in forum Drivers
    Replies: 2
    Last Post: 28th May 2008, 08:20
  5. Version 6.21; SQL Server installation fails
    By stefan_m in forum Editor and Runtime Setup
    Replies: 0
    Last Post: 12th September 2007, 07:40

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •