BGMS Restarting Continuesly & Publishing Queue are Stuck.

I'm using Windchill 11.1 M020 CPS 30.

Any Suggestions / Solution for below Issue

Case:CS54402 (2nd Point)

One or more transactions execute a large volume of SQL retrieving small numbers of rows each time, but cumulatively results in a large amount of Method Server memory being used

• A log file will show a series, usually dozens of 'StatementCache' lines like the one below for the SocketThread12 thread.
• The thread name will vary but will usually be named SocketThread##, RMI TCP Connection(###) or SimpleTaskDispatcher###.  'hits' in the line below is a rough estimate of the number of SQL statements sent to the database for processing
  • 'RMI TCP Connection': generally a user UI action
  • SimpleTaskDispatcher: often an EPM related operation
  • SocketThread: usually an InfoEngine task
• Example of output: [SocketThread12] wt.pom.statementCache - StatementCache: wt.util.Cache%618734817 [size=50, count=48, hits=239727, misses=84, aged=0]
  • If there an OutOfMemoryError generated in the log and thread which writes the stack matches the thread generating a large volume of StatementCache lines, the stack is often the root cause of the method server outage
  • A series of Thread dumps when the MethodServer is struggling with memory is very helpful in aiding the diagnosis of root cause (regardless of the suspected root cause)