Pega MS SQL Server High Number of Merge statements Alerts in logs

SQL Server has limitations with Merge statements and perform slow and results in high number of alerts when a SELECT queries runs a full table scan.

To resolve the same:

1. First check, are there any SELECT queries that does full table scan on the table or long running queries on the table, where Merge statement on the corresponding table is slow.

2. Make sure Primary Key/Indexes are used in the Where clause of SELECT query to run faster.

***Edited by Moderator Marissa to update platform capability tags****


Keep up to date on this post and subscribe to comments

May 15, 2019 - 2:37am


If it is doing full table scan then please create index on the columns which are used in where clause.