sp22_x1 and performance

thejdofva

Member
Hi all,

Just installed Sp22_x1 and my HR department is ready to kill me. They are running payroll and wht took 15 minutes is taking more then an hour. One of the report they run is R05229.

Another user is trying to enter a voucher and it takes long time when they hit ok button.

Any idea whts going on here.....

-J
Xe sp22_x1, Windows 2000, SQL2000
 
What SQL service pack level are you on? I would recommend upgrading to sp3a. We had a problem with report slowdown upon implementing update 7 / sp22 S1 that turned out to be related to MDAC and was fixed by MDAC 2.71a, which is part of SQL service pack sp3a.
 
Back
Top