1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Performance Issue - During Month End Activities

Tuesday, 02 October 2012 11:01

Written by Prakash Palani

Print E-mail

In one of our production system, we encountered a massive performance issue primarily due to database request time. In MSSQL, it is written in every Microsoft/SAP articles that the statistics will be updated automatically  and there is not a need for manual execution.   But in case of an ECC system, during the month end activities, we could see potential performance issues especially with the tables related to financial data, in most of the cases, we will run the update statistics manually which in turn will increase the performance.

Recently, had an opportunity to look at few OSS notes which indicated a similar issue and with an appropriate solution to overcome the same, please refer to 1747875 and 1558087 to schedule an update statistics only for specific set of tables. Hope this article helps you with overcoming the month end performance issues.

Performance Issue - During Month End Activities