Knowledgebase:
Microsoft SQL Server support on JSCAPE MFT Server
Posted by John Villanueva, Last modified by John Villanueva on 26 June 2020 06:54 PM

The supported MS SQL Server versions are those supported by the Microsoft JDBC driver for SQL Server. As of this writing, the following SQL Server versions are supported by their JDBC driver:

  • SQL Server 2008
  • SQL Server 2008R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2019
  • Azure SQL Database 

As with regards to concerns about performance issues when using MS SQL Server Standard Edition (compared with the Enterprise Edition) with JSCAPE MFT Server, the only thing that really comes into play regarding performance with MFT Server is the number of concurrent connections that are supported by the database and how many transactions it can handle per second.

The number of concurrent connections (pool) that are made is controlled at the Datastore level under Settings > Datastore > Pool for storing configuration data, and if you are using database logging under Domain > Logging > Service.  Assuming your users' configurations are also stored in the database, then note that each login requires a read/write to the database. Otherwise there are very few database level transactions except when making configuration changes e.g. creating triggers, directory monitors etc. 

However, if you are writing log data to the database, then this would be something to look at more closely since each user interaction (login, upload, download etc.) would create a log entry in the database.  

While we don't see any reason not to use the Standard edition of MS SQL Server, we would recommend that you deploy your system to a test environment first and emulate similar loads to what you would expect in your production environment before rolling it out into production.
In case you don't have a way of running automated load tests on your MFT Server instance, I suggest you try out JSCAPE MFT Monitor (https://www.jscape.com/products/file-transfer-servers/jscape-load-tester). 
External references:
(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako jscape.kayako.com