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****