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.