Some processes in our PeopeSoft system are running extremely long after upgrading from SQLSERVER 2000 to SQLSERVER 2005 SP4. Processes that use to run in 15 minutes now take 4 hours to run. Some processes run in the same amount of time and don't seem to
be affected by the upgrade. When I examine the long running processes in Activity Monitor I see the wait type showing up as PAGEIOLATCH_SH. Any ideas as to what might be going on? Our SQLSERVER implementation is a standard install. What should we be looking
at to improve the situation?
View Complete Post