Separate SQL Server
K2 blackpearl installations can leverage existing infrastructure, for example installing the K2 databases on an existing SQL server. Alternative, it is common to install the K2 databases on a dedicated SQL server machine. This topology is suitable for smaller environments, such as Development, Test, Training or small-scale Production environments. If scaling for data availability is required, a SQL cluster would be best as this provides a redundant system for data availability.
The following topology does not include integration with SharePoint. If SharePoint integration is required see the appropriate SharePoint section: SharePoint 2013, 2016 and Online or SharePoint 2010.
| Single Install with separate SQL Server | |
|---|---|
| User Machine |
N/A |
| Developer Workstation |
Client Tools:
|
| Single Application Server |
Internet Information Server (IIS):
Application Server:
|
| SQL |
|
Considerations
- Although all components on a single machine are simple to install and maintain, and reduce the possibility of additional security requirements to support impersonation between machines, the processing capabilities of one physical machine may introduce performance issues.
- Additional RAM, a faster processor or improved disk and network throughput on the Application server(s) may be required to maintain an acceptable level of performance.
- Distributed Transaction Controller (DTC) must be configured properly for communications between the K2 Server and the SQL Server to function properly.
- Network connection speed between the Application Server and the SQL server must be as fast as possible with as little latency as possible (physical servers should preferably be on the same Gigabit-backbone.)
- It is not recommended to geographically separative the SQL Server from the application servers since this can introduce performance issues due to low bandwidth or latency between the K2 application servers and the SQL server.
- The SQL Server can share physical resources with other SQL databases or SQL Server Instances on the same SQL server, or be located on an dedicated SQL server/instance, or be located on an Azure SQL DB.
- K2 recommends that SQL administrators track performance of the SQL server and address performance issues through standard Microsoft SQL Server scaling approaches.
- The SmartForms Design Time and Runtime sites will be hosted on the same IIS Server as separate Sites.