I just want to know your views regarding this subject.
Currently, we have a BI Runtime 10.2 running in our Cognos server. Together with it, are the TM1 10.2 application and the different instances. So it's BI Runtime and TM1 in one server. Our content store is an Oracle database residing in a separate server dedicated in housing other transactional databases (mostly huge). But both server machines are in the same building. It's been our set-up for like a year.
There already are running applications in that Cognos server (published Views and Excel reports).
Then users started to encounter long waiting time during login, specifically in TM1 Web. We use CAM authentication by the way, IntegratedSecurityMode=5. At first, users just waited until they got logged-in successfully, until recently when it became so frequent and the waiting time took longer. Then came the point when TM1 web prompted an error (see attached) to users.
So we investigated and found out that there have been connection disruptions between our Cognos server (Content Manager) and the Content Store server. We verified that the credentials used to connect to the Content Store still works. The password has no expiry.
Looking at the log file, the warning message above repeated in a certain interval until the connection went back on. We have established that there really were disruptions between the two machines. Our DBA mentioned that if the database server is experiencing heavy processing of data and is consuming lots of memory in the server, another server that tries to connect to a database inside, might get blocked or might experience a long waiting time.Excerpt from cogserver.log file
10.83.144.178:9300 9080 2014-03-04 11:12:07.321 +8 null M2Cddwqs9vwv8hswdd92qCGvjshsyd42s8yM2dqd http-9300-2 CM 1003 1 Audit.RTUsage.cms.CM Warning CM-SYS-5003 Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.
We came up to the idea of putting an Oracle database that will serve as the Content Store for our Cognos server, in that same machine so that no disruption would happen anymore.
There will be no more separate Content Store server to depend to.Understanding that MTQ (Multi-threaded Queries) should be used for best performance, utilizing much CPU power. Will the content store database suffer in this set-up as it may/will not get access to sufficient CPU and/or RAM to respond ?
Are there disadvantages and advantages (benefits) in this kind of set-up ?
Thanks very much.
Art