{"id":4477,"date":"2024-08-27T12:33:55","date_gmt":"2024-08-27T12:33:55","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4477"},"modified":"2026-01-20T15:43:44","modified_gmt":"2026-01-20T15:43:44","slug":"memory-usage-and-ibm-planning-analytics","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/","title":{"rendered":"What Should I Know About Memory Usage in IBM Planning Analytics?"},"content":{"rendered":"

\"\"<\/p>\n

Memory Usage and IBM Planning Analytics<\/strong><\/p>\n

IBM Planning Analytics (PA) is an advanced analytics solution that uses an in-memory <\/strong>database architecture to produce real-time results. But what is<\/em> an in-memory database? An in-memory database (or IMBD) is on that stores data in the computer’s main memory<\/em>, instead of a hard disk drive, allowing faster response times because there is no need to access a disk to query or update data.<\/p>\n

How it Works:<\/p>\n

When a Planning Analytics (or TM1) database starts up, the TM1 server service (tm1sd.exe)\u00a0<\/strong>reads data, cubes, dimensions, and other system information\u00a0for a specific database from the disk and loads it into memory making it available to its users (note you will have a tm1sd.exe for each<\/em> Planning Analytics database that you have).<\/p>\n

The server service (tm1sd.exe) itself requires computer memory to run but the specific Planning Analytics database also consumes memory and, depending upon how complex the database is, it will naturally consume higher levels of memory (there are many other reasons that affect your database memory consumption, but note that a databases memory usage does not<\/em> relate to the size of its \u201cout of memory\u201d data files saved to disk).<\/p>\n

A helpful technote that explains that the memory consumed by the database is\u00a0not\u00a0<\/strong>the same as the memory consumed by the Windows process (tm1sd.exe) can be found here:<\/p>\n

https:\/\/www.ibm.com\/support\/pages\/memory-usage-value-inside-planning-analytics-administration-paa-website-seems-too-high-caused-misunderstanding-what-value-actually-measures<\/a><\/p>\n

During routine use of a Planning Analytics database, \u201cactions and events\u201d – views, calculations, and other types of processing will temporarily allocate additional memory, and, IBM reports, that Planning Analytics does not \u201crelease\u201d memory back to the operating system until the server is stopped or restarted, instead, it puts memory it no longer needs into a \u201cgarbage list\u201d (to be reused as required). Therefore, the memory consumption (for the TM1 server\/instance), as reported by the operating system, is the total of:<\/p>\n

Actual Current Memory In-Use + Garbage-Marked Memory<\/strong><\/p>\n

Checking on Memory using PAW<\/p>\n

IBM Planning Analytics Administration\u00a0includes the ability to monitor and administer your databases from the\u00a0Administration\u00a0page (note that you must be an administrator to see the Administration tile on the\u00a0Planning Analytics Workspace\u00a0home page and to use the\u00a0Administration\u00a0page). Open the\u00a0Administration\u00a0page by clicking the\u00a0Administration\u00a0tile on the\u00a0home\u00a0page, then click the Databases tile which will show the total number of databases in your environment, along with a status summary for all databases. From there you can click any database name on the Databases list to view details for the database, such as its \u201coverall heath\u201d which includes current memory consumption statistics.<\/p>\n

Another Option<\/p>\n

To get an accurate report of the actual memory usage and garbage memory, you can view the\u00a0}StatsForServer control cube<\/strong><\/a>, <\/strong>which tracks performance statistics for the server, including the number of cell updates, retrievals, view calculations, and retrievals for each connected client, active threads, and memory usage. The }StatsForServer control<\/p>\n

Cube is one of the performance monitoring control cubes<\/a> that you can enable.<\/p>\n

More Information<\/p>\n

For more information on the above information of if your ready for a deeper discussion on Planning Analytics memory consumption, contact QueBIT, we\u2019d ready to help!<\/p>\n","protected":false},"excerpt":{"rendered":"

Memory Usage and IBM Planning Analytics IBM Planning Analytics (PA) is an advanced analytics solution that uses an in-memory database architecture to produce real-time results. But what is an in-memory database? An in-memory database (or IMBD) is on that stores data in the computer’s main memory, instead of a hard disk drive, allowing faster response…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[108,51],"class_list":["post-4477","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-ibm-planning-analytics","tag-planning-analytics-how-tos"],"acf":[],"yoast_head":"\nWhat Should I Know About Memory Usage in IBM Planning Analytics? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What Should I Know About Memory Usage in IBM Planning Analytics? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Memory Usage and IBM Planning Analytics IBM Planning Analytics (PA) is an advanced analytics solution that uses an in-memory database architecture to produce real-time results. But what is an in-memory database? An in-memory database (or IMBD) is on that stores data in the computer’s main memory, instead of a hard disk drive, allowing faster response…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-27T12:33:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T15:43:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2024\/08\/KB-Post.png\" \/>\n\t<meta property=\"og:image:width\" content=\"891\" \/>\n\t<meta property=\"og:image:height\" content=\"507\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jennifer Field\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jennifer Field\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/\"},\"author\":{\"name\":\"Jennifer Field\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"headline\":\"What Should I Know About Memory Usage in IBM Planning Analytics?\",\"datePublished\":\"2024-08-27T12:33:55+00:00\",\"dateModified\":\"2026-01-20T15:43:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/\"},\"wordCount\":547,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/KB-Post.png\",\"keywords\":[\"IBM Planning Analytics\",\"Planning Analytics How To's\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/\",\"name\":\"What Should I Know About Memory Usage in IBM Planning Analytics? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/KB-Post.png\",\"datePublished\":\"2024-08-27T12:33:55+00:00\",\"dateModified\":\"2026-01-20T15:43:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/KB-Post.png\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/KB-Post.png\",\"width\":891,\"height\":507},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/memory-usage-and-ibm-planning-analytics\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What Should I Know About Memory Usage in IBM Planning Analytics?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\",\"name\":\"Jennifer Field\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"caption\":\"Jennifer Field\"},\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/quebit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What Should I Know About Memory Usage in IBM Planning Analytics? - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/","og_locale":"en_US","og_type":"article","og_title":"What Should I Know About Memory Usage in IBM Planning Analytics? - QueBIT","og_description":"Memory Usage and IBM Planning Analytics IBM Planning Analytics (PA) is an advanced analytics solution that uses an in-memory database architecture to produce real-time results. But what is an in-memory database? An in-memory database (or IMBD) is on that stores data in the computer’s main memory, instead of a hard disk drive, allowing faster response…","og_url":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/","og_site_name":"QueBIT","article_published_time":"2024-08-27T12:33:55+00:00","article_modified_time":"2026-01-20T15:43:44+00:00","og_image":[{"width":891,"height":507,"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2024\/08\/KB-Post.png","type":"image\/png"}],"author":"Jennifer Field","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jennifer Field","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/"},"author":{"name":"Jennifer Field","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"headline":"What Should I Know About Memory Usage in IBM Planning Analytics?","datePublished":"2024-08-27T12:33:55+00:00","dateModified":"2026-01-20T15:43:44+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/"},"wordCount":547,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2024\/08\/KB-Post.png","keywords":["IBM Planning Analytics","Planning Analytics How To's"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/","url":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/","name":"What Should I Know About Memory Usage in IBM Planning Analytics? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2024\/08\/KB-Post.png","datePublished":"2024-08-27T12:33:55+00:00","dateModified":"2026-01-20T15:43:44+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2024\/08\/KB-Post.png","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2024\/08\/KB-Post.png","width":891,"height":507},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/memory-usage-and-ibm-planning-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"What Should I Know About Memory Usage in IBM Planning Analytics?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601","name":"Jennifer Field","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","caption":"Jennifer Field"},"url":"https:\/\/quebit.com\/askquebit\/author\/quebit\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=4477"}],"version-history":[{"count":4,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4477\/revisions"}],"predecessor-version":[{"id":5058,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4477\/revisions\/5058"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=4477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=4477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=4477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}