-
Title
Manually Installing and configuring a SQL Server based PI repository -
Description
What are the steps required to manually create a SQL Server (MSSQL) based PI repository? -
Resolution
Important Note
This process provides a set of steps to manually create a SQL Server PI repository database and may be used when technical reasons prevent the installer from creating the databases.
The 5.9.5.20 upgrade wizard will automatically disable Infobright PI for existing SQL Server and Oracle database agents.- Disable the Infobright PI extension for SQL Server agents
- Disable the Infobright PI extension for Oracle agents
- Pause the PI Engine for SSAS agents
- Disable Infobright PI for SQL PI agents
IMPORTANT: Quest recommends either using Foglight to monitor the size of the SQL PI transaction log or to use the SIMPLE recovery model on the SQL Server PI repository databases to avoid the SQL PI repository transaction log running out of space and affecting the usability of the product.
Prerequisites
Please refer to the latest copy of the Foglight for Databases Deployment Guide for the prerequisites for this installation.
Microsoft SQL Server Installation and Configuration
This section describes the properties which need to be modified or are of concern.
For other properties which are not mentioned here, if you don't know how to config them, just keep them as default.
By default, there should be three volumes in the SQL Server host:
- Volume C for OS data
- Volume E for PI 1m data and user database log
- Volume F for user database primary data (PI non-1m data)
For better disk IO perspective, volume F and E should be on the same physical/VM disk. Volume C can share the same volume as E.1. Feature Selection
Select the "Database Engine Services" feature and the installation directories are in volume C.
2. Server Configuration
- Use a SQL_Latin1_General_CP1_CI_AS collation
- Use "Mixed Mode" for authentication
- Add current user to SQL Server administrators group
3. Data Directories
Note: The 5.9.4.26 and higher versions of the cartridge can initialize the SQL PI schema automatically. The user can specify the data directories when enabling the PI for the first DB agent. Thus this "Data Directories" step is optional.
- User database directory is in volume F
- Database log directory is in volume E
4. SQL Server Maximum Memory
Please refer Server Memory Server Configuration Options for more details.
The following video details how to install the SQL Server PI repository instance.