Over time, I have seen some degregation in response. The online instructions says there are scripts "...available in the community" but I am unable to find these. Does anyone have any recommended scripts to keep the database humming along? I am pretty knowledgeable in SQL, but would prefer running sanctioned scripts versus developing any of my own.
One are in particular would be to truncate the sync log. It has +100K records already.
Thanks in advance!
Like
Hi Shane,
Could you please specify where you've seen a mention of these scripts? Unfortunately, we do not provide 'database maintenance' scripts, as our Cloud team is responsible for that.
Nonetheless, any SQL scripts can be run from within Configuration > "SQL scripts" tab or from our end. Basically, just send a request to support@bpmonline.com along with the script you created, or simply describe the end goal and we will create one for you.
Adam,
This is for on-premise, thus on my own SQL server. The scripts are mentioned in a number of documents, including all install and upgrade documents published. It says "NOTE: You can visit the BPMOnline community to find an example fof script for ...." and depending on the topic (scheduling, application monitoring, task updating, etc.).
Dear Shane,
You can run any of your scripts to maintain the database. There is no difference in efficiency between our scripts and the ones you have. In addition, you can reorganize and rebuild indexes for the tables using default SQL Management Studio tools. This will increase system performance.