Monday, 6 October 2014
Business Monitor and Cognos performance problem
Recently we have been seeing some issues with our Business Monitor servers on start up. After running IBM Business Monitor 7.5.1 for over a year, every time we restarted the environment there was a spike in CPU consumption that lasted for over half an hour.
On closer inspection it was the cognos process spawned by Monitor that was consuming all this CPU. A quick call to IBM support pointed us at the NC tables used by cognos. A few of our tables had over half a million rows, where as the following document suggestes anything over 1000 could impact performance:
http://www-01.ibm.com/support/docview.wss?uid=swg21637944
So we followed the steps in the technote and cleared down the NC tables and all of a sudden there was no issue following the next restart.
We have been keeping an eye on these tables since then and noticed they do continue to grow. Further questions to IBM support suggest this is normal behavior as long as there is no rapid increase in the size of the tables. It just means every now and then we may have to clear down these tables again.
Subscribe to:
Post Comments (Atom)
This comment has been removed by a blog administrator.
ReplyDeleteWebsphere admin --- "
ReplyDeleteWebsphere admin Online Training
Send ur Enquiry to contact@21cssindia.com
Introduction
Presentation – Oriented (Standalone)
Service Oriented
Client/Server Application
Client/Server VS Web Application" more… Online Training- Corporate Training- IT Support U Can Reach Us On +917386622889 - +919000444287 http://www.21cssindia.com/courses/websphere-admin-online-training-75.html
Thanks for nice topic. Very useful information.
ReplyDeleteCognos Online Training are good in giving the cognos nlineTraining
Thanks for nice topic. Very useful information.
ReplyDeleteWe Ithub Online Training are good in giving the CognosOnlineTraining
Hi,
ReplyDeleteThe bigger issue that we need to concern ourselves with is whether or not we have the need for an email database in order to become effective IBM Websphere Email Database in our email marketing