Administration Guide > Installation > New Installation > MS SQL Server

MS SQL Server

This guide includes the individual steps for setting up an MS SQL databaseA database is an organized collection of data including relevant data structures. for AE usage.

Refer to the reference section of the AE database in order to optimize performance. See:Configuration & Performance of the Database and the list of supported database versions.

Do not limit resource consumption. Aborting transactions due to limitations specified in the database can impede processing in the AE system. Additionally, inconsistent database contents can result, which can cause subsequent errors or endless loops.

Note that modifying database contents results in an inconsistent database.

Do no activate the option "autoshrink" in the database. This can occasionally cause a Automation Engine standstill. 

Note that it is important to set the SQL cursor (1st digit=S) or to activate MarsConnection in the INI-file parameter for the ODBC access (SQLDRIVERCONNECT= ) in the particular component (Automation Engine, utility). Otherwise, the SQL Server database can only process one command at the time which results in the following errort:
U0003590 DB error: 'SQLExecDirect', 'ERROR ', 'HY000', 'Connection is busy with results for another command'

You can maintain the AE database by using partitioning with ILMStands for Information Lifecycle Management, which refers to a wide-ranging set of strategies for administering storage systems on computing devices. (Information Lifecycle Management). Automic recommends reading the document about"Maintaining the data records"before you set up the database.

Disk Space Required

Size required for the initial installation of an AE database

Test systems:

1 GB

Production systems:

Small systems

5 - 20 GB

Medium systems

20 - 50 GB

Large system

more than 50 GB

Procedure

1. Requirements

2.

Setting up the database

3. Creating a database user
4. Setting up the Data Source