How Meridian Works With SQL Server

Meridian works with SQL Server using two intermediate Meridian components:

Object cache (<DatabaseEngine>SQL.dll): A database-dependent cache that optimizes queries to SQL Server.
Accruent SQLIO (HTSQLIO.dll): A SQL Server-specific component that interfaces between the object cache and SQL Server.

The relationships between these components are illustrated in the following figure.

Relationships between Meridian and SQL Server components.

When a Meridian client sends or requests data from the Meridian application server, the EDM Server service communicates with its object cache, which in turn communicates with Accruent SQLIO, which then communicates with SQL Server on the SQL Server computer.

Important!

Do not change the properties of a SQL Server database that is used by Meridian. Especially do not clear the Unrestricted file growth options for Maximum file size for either the data files or the transaction log. When the maximum size of the log file is reached, SQL Server cannot write to the database any more, as it is full.