Hi there,
A client of mine is suddenly have issues with speed when drilling down to Sales Orders in SAP Business One. They are on version 2007A SP00 PL 45 and have been on a new High spec server for several months now and only the last few weeks have things been slow on SAP.
Some of the drill downs are quick to respond and then some take 12 seconds or more to open. It has gone from 1 second to 12 seconds and with the amount of work the Sales department needs to get through this is hugely inconvenient. We have tried turning the Antivirus software off and it made no difference, the SQL process uses 3.5 Gig which seems alot but when there are 16Gig's RAM available it shouldn't affect the speed of SAP.
Is there a SQL query I can rung against the database to check that it is working properly? They do have quite a few UDF's, formatted searches etc. The DB size is around 6.7 Gig, I shrinked the database and still no luck. They are running a few Add-ons, but even with them off it is still slow.
Any ideas?
Regards
Clayton.