J
James Palmer
Guest
Progress 10.2B08 on WIndows Server 2008 R2. This is a client server. They have a very perplexing issue that rears its head regularly, but not regularly enough to obviously be related to anything on a schedule. The client receives EDI files that are processed into the database automatically by a batch process. On the whole these take a couple of minutes max to process, but at times they suddenly start taking 10 minutes + to process. There's nothing different about the actual files. Unfortunately they're in a pressure situation where unprocessed files cost money as it delays orders going out/in. As a result their sys admin (a third party unfortunately) is rather trigger happy and likes to reboot the server ASAP. This sorts the problems out short term, but it means I can't easily see what is hammering the server at the time of the issues. I've managed to identify that the disk the databases are running on performs ok, but the C drive has very slow writes (21 seconds for the bigrow test). Personally I suspect this may well be a big part of the issue as the temp files and so on reside here. There are no long running transactions at the time of the problems, other than the EDI importer itself, and they are usually around 2-3 minutes long when problems are occurring. I take this to be a symptom rather than a cause. I would ideally like to be able to track what's going on on the server so that if the sysadmin reboots I can still get some sort of snapshot. The issue is, I am not allowed to install any products on the server - that includes tools like Protop (sorry Tom). Does anyone have any thoughts on what I can do to try and track the issues better. I've told the sysadmin that I need to see the server before he reboots but he's getting it in the neck from the client. All a bit of a mess.
Continue reading...
Continue reading...