I have a sql database and an application that runs on 2 different servers. These servers are running sql server 7 and are running the same version of the application.
One of the servers has started slowing down how long it was processing files, so we upped the amount of RAM from 2GB to 4GB, but this didn't help. All of the slow down occurs in the database as it goes through triggers to update tables.
It takes about 1.5 minutes for it to process a file (For reference, it takes the other server about 16 seconds to go through the same triggers and process a file).
I'm looking at the server that is taking forever and all of the metrics look good: There's enough ram (especially now that it's been upped to 4GB), the processor load is fine, etc etc.
Since it doesn't look like it's a resource issue and it's obviously not a trigger issue because both servers have exactly the same ones, I'm at a complete loss of what could be causing this...