Database Performance Related Issue

Issue

You may experience sometime slow response times while accessing PAM.

Cause

Excessive database log files can consume available database storage, resulting in slow PAM performance.

Resolution

To resolve this issue, shrink the database.

  • Run SQL Server Management Studio (SSMS).

  • Click Connect, select the server name, and choose SQL Server Authentication.

  • Enter the credentials for the database administrator account.

image-20261026-133206.png
  • In Object Explorer, expand the connected databases and right-click the SSPDB database.

  • Click Tasks → Shrink → Files.

image-20261026-135218.png
  • In the Shrink File window, select Log as the file type and click OK to run the task.

image-20261026-135543.png