Issue Description – User facing delayed responses in PAM.
Cause – This issue occurs when the database size is occupied with the database logs, which in result causes delay for the end users.
Resolution – This issue gets resolved by shrinking the database using the below steps.
-
Run the SSMS application.
-
Click on the connect button àSelect Server Name from the dropdown à Select the Authentication type as SQL Server Authentication.
-
Enter the credentials for the sectonadb (credentials are mostly Username – spectradbadmin and the default password).
-
In the left side panel click on the button of the connected server to drop down the further options.
-
Click on the button of the Databases option.
-
Select the PAM database (SectonaDB) and right click on it.
-
Click on the Tasks option àclick on the Shrink option à Select the Files option.
-
In the Shrink file window, select Log option in the File type.
-
Click on ok the execute the task.