QPR ProcessAnalyzer System Requirements: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
 
(154 intermediate revisions by 4 users not shown)
Line 2: Line 2:
__TOC__
__TOC__


== System Requirements for QPR ProcessAnalyzer Excel Client ==
==System Requirements for Web Browsers==
One of the following web browsers are needed:
* Windows desktop
** Google Chrome
** Mozilla Firefox
** Microsoft Edge
* Mac desktop with Safari
* Tablets and smartphones
** Apple iPad and iPhone with iOS 16 and Safari
** Android version 11 or higher with Chrome for Android


The System Requirements for QPR ProcessAnalyzer Excel Client are:
Note: Due to the rapid update schedule of web browsers, QPR Software does not specify the supported versions but indicates the latest versions that are tested and verified to work. Chrome and Firefox versions newer than the tested versions are likely to work, but QPR Software cannot guarantee their functionality before the next release. Any compatibility issues will be fixed as soon as possible for the next release.
* Microsoft Windows 7, Microsoft Windows 8, or Microsoft Windows 10 operating system
**Mac users need to use Windows as a pure virtual machine, created on e.g. [http://www.parallels.com/products/desktop/ Parallels Desktop] or [http://www.vmware.com/products/fusion/overview.html VMware Fusion], or as a virtualized Boot Camp partition created by either one.
*Microsoft Office 2007, 2010, 2013, or 2016.
*Internet connection for connecting to QPR ProcessAnalyzer Service
*The sapnco.dll and sapnco_utils.dll files distributed in the [http://service.sap.com/connectors SAP Connector for Microsoft .NET Version 3.0 (requires SAP Service Marketplace credentials)] package are needed in order to use the [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSapQuery|ImportSapQuery]] script command. See the instructions below for installing them.


The following components are also required and will be installed if not found on your computer:
== System requirements for QPR ProcessAnalyzer Server ==
*Microsoft .NET Framework 4.6.1
* Windows Server 2016, Windows Server 2019 or Windows Server 2022
*Microsoft Visual Studio Tools for Office Runtime
* .NET 8 ASP.NET Core Runtime Hosting Bundle (available in https://dotnet.microsoft.com/en-us/download/dotnet/8.0) (starting from QPR ProcessAnalyzer 2024.1), or .NET 6 ASP.NET Core Runtime Hosting Bundle (available in https://dotnet.microsoft.com/en-us/download/dotnet/6.0) (for earlier releases than QPR ProcessAnalyzer 2024.1)
* [[Installing_QPR_ProcessAnalyzer_Server#Install_IIS_Server_Roles_and_Features | Install Server Roles and Features for Microsoft Internet Information Services (IIS)]]
* Databases:
** Microsoft SQL Server 2014, Microsoft SQL Server 2016, Microsoft SQL Server 2017, Microsoft SQL Server 2019 or Microsoft SQL Server 2022 (with Database Engine)
** Three databases are required: metadata database, datatables database, and scripting database ([[Installing_QPR_ProcessAnalyzer_Server#Create_Databases|more information]])


=== Requirements for Using the Script Command --#ImportSapQuery ===
== System Requirements for QPR ScriptLauncher ==
* Microsoft Windows 10, Windows 11 or Windows Server (versions supported by [[#System_requirements_for_QPR_ProcessAnalyzer_Server|QPR ProcessAnalyzer Server]]).
* Internet connection
* .NET 8 Desktop Runtime (available in https://dotnet.microsoft.com/en-us/download/dotnet/8.0) (starting from QPR ProcessAnalyzer 2024.1), or .NET 6 Desktop Runtime (available in https://dotnet.microsoft.com/en-us/download/dotnet/6.0) (for earlier releases than QPR ProcessAnalyzer 2024.1)
* To import data from SAP using RFC interface, SAP NetWeaver RFC Library 7.50 library is needed ([[QPR_ProcessAnalyzer_ScriptLauncher#Installing SAP NetWeaver RFC Library|installation instructions]])


In order to use the script command [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSapQuery|ImportSapQuery]], you need to [[Installing_QPR_ProcessAnalyzer#Installing_SAP_Connector_for_Microsoft_.NET_Version_3.0_Dll_Files|install the SAP Connector for Microsoft .NET Dll files]].
== Recommended Hardware for QPR ProcessAnalyzer Server (Snowflake) ==
 
When running QPR ProcessAnalyzer in Snowflake, there are following requirements to QPR ProcessAnalyzer Server:
== System Requirements for QPR ProcessAnalyzer Xpress ==
* Up to 5 simultaneous users
 
** 16GB memory
The requirements specific to QPR ProcessAnalyzer Xpress include the following:
** 4 processor cores
* A 64-bit Microsoft Windows 7, Microsoft Windows 8, or Microsoft Windows 10 operating system
* More than 5 simultaneous users
* SQL LocalDB 2016 database.
** 32GB memory
* Internet connection in order to connect to the [[Activation|activation]] server
** 8 processor cores
 
== System Requirements for QPR ProcessAnalyzer Server ==
 
The system requirements for QPR ProcessAnalyzer Server are as follows:
* Microsoft Windows Server 2008 R2 or 2012 operating system
* Sufficiently powerful enough hardware to run the operating system
* Microsoft .NET Framework 4.6.1 is installed
* Microsoft Internet Information Services, with the following role services (features) enabled:
** '''Common HTTP Features''':
*** Default Document
*** Directory Browsing
*** HTTP Errors
*** Static Content
** '''Health and Diagnostics''':
*** HTTP Logging
** '''Performance''':
*** Static Content Compression
** '''Security''':
*** Request Filtering
*** Windows Authentication
** '''Application Development''':
*** .Net Extensibility 4.5/4.6
*** ASP.NET 4.5/4.6
*** ISAPI Extensions
*** ISAPI Filters
** '''Management Tools''':
*** IIS 6 Management Console
* The following Features need to be enabled:
*** HTTP Activation
** '''.Net Framework 4.5/4.6 Features''':
*** .Net 4.5/4.6
*** ASP.Net 4.5/4.6
*** WCF Services
**** HTTP Activation
**** TCP Port Sharing
** '''User Interfaces and Infrastructure''':
*** Graphical Management Tools and Infrastructure
*** Server Graphical Shell
** '''Windows Powershell''':
*** Windows Powershell 2.0, 3.0 or newer if available
*** Windows Powershell ISE
** '''Windows Process Activation Service''':
*** Process Model
*** Configuration APIs
** '''WoW64 Support'''
** The [http://www.iis.net/downloads/microsoft/url-rewrite URL rewrite module]
 
If IIS is installed after the system setup, the following command must be run after the setup to enable correct operation:
<pre>
aspnet_regiis.exe  -i -enable
</pre>
 
 
QPR ProcessAnalyzer has flexible deployment architecture and the load from multiple simultaneous users and multiple geographical locations around the world can balanced by using a distributed sql server cluster, replicated sql server machines and deploying multiple application servers
 
== System Requirements for QPR ProcessAnalyzer Pro Database Server - Microsoft SQL Server Database Server ==


The system requirements for QPR ProcessAnalyzer Pro Database Server - Microsoft SQL Server Database Server are as follows:
Dataset sizes don't affect the QPR ProcessAnalyzer Server requirements, because data is processed in Snowflake.
* Sufficiently powerful enough hardware to run the operating system
* Microsoft SQL Server 2012, 2014, or 2016 database, with the following features:
** '''Instance Features''':
*** Database Engine Services


== System Requirements for QPR ProcessAnalyzer ScriptLauncher ==
== Recommended Snowflake Warehouses ==
The Snowflake warehouse sizing follows these general guidelines:
* Scaling up: The more there is data in the process mining model, the larger warehouse size is needed (XS, S, M, L, XL).
* Scaling out: The more there are simultaneous users, the more clusters are needed in the multi-cluster warehouse.


The System Requirements for QPR ProcessAnalyzer ScriptLauncher tool are:
Typical Snowflake warehouses for different models:
* Microsoft Windows 7, Microsoft Windows 8, Microsoft Windows 10, or Microsoft Windows Server 2012 R2 operating system
* Models up to 10M events: 1 node (XS)
**Mac users need to use Windows as a pure virtual machine, created on e.g. [http://www.parallels.com/products/desktop/ Parallels Desktop] or [http://www.vmware.com/products/fusion/overview.html VMware Fusion], or as a virtualized Boot Camp partition created by either one.
* Models up to 30M events: 2 nodes (S)
*Internet connection
* Models up to 100M events: 4 nodes (M)
*The sapnco.dll and sapnco_utils.dll files distributed in the [http://service.sap.com/connectors SAP Connector for Microsoft .NET Version 3.0 (requires SAP Service Marketplace credentials)] package are needed in order to use the [[Data_Extraction,_Transformation,_and_Loading#--.23ImportSapQuery|ImportSapQuery]] script command. See the [[Installing_QPR_ProcessAnalyzer#Installing_QPR_ProcessAnalyzer_ScriptLauncher|instructions]] for installing them.
* Models up to 300M events: 8 nodes (L)
* Models up to 1000M events: 16 nodes (XL)


The following components are also required:
Typical Snowflake multi-cluster configuration depends on simultaneous users:
*Microsoft .NET Framework 4.6.1
* Up to 1 simultaneous user: 2 clusters
* Up to 3 simultaneous users: 3 clusters
* Up to 5 simultaneous users: 4 clusters
* Up to 10 simultaneous users: 5 clusters
* Up to 20 simultaneous users: 6 clusters


== Supported Web Browsers for QPR ProcessAnalyzer Web Client ==
Snowflake can adjust automatically the number of clusters based on the load, which is the recommended configuration. There are two scaling policies available, and of them the ''standard scaling policy'' is suitable for QPR ProcessAnalyzer analytics usage. When configured property, Snowflake is able to provide consistent performance regardless of number simultaneous of users. Note that the multi-cluster warehouses are not available in the Snowflake Standard Edition accounts.


QPR ProcessAnalyzer Web Client supports the following web browsers:  
* More information about Snowflake warehouses: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
*Microsoft Internet Explorer 9 or later
* More information about multi-cluster warehouses: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html.
*Mozilla Firefox version 17 or later
*Google Chrome version 23 or later
*Apple Safari 5 or later


'''Note:''' If you are using Microsoft Internet Explorer, do not turn on the compatibility mode.
== Recommended Hardware for QPR ProcessAnalyzer Server (in-memory) ==
 
* '''Small''' datasets (up to 5 million events per model) with simultaneous users
== Suggested Hardware for QPR ProcessAnalyzer Xpress ==
** 32GB memory
 
QPR ProcessAnalyzer Xpress Excel Client
* minimum 8GB Memory
* minimum 32GB available SSD Disk
* minimum 4 core processor
 
== Suggested Hardware for QPR ProcessAnalyzer Pro ==
 
'''QPR ProcessAnalyzer Pro Client hardware'''
 
QPR ProcessAnalyzer Pro Excel Client
* minimum 4GB Memory
 
QPR ProcessAnalyzer Pro Web Client
* minimum 4GB Memory
 
QPR ProcessAnalyzer Pro Mobile Client
* 2 core processor
 
'''QPR ProcessAnalyzer Pro Server hardware'''
 
Option A - in-memory usage enabled - analysis is done in Pro Server
* Minimum
** 32GB Memory
** 4 processor cores
** 4 processor cores
** 200GB Disk
** 50GB disk
* Recommended minimum for medium size data sets (1+ million events, multiple processes) with simultaneous users
* '''Medium''' datasets (10-20 million events per model) with simultaneous users
** 64GB Memory
** 64GB memory
** 4 processor cores
** 300GB Disk
* Recommended minimum for large data sets (10+ million events, multiple processes) with simultaneous users
** 128GB Memory
** 8 processor cores
** 8 processor cores
** 400GB Disk
** 100GB disk
* Recommended minimum for very large data sets (100+ million events, multiple processes) with simultaneous users
* '''Large''' datasets (20-80 million events per model) with simultaneous users
** 256GB Memory
** 256GB memory
** 16 processor cores
** 16 processor cores
** 500GB Disk
** 150GB disk
* '''Very large''' datasets (more than 80 million events per model) with simultaneous users
** 512GB memory
** 32 processor cores
** 200GB disk


Option B - in-memory not in use - Analysis is done in SQL Server:
== Recommended Hardware for Database ==
* Minimum 4GB Memory 1 core 100 GB disk
There are two databases used by QPR ProcessAnalyzer: metadata database and datatables database. The metadata database has relative small amount of data, so pretty lightweight SQL Server is sufficient (for small installations, 4GB memory and 2 processor cores, and heavy usage environments, 8GB memory and 4 processor cores). The datatables database has similar requirements, but in addition the required disk space depends on amount of data stored (100GB - 10TB SSD disk).
* Recommended: 8GB Memory 2 core 200 GB disk
* Recommended for many simultaneous user: 16GB Memory 4 core 200 GB disk


'''QPR ProcessAnalyzer Pro Database Server - Microsoft SQL Server Database Server'''
== System Requirements for QPR TaskRecorder ==
* Operating systems: Windows 10 or Windows 11
* Installation uses approximately 100MB of disk space, and additional of 200MB should be reserved for task recordings.
* Approximately 200MB of memory is used by QPR TaskRecorder.
* QPR TaskRecorder is a .NET application released as a self-contained package, and .NET doesn't need to be installed separately.


Option A - in-memory usage enabled - analysis is done in Pro Server
[[Category: QPR ProcessAnalyzer]]
* minimum
** 16GB Memory
** 300GB - 1TB available SSD disk for SQL Server temp database
** 500GB - 10TB available SSD or RAID disk for data storage on a disk dedicated to QPR ProcessAnalyzer
** 4 processor cores
 
Option B - in-memory not in use - analysis is done in SQL Server:
 
* minimum
** 16GB Memory
** 200GB available SSD disk for SQL Server temp database
** 200GB available SSD or RAID disk for data storage on a disk dedicated to QPR ProcessAnalyzer
** 4 processor cores
* Recommended minimum for medium size data sets (1+ million events, multiple processes) with simultaneous users
** 32GB Memory
** 300GB available SSD disk for SQL Server temp database
** 400GB available SSD or RAID disk for data storage on a disk dedicated to QPR ProcessAnalyzer
** 4 processor cores
* recommended minimum for large data sets (10+ million events, multiple processes) with simultaneous users
** 64GB Memory
** 600GB available SSD disk for SQL Server temp database
** 1 TB available SSD or RAID disk for data storage on a disk dedicated to QPR ProcessAnalyzer
** 8 processor cores
* recommended minimum for very large data sets (100+ million events, multiple processes) with many simultaneous users
** 256 GB Memory
** 1 TB available SSD disk for SQL Server temp database
** 10 TB available SSD or RAID disk for data storage on a disk dedicated to QPR ProcessAnalyzer
** 16 processor cores

Latest revision as of 09:24, 28 December 2023

System Requirements for Web Browsers

One of the following web browsers are needed:

  • Windows desktop
    • Google Chrome
    • Mozilla Firefox
    • Microsoft Edge
  • Mac desktop with Safari
  • Tablets and smartphones
    • Apple iPad and iPhone with iOS 16 and Safari
    • Android version 11 or higher with Chrome for Android

Note: Due to the rapid update schedule of web browsers, QPR Software does not specify the supported versions but indicates the latest versions that are tested and verified to work. Chrome and Firefox versions newer than the tested versions are likely to work, but QPR Software cannot guarantee their functionality before the next release. Any compatibility issues will be fixed as soon as possible for the next release.

System requirements for QPR ProcessAnalyzer Server

System Requirements for QPR ScriptLauncher

Recommended Hardware for QPR ProcessAnalyzer Server (Snowflake)

When running QPR ProcessAnalyzer in Snowflake, there are following requirements to QPR ProcessAnalyzer Server:

  • Up to 5 simultaneous users
    • 16GB memory
    • 4 processor cores
  • More than 5 simultaneous users
    • 32GB memory
    • 8 processor cores

Dataset sizes don't affect the QPR ProcessAnalyzer Server requirements, because data is processed in Snowflake.

Recommended Snowflake Warehouses

The Snowflake warehouse sizing follows these general guidelines:

  • Scaling up: The more there is data in the process mining model, the larger warehouse size is needed (XS, S, M, L, XL).
  • Scaling out: The more there are simultaneous users, the more clusters are needed in the multi-cluster warehouse.

Typical Snowflake warehouses for different models:

  • Models up to 10M events: 1 node (XS)
  • Models up to 30M events: 2 nodes (S)
  • Models up to 100M events: 4 nodes (M)
  • Models up to 300M events: 8 nodes (L)
  • Models up to 1000M events: 16 nodes (XL)

Typical Snowflake multi-cluster configuration depends on simultaneous users:

  • Up to 1 simultaneous user: 2 clusters
  • Up to 3 simultaneous users: 3 clusters
  • Up to 5 simultaneous users: 4 clusters
  • Up to 10 simultaneous users: 5 clusters
  • Up to 20 simultaneous users: 6 clusters

Snowflake can adjust automatically the number of clusters based on the load, which is the recommended configuration. There are two scaling policies available, and of them the standard scaling policy is suitable for QPR ProcessAnalyzer analytics usage. When configured property, Snowflake is able to provide consistent performance regardless of number simultaneous of users. Note that the multi-cluster warehouses are not available in the Snowflake Standard Edition accounts.

Recommended Hardware for QPR ProcessAnalyzer Server (in-memory)

  • Small datasets (up to 5 million events per model) with simultaneous users
    • 32GB memory
    • 4 processor cores
    • 50GB disk
  • Medium datasets (10-20 million events per model) with simultaneous users
    • 64GB memory
    • 8 processor cores
    • 100GB disk
  • Large datasets (20-80 million events per model) with simultaneous users
    • 256GB memory
    • 16 processor cores
    • 150GB disk
  • Very large datasets (more than 80 million events per model) with simultaneous users
    • 512GB memory
    • 32 processor cores
    • 200GB disk

Recommended Hardware for Database

There are two databases used by QPR ProcessAnalyzer: metadata database and datatables database. The metadata database has relative small amount of data, so pretty lightweight SQL Server is sufficient (for small installations, 4GB memory and 2 processor cores, and heavy usage environments, 8GB memory and 4 processor cores). The datatables database has similar requirements, but in addition the required disk space depends on amount of data stored (100GB - 10TB SSD disk).

System Requirements for QPR TaskRecorder

  • Operating systems: Windows 10 or Windows 11
  • Installation uses approximately 100MB of disk space, and additional of 200MB should be reserved for task recordings.
  • Approximately 200MB of memory is used by QPR TaskRecorder.
  • QPR TaskRecorder is a .NET application released as a self-contained package, and .NET doesn't need to be installed separately.
Retrieved from "https://wiki.onqpr.com/pa/index.php?title=QPR_ProcessAnalyzer_System_Requirements&oldid=24105"