Support Article
Pega instance hangs while waiting on a database
SA-64859
Summary
Pega instance hangs while waiting on a database. As a result, the system stops working and must be restarted.
Error Messages
Not Applicable
Steps to Reproduce
Not Applicable
Root Cause
A defect or configuration issue in the operating environment.
The formation of the index was a block instead of cluster.
Resolution
Perform the following local-change:
Delete and add the primary key constraint again and set it as a cluster.
This stores the index data with the row data and reduces the chance of waits on resources across multiple database pages between several unrelated transactions.
/* Object: Index [pr_sys_locks_PK] Script Date: 8/24/2018 5:10:13 PM */
ALTER TABLE [your_data_schema].[pr_sys_locks] DROP CONSTRAINT [pr_sys_locks_PK] WITH ( ONLINE = OFF )
GO
SET ANSI_PADDING ON
GO
/* Object: Index [pr_sys_locks_PK] Script Date: 8/24/2018 5:10:13 PM */
ALTER TABLE [your_data_schema].[pr_sys_locks] ADD CONSTRAINT [pr_sys_locks_PK] PRIMARY KEY CLUSTERED
(
[pzInsKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
Published October 28, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.