Microsoft SQL Server Sizing Criteria

Selecting the type of server (virtual vs. physical) and properly sizing the server to the specific need is important to maintain peak performance of Personify and its related software. The following table defines the different database types and their function:

Database

Function

Personify

Personify Database

Primary Personify database

Personify PIDB

Personify Installation database

PA-DSS Database

Audit database for administrative actions

Personify E-Business

DotNetNuke Database

DotNetNuke is the web content management system that the Personify e-Business offering is built upon

Single Sign On / Identity Management Service (SSO / IMS)

Personify SSO / IMS Database

Database contains Single Sign-On and Identity Management Service mappings.

Personify Data Warehouse

Database Warehouse Database

Personify Analytics Advantage database

Database Warehouse Staging Database

Personify Analytics Advantage staging database

SAP BusinessObjects

BusinessObjects CMS Database

Database that contains reporting information

Audit Database

This database records changes / deletion / creation of objects