Slow portal performance over time

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

Information Centric Analytics (ICA) portal users experience increasingly slow console performance over time. No new data sources have been integrated during that time, and this is experienced even when neither the nightly RiskFabric Processing job nor the RiskFabric Intraday Processing job is running.

Environment

Version : 6.x

Component : RiskFabric Portal

Cause

Table indexes in the RiskFabric database are significantly fragmented.

Resolution

To defragment table indexes, run the RiskFabric DB Maintenance Weekly job. First, confirm the job exists by following this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric database
3. In Object Explorer, navigate to SQL Server Agent > Jobs
4. Locate the job RiskFabric DB Maintenance Weekly
   1. If the job exists, run the job manually by following the next procedure
   2. If the job does not exist, select File > New > Query with Current Connection from the menu bar
      A new query editor window will open
   3. Copy the following statement and paste it in the new query editor window:

      EXEC RiskFabric.dbo.spRF_PostDeploy_AlwaysRun;

   4. Execute the statement by pressing the F5 key, clicking the Execute button in the SQL Editor toolbar, or selecting Query > Execute from the menu bar

To run the RiskFabric DB Maintenance Weekly job manually, follow this procedure:

1. Open SSMS
2. Connect to the Database Engine hosting the RiskFabric database
3. In Object Explorer, navigate to SQL Server Agent > Jobs
4. Right-click the job RiskFabric DB Maintenance Weekly and select Start Job at Step
   The Start Job on '<server-name[\<instance-name>]' window will open
5. Ensure Step ID 1 is highlighted and click the Start button

In addition to running the job, confirm the job is enabled and configured to run at least weekly by following this procedure:

1. Open SSMS
2. Connect to the Database Engine hosting the RiskFabric database
3. In Object Explorer, navigate to SQL Server Agent > Jobs
4. Right-click the job RiskFabric DB Maintenance Weekly and select Enable (if available)
5. Right-click the job RiskFabric DB Maintenance Weekly and select Properties
   The Job Properties - RiskFabric DB Maintenance Weekly window will open
6. Select the Schedules page
7. Review the schedules listed and edit as needed by selecting the job to edit and clicking the Edit button
8. Click the OK button to close the Job Properties window