Bad performance after an upgrade
We recently performed a test upgrade from R/3 to ECC 6.0. The new system has very bad performance. We have our systems on Windows with SQL Server 2005. The CI, DB and AI all exist on different servers with 10GB RAM each. The lastest statistics that we got for st03n are:
Dialog Response Time: Avg Proc Time:1394.7 ms
DB Time: 1122.4 ms
Roll Wait Time: 163.4 ms.
This is when there is hardly any activity going on in the system.
Also in Rz20
>CCMS Monitor Templates>Performance Overview--> I see the response time and DB time in red. Rest all green.
Is this a DB problem? Please suggest.