How to determine size of a specific analysis file from the Spotfire Server database or Action Logs database

How to determine size of a specific analysis file from the Spotfire Server application database or Action Logs database.

This is one technique to help you determine the size of an analysis file by using the Spotfire Server application database or the Action Logs database. Note that this is not the amount of RAM required when the report is opened, but instead the size of the .dxp file itself as stored in the Spotfire Library.

You can query the Spotfire Server application database with a query like this one:

select CONTENT_SIZE from lib_items where ITEM_ID='<GUID of dxp file>'

or 

select CONTENT_SIZE from lib_items where TITLE='<dxp name>' and item_type='4f83cd47-71b5-11dd-050e-00100a64217d'

Where <dxp name> is updated with the name of the analysis file and <GUID of dxp file> is updated with the unique GUID of the analysis file you are investigating.

For example:

select CONTENT_SIZE from lib_items where ITEM_ID='a5e48046-75b5-4f30-bc50-22a87fc218bc'

or:

select CONTENT_SIZE from lib_items where TITLE='My Baseball dxp' and item_type='4f83cd47-71b5-11dd-050e-00100a64217d'

Alternatively, if the Action Logs are enabled (see references), you can run this query against the Action Log database to get the size of an analysis file which has been opened from the library:

select ARG3 AS analysissize from [dbo].[ACTIONLOG] where [LOG_CATEGORY]='library' AND [LOG_ACTION]='load_content' AND [ID2]='<Librarypath>';

Where <Librarypath> is updated with the path to the analysis file you are investigating. For example:

select ARG3 AS analysissize from [dbo].[ACTIONLOG] where [LOG_CATEGORY]='library' AND [LOG_ACTION]='load_content' AND [ID2]='/Spotfire/Test_Java_Script';

Note: These sizes are recorded in bytes, so when you compare it against with the library size in the Spotfire Analyst ensure to convert into Kilobytes/Megabytes as needed.

Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration.  It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.

Documentation Reference: Action logs and system monitoring:

• https://docs.tibco.com/pub/spotfire_server/14.0.3/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/action_logs_and_system_monitoring.html

Documentation Reference: Action Log properties:

• https://docs.tibco.com/pub/spotfire_server/14.0.3/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/action_log_properties.html

Documentation Reference: Action log entries:

• https://docs.tibco.com/pub/spotfire_server/14.0.3/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/action_log_entries.html