We have a customer experiencing very slow credit card authorizations for the
1st card of the day. After the swipe it can take serveral mins for the approval or it gets an error. All the credit card transactions following work fine. They use to reboot their register everyday. The register is also the SQLServer. I think I was able to isolated it to whenever the SQLServer services restart the problem also starts. As long as the SQLServer remains on overnight the 1st credit card of the day is fine. This occured using RMS 1.2 and RMS 2.0 with latest hotfixes. Also on MSDE200 and 2005 SQL Express. I purged the journals to only keep 2007 and beyond. Any ideas to resolve it?- posted
16 years ago