DataFinder Server 2018 Resource Manager Service

[Pesmith8]

Hi Group.

I am looking to understand the use case for some of the advance settings for Data Finder Server. 

In the TDM Server Control Panel

1.0 These are Resource Manager Service and Information Audit Service.  Both of these have the option to store the results of these Service in a different DB from default SQL db. Would like to understand what intended use case was for this feature. So that I can use it productively.  I have setup a MS Sql server 2012 on a VM  running dfse 2018, and it created some tables with basic status of the individual Tasks(Parameters passed) 

2.0  Option exists for setting a Cache for file cache path and Server Cache path,   Would like to understand the intended use case for this options.   So that it can be used corrrectly.

Thanks for your help as always. 

Paul

[EasyToDo · Accepted solution]

Hi Paul,

1.0
I would recommend using the default DB. The only reason to switch to MS SQL Server, which makes sense to me, is that your IT or the company rules defines that all information needs to be stored within the existing MS SQL Server DB, which are already available and managed by the existing SQL DB admins.

2.0
Server cache path:
Specifies the path for the swap files of the server computing nodes. It would be perfect if this location is pointing to a local drive which is fast.

File cache path:
Specifies the path for the file cache. TDM Server uses this path, for example, as a cache for files that the Data Navigator provides for downloading. The files stored her can be huge and there can be a lot of them, depending on how many users are using the Data Navigator Export functionality and not cleaning up the Data Navigator download area. A huge local drive would be a good fit.

Dirk

[Pesmith8]

Hi Dirk,

Question about Resource Manager Tables.

When I setup this to send to MS SQL (Just to test out)  Found that it did not write tables holding the index tables.  It was more a table structure that  holds Task details.  

Does the Resource Manager or Information Audit Service write the index data to the Sql DB.

My small test, did not write the index tables to database pointed to the reference in Resource Manager or Information Audit Services.

What information will be written to the SQL tables for these Services?

Thanks again!

Paul

[EasyToDo · Accepted solution]

That's correct. Resource Manager and Information Audit Service does not write the index data to the Sql DB. This is a configuration which is set within the DataFinder itself.

Dirk