Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To provide the effective and steady stable performance of the of Axxon PSIM system, take into account the following recommendations on using the database use below:

  1. Store the Configuration database on the MS SQL server. If the MS Access is used to store the database, it is strongly recommended to install the MS SQL server and to convert the database from MS Access to MS SQL format (see Connecting the Axxon PSIM database)You must synchronize the databases of servers and Remote Administrator Workstations with the administration server database to provide the ability of the centralized administering of the video surveillance and audio control system.

    Info
    titleNote

    It is recommended to configure We recommend configuring the automatic backup of the Axxon PSIM database in MS SQL Server, for example, once a week (by default, the automatic backup is not isn't configured).

  2. The Servers and Remote Admin Workstation databases should be synced with the Administration server database.
  3. If long-term centralized storage is necessary for registered system events, then it is recommended to apply Axxon PSIM software configuration on the Servers and the Remote Admin Workstations in order to store the events in the If you want to store the registered events in the system in the centralized way during the long-term period, we recommend configuring Axxon PSIM on servers and Remote Administrator Workstations to store events in the Events log database separately from the Configuration database (see Extracting event protocol into an individual database).
  4. In case the Dynamic Host Configuration Protocol If you use the protocol of the dynamic host configuration (DHCP) is used, make sure that the TCP/IP protocol priority for local databases is the highest. Otherwise, when if you disconnect the network cable is disconnected, the communication between the between Axxon PSIM and its local database located on the same computer where Axxon PSIM is is installed can be lost. To view and prioritize the network protocols, use the the SQL Server Configuration Manager utility:

    1. Run the SQL Server Configuration Manager utility (StartMicrosoft SQL Server Express 2014Configuration Tools).

    2. In the left part of the utility's interface window, click the header title of the the SQL Native Client Configuration list, and then select the Client Protocols item in the drop-down list. In the right part of the window, right-click any protocol in the list and select the Order item in the context menu that appears.

    3. In the Client Protocols Properties dialog box window that appearsopens, the list of client protocols for the local SQL databases in descending priority order is displayed in the Enabled Protocols field. Make sure that the The TCP/IP item is line must be located at the very top of the Enabled Protocols list. Also make sure that , you must set the Enable Shared Memory Protocol checkbox is set.
    4. If the TCP/IP item is not line isn't located at the very top of the the Enabled Protocols list, use the Up button to move it.

...