Question

1
Replies
117
Views
Close popover
Mastan Patan (patam)
PEGA
Sr. Technical Architect
Pegasystems Inc.
IN
patam Member since 2017 3 posts
PEGA
Posted: April 16, 2019
Last activity: May 15, 2019
Closed

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

Pega Platform System Administration
Moderation Team has archived post