Gone days, where we had no control/alerts mechanism on the TM1 database, CPU/memory it consumes, react at the nick of the moment before TM1 server crashes.
I am sure all TM1 lovers, administrators and business users who had these experiences in the past would connect to what I am referring to. For all new Planning Analytics users, in earlier versions of TM1/ Planning Analytics, we had little overview on how much on RAM/ memory can a TM1 instance use/utilize or have an inbuilt alter mechanism.
TM1 Database Alert Mechanism:
Most of you know, TM1 Server loves memory/RAM, more memory available the better performance/processing you get. Due to the trade-off between the cost and memory availability, there has always been a cap on upper limit on RAM available to TM1 Server.
What is new:
We now have an inbuilt mechanism in Planning Analytics Workspace, wherein we can set certain configuration and look for alters at a different level.
Administrators can now set, database threshold and alter configurations in a single tab on the Database settings page for the individual database in Planning Analytics Administration.
Isn’t that the good news! To use this, Planning Analytics Workspace version must be 2.0.46 or higher. In the previous version of Planning Analytics Administration, it was not possible to apply unique settings for each database, thresholds and alerts were set on separate tabs of a configuration page, but settings were applied to all databases in the environment.
For database settings, go to the Administration page, click Database as shown below.
Click on settings (highlighted), Database Setting, move to Thresholds and alerts.
The administrator can enter values for Warning threshold and Critical threshold and enable alert as different resource usages, as shown below.
The administrator can also set thread auto-refresh time interval.
Wonderful, now you can implement these in your environment, any doubts – we are here to help you for sure! Contact us today to find out how we can help you leverage your data for true business intelligence.
You may also like reading “ Predictive & Prescriptive-Analytics ” , “ Business-intelligence vs Business-Analytics ” ,“ What is IBM Planning Analytics Local ” , “IBM TM1 10.2 vs IBM Planning Analytics”, “Little known TM1 Feature - Ad hoc Consolidations”, “IBM PA Workspace Installation & Benefits for Windows 2016”.
Octane Software Solutions Pty Ltd is an IBM Registered Business Partner specialising in Corporate Performance Management and Business Intelligence. We provide our clients with advice on best practices and help scale up applications to optimise their return on investment. Our key services include Consulting, Delivery, Support and Training. Octane has its head office in Sydney, Australia as well as offices in Canberra, Bangalore, Gurgaon, Mumbai, and Hyderabad.