SQL Server Database Server Filegroups for Smart Instrumentation - Intergraph Smart Instrumentation - Installation & Upgrade - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
2018 (12.0)

An SQL Server filegroup is a logical category that connects a database with operating system data files.  The DB Setup Utility for SQL Server creates the following filegroup types:

  • Admin data — used for the Administration schema logon settings.  The database contains the Admin schema logon data.

  • Index data —used for the Administration schema logon settings.  The database contains the Smart Instrumentation domain index of a single domain.

  • Domain — used for the Domain schema logon information.  The database contains domain data of a single domain (there is a different schema logon setting for each domain).

  • Index — used for the Domain schema logon information.

  • Log file — used internally by SQL Server to resume any previous sessions that were stopped.

  • View-Only Domain schema (an individual schema for each domain)

The DB Setup Utility creates Smart Instrumentation domain files using the following default file values:

Parameter

Admin Datafile

Index Datafile

Log Datafile

Filegroup name

primary

intools_dba_index

log

Data file name

intools_pr.ddti

intools_ix.ddti

intools_l.ddti

File size

15 MB

5 MB

50 MB

Administration data (admin data files and index data files), Smart Instrumentation database log file and history data are based on four filegroups: two Smart Instrumentation default filegroups and two SQL Server filegroups.  The SQL Server filegroups cannot be edited.  The default total file size in these filegroups is 70 MB.  Each filegroup is based on an auto-extended data file.  Such a file automatically extends to the limits of your disk.

The following table lists important statistical data that you can use as a guide when selecting the domain file sizes (the disc space required for such a domain is 650 MB):

Item Types

Quantity (Average)

Instrument tags

45058

Loops

16616

CAD loop drawing blocks

1381

Device panels

11384

Junction boxes

504

Marshaling racks

45 (208366 total number of terminals)

Cabinets

36

DCSs and PLCs

108

Channels

16880

Specifications

111

P&ID drawings

855

Lines

3132

The above item type quantities populate a domain whose file sizes are as follows:

Admin Datafile

Admin Index Datafile

Domain Datafile

Domain Index Datafile

Log Datafile

15 MB

5 MB

350 MB

180 MB

50 MB

Later, if you receive an indication that the available free space in the filegroup is low, or encounter a message that there is insufficient space while working in Smart Instrumentation, you need to increase the filegroup size for the appropriate domain.

  • Make sure the total file size that you specify does not exceed the available empty space on your selected disks.  The default is 70 MB, which includes the size of the file for the recommended initial size of the Admin data and indexes, and Smart Instrumentation Database Log file

  • Each of the file names must be a legal name.  Each file name must be unique within your database.  Special characters are not supported.

  • The DB setup application (.exe) is found in the folder where you installed Smart Instrumentation. By default that is; C:\Program Files (x86)\SmartPlant\Instrumentation.