Cinegy File Service can monitor any number of SQL Servers and databases. You can install it on an SQL Server machine, or on a separate server (for example, you can use the server where all the gateways are running). It also tracks files moved by an HSM System for later retrieval.

Service

31_DBM_CFS_main_blank

Connecting to File Service

Because Cinegy File Service can monitor different SQL Servers, the setting is stored locally in the registry and not in the database. Therefore, for every machine on which you run Cinegy Enterprise Manager, you have to connect to the service manually once.

  1. If the service is run on the same machine, press the "Local computer" button.
    31_DBM_CFS_main_local PC

  2. Otherwise, browse for the machine with the service. Press the "Connect to a remote" button. The following dialog box appears:
    31_DBM_CFS_connect

  3. Select the machine from the list and press the "Select" button.

  4. If the connection is successful, "Status" will be "Running" in green. 31_DBM_CFS_main

You have to connect to the service every time you invoke the dialog.

Setting the Refresh Interval

Enter the refresh time in milliseconds into the "Refresh timeout" field.

The value depends on the size of your disks. Do not set the value smaller than 10000 milliseconds (10 sec), as this will create unnecessary overhead.

Log Errors

Logs contain events logged by applications or programs. For example, a program records a file error in the application log and administrators can decide what the problems is.

"Log errors" will count the errors regarding the Cinegy File Service.

Log Info

If Microsoft Event Viewer received the event type "Information" regarding Cinegy File Service, it will show how many events are available.

See more details about filtered events in the Events paragraph.

Disable a File Recall

If you are using an HSM (Hierarchical Storage Management) system and would like to be able to retrieve files moved by the HSM, the "Disable a file recall" option has to be set to "0".

The "Disable a file recall" option should be set to "1" to disable the HSM support via the Cinegy File Service.

Low Free Space Limit

Enter the "Low free space limit" value to indicate when to switch the locations to non-active to avoid disk fragmentation.

"20%" is the minimum free space limit allowed. When this limit is exceeded, the location will be deactivated. After the cleanup, the share will automatically be enabled.

Disable Shared Storage Status Changing

The "Disable shared storage status changing" option should be set to "0" to enable the above mentioned automatic deactivation of a certain location via the Cinegy File Service. The "Disable shared storage status changing" option should be set to "1" to disable the automatic free space control.

Adding a New Database for Watching

To add a new database, do the following:

  1. Press the "Browse" button next to the "SQL Server name" field to select a server. 31_DBM_CFS_add_database

  2. Select the database name in the drop-down list next to the "Add" button. 31_DBM_CFS_add_database1

  3. Press the "Add" button.

  4. Press the "Save" button: 31_DBM_CFS_main

  5. "Stop" and "Start" the service to refresh its settings.

Deleting a Database from the Watch List

To remove a database from the list of monitored databases, do the following:

  1. Select a database in the "Databases" list box.

  2. Press the "Delete" button.

Offline Files

The "Offline files" button shows the list of files moved to an HSM System.

Events

Go to the "Events" tab to view all the system or application events related to the service. This is for your convenience because the events are usually shown only in Windows Event Viewer.

32_DBM_CFS_Events

Here filter the event types to be displayed choosing the desired option from the corresponding drop-down list:

32_DBM_CFS_Events_types filter