SQL Back-End Database
- Archiving EventsGeneral Table
Problem The pstar SQL Database is too large to run certain Reports and most of the storage is being taken up by the EventsGeneral table. Solution Run SQL scripts to back up data for a set number of days and Archive the EventsGeneral table to lighten up the production database. How to archive EventsGeneral NOTE: These steps utilize two (2) SQL scripts in the attached
- PortalGuard SQL Backend Configuration and Requirements
Problem You need to configure the SQL Backend for PortalGuard. Solution Use the existing scripts to create the 'pstar' database and service account, then configure PortalGuard to utilize the new database. Quick Navigation Requirements Creating the 'pstar' Database Creating the 'pg_update' Service Account Configuring
- PortalGuard SQL Monitoring Application
Problem Your PortalGuard server is not generating any Reports in the Admin Dashboard. You are experiencing any SQL related issue with PortalGuard. Solution Our PG SQL Monitor application is an automated utility that runs as a Windows Service on your PortalGuard server to test the connection to your SQL database. Download the SQL Monitoring application below:
- Archive EventsSSO Table
Problem The EventsSSO table is becoming very large, causing certain reports to run slowly or performance loss. Solution Run the included SQL scripts to back up data for a set number of days and Archive the EventsSSO table to lighten up the production database. How to archive EventsSSO NOTE: These steps utilize two (2) SQL scripts in the attached zip file. Make
- Archiving RBAEvents Table
Problem The pstar SQL Database is too large to run Reports and most of the storage is being taken up by the RBAEvents table. Solution Run SQL scripts to back up data for a set number of days and Archive the RBAEvents table to lighten up the production database. How to archive RBAEvents NOTE: These steps utilize two (2) SQL scripts in the attached zip file. Create