Question

1
Replies
113
Views
patam Member since 2017 3 posts
PEGA
Posted: 1 year ago
Last activity: 1 year 5 months ago
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
Share this page LinkedIn