Question
Estes Express Lines
US
Last activity: 3 May 2019 12:30 EDT
Pega Select queries Offload
At SQL side, we have a secondary replica which allows read. In Pega, is it possible to offload Pega Select queries from primary node to a secondary SQL node?
DB are in AlwaysOn Availability group. One Primary node(Read/Write) and Secondary node(Read-Only). Our DB team would like to know is this something possible from Pega end?
***Edited by Moderator Marissa to update platform capability tags; add SR details****
Pegasystems Inc.
US
You could use report database for this. Please refer to https://community.pega.com/knowledgebase/release-note/use-alternate-database-report-source
Estes Express Lines
US
Hi
We hosted PEga database on SQL server always on availability group (primary and secondary node). In Pega, there are reports that select data from work tables. We have several reports. is it possible to create a separate data source for those reports? we want to use a second node which is read only. we want these reports to query from a secondary node.
Thank you
Mya
Pegasystems Inc.
US
Yes. You could define the report database as mentioned above, following the instructions to allow your reports to use the alternative report database instead. https://community.pega.com/sites/default/files/help_v74/procomhelpmain.htm#reporting/rpt-setting-up-reports-database-tsk.htm