Skip to main content

Server Memory Size


This article is about changing memory size used by the Spotfire server java instance.
In most cases you will not need to modify it, however if you see issues around java process running out of memory, this may help
Quoted from Spotfire server installation manual



Modify the Virtual Memory. To set up the start script when not running as a Windows service:
==========================================================
1). Open the file <installation dir>/tomcat/bin/setenv.bat/.sh in a text editor, such as Notepad.

2). Locate the line that sets the variable JAVA_OPTS:
    set JAVA_OPTS=‐server ‐XX:+DisableExplicitGC ‐XX:MaxPermSize=256M ‐Xms512M ‐Xmx1536M
    or
    JAVA_OPTS="‐server ‐XX:+DisableExplicitGC ‐XX:MaxPermSize=256M ‐Xms512M ‐Xmx1536M".

3). Alter the -xms and the -Xmx values ‐Xms512M ‐Xmx1536M to the amount of memory you wish to allocate.

4). Save the file.

5). Restart the server.

To set up the start script when running as a Windows service:
=================================================
1). Stop the TIBCO Spotfire Server service.

2). Go to the <installation dir>/tomcat/bin directory.

3). Run the command: service.bat remove.

4). Edit the <installation dir>/tomcat/bin/service.bat file.

5). Look for the entries: ‐‐JvmMs 512 ‐‐JvmMx 1536 .

6). Alter 512 and/or 1536 to suitable memory values (in megabytes).

7). Run the command: service.bat install.

8) Start the TIBCO Spotfire Server service.

NOTE - For 32-bit Windows operating systems, spotfire  generally recommend never going above 1300M for the heap size.  If you set the value too high, the server will fail to start. Note that this is a Java/OS limitation - it has nothing to do with Spotfire.

For 64-bit, the highest tested size is 2048M.

Comments

Popular posts from this blog

Calendar Chart in Spotfire

I recently had a colleague asking me to show him the data in a calendar format.. Something like this I basically used a scatterplot for this.  You can check out the original DXP here  http://bit.ly/spotcalendar Some key settings to make it a calendar. Please note Order date is the date of interest here These expressions are out of the box expressions, no need to handcode them, but select them in the axis value  X Axis    <BinByDateTime([Order Date],"DayOfWeek",0)> Y Axis    Week([Order Date]) Trellis into panels   <BinByDateTime([Order Date],"Year.Quarter.Month",2)> Manual layout 4 X 3 Labels  UniqueConcatenate(DayOfMonth([Order Date])) Shape Tiled Markers Marker by   <UniqueConcatenate([Order Date])> Happy plotting your calendar!!!

Using Accordions in Spotfire Text Areas

Spotfire 6.0 provides great tools for quickly building your dashboard, but here we will learn to spice up things with the help of new 6.0 text area. If you are not aware the new 6.0 Text area supports HTML, Javascript and CSS. This opens up possibilities for doing a lot more with the text area. Some of the basic stuff can be seen here http://spotfire.tibco.com/qrt/UBSAN/presentation.html?pcode=100044   One of the cool things you can do is build an accordion panel in the text area for better utilization of the valuable screen real estate and helping the overall experience.(Watch the 0:15 second video below to see how accordion works - Sorry for the jitter in the video. The screen recorder does not record fast enough) Here is the html behind the text area : Please note that Spotfire controls are automatically created when you add text area controls, like filters, drop down lists etc. <DIV id="myaccordion"> <H3>Analysis Details</...

Spotfire Writing back to a database

Lot of time users need to write back to a database. Spotfire provides different ways to do this, Without going thru the code I am going to talk thru the different options available. But if you need detailed instructions, please leave some comments and will try to provide one 1) Stored Procedures. Advantages : Complex logic is easy to encapuslate in procedures. Also you are not storing username/passwords anywhere  Spotfire can execute stored procedures and these procedures could be fetching data, or can be procedures that can be run Pre or Post running a query. You can then use procedures that basically update your database table or even inserts new rows in tables. When using Spotfire information model it allows you to use these procedures which you can repurpose for updating your database. Spotfire also understands inputs to a procedure and they can be mapped to your marked rows/filtered rows/ properties/constants etc from your analytics. Steps to do that would be ...