topic RE: Performance and capacitiy limit (DB-related) in Product Forum

Performance and capacitiy limit (DB-related)

YunaLee — Wed, 05 Apr 2023 07:44:00 GMT

I have a DB-related question.

First of all, Is there a document that clearly states which databases can install a Blue Prism server?

Second of all, in the case of MS SQL Express, the document stated that there is a limitation of features in the free version.

Is there any evidence of any functional limitations to using it in a blue prism environment?

In the 5 RR environment configuration examples as shown below, the constraints are only guided as follows.

It is difficult to guide customers because it is not known exactly what the restrictions are.

Thanks in advance 🙂

------------------------------
Yuna Lee
Solution Consultant
Blue Prism Korea
------------------------------

RE: Performance and capacitiy limit (DB-related)

Mukeshh_k — Wed, 05 Apr 2023 10:57:00 GMT

Hi Yuna Lee - MS SQL Server Express, ~~Oracle~~, PostgreSQL, ~~IBM DB2~~ are few Databases where Blueprism can be installed, also regarding the limitations of Free MS SQL Server Express - Maximum DB size is of 10GB, limited CPU and memory usage are some key limitations.

For more on this refer to the Microsoft documentation : https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16

Scale limits:

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
Maximum compute capacity used by a single instance - SQL Server Database Engine¹	Operating system maximum	Limited to lesser of 4 sockets or 24 cores	Limited to lesser of 4 sockets or 16 cores	Limited to lesser of 1 socket or 4 cores	Limited to lesser of 1 socket or 4 cores
Maximum compute capacity used by a single instance - Analysis Services or Reporting Services	Operating system maximum	Limited to lesser of 4 sockets or 24 cores	Limited to lesser of 4 sockets or 16 cores	Limited to lesser of 1 socket or 4 cores	Limited to lesser of 1 socket or 4 cores
Maximum memory for buffer pool per instance of SQL Server Database Engine	Operating System Maximum	128 GB	64 GB	1410 MB	1410 MB
Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine	Unlimited memory	32 GB	16 GB	352 MB	352 MB
Maximum memory-optimized data size per database in SQL Server Database Engine	Unlimited memory	32 GB	16 GB	352 MB	352 MB
Maximum memory utilized per instance of Analysis Services	Operating System Maximum	16 GB ² 64 GB ³	N/A	N/A	N/A
Maximum memory utilized per instance of Reporting Services	Operating System Maximum	64 GB	64 GB	4 GB	N/A
Maximum relational database size	524 PB	524 PB	524 PB	10 GB	10 GB

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS England, United Kingdom, GB
------------------------------

RE: Performance and capacitiy limit (DB-related)

zdenek.kabatek — Wed, 05 Apr 2023 13:46:00 GMT

Hi, Mukesh,

are you sure that you can install Blue Prism on Oracle and IBM DB2? I am not aware of it and I doubt it but you might have some information which I missed. As far as I know only MS SQL is supported.

Thanks for clarification.

Regards

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

RE: Performance and capacitiy limit (DB-related)

Mukeshh_k — Wed, 05 Apr 2023 13:57:00 GMT

Apologies- I might have got it wrong in confusing Connecting and Installing - we can definitely connect with Oracle DB via OLEDB for DB operations but for installation No Database IBM DB2 and Oracle are not supported.

Thanks for pointing it out.

RE: Performance and capacitiy limit (DB-related)

YunaLee — Wed, 12 Apr 2023 05:47:00 GMT

I appreciate it! It was what I needed

------------------------------
Yuna Lee
Solution Consultant
Blue Prism Korea
------------------------------