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.
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.
If the service is run on the same machine, press the "Local computer" button.
Otherwise, browse for the machine with the service. Press the "Connect to a remote" button. The following dialog box appears:
Select the machine from the list and press the "Select" button.
If the connection is successful, "Status" will be "Running" in green.
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.
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.
If Microsoft Event Viewer received the event type "Information" regarding Cinegy File Service, it will show how many events are available.
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.
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:
Press the "Browse" button next to the "SQL Server name" field to select a server.
Select the database name in the drop-down list next to the "Add" button.
Press the "Add" button.
Press the "Save" button:
"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:
Select a database in the "Databases" list box.
Press the "Delete" button.
The "Offline files" button shows the list of files moved to an HSM System.
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.
Here filter the event types to be displayed choosing the desired option from the corresponding drop-down list: