Company where this pilot fish works is having a bit of a problem with non-deterministic load times in the data warehouse. If the load runs normally, even with heavy volume, everything is done by about 9 a.m., which means management can see their reports just around the time they’re having their morning coffee.
But the load doesn’t always run normally. In fact, a system problem during the night can set things back by as much as six hours, which management finds unacceptable.
So various measures are taken to get the load to run in less time: Users are kicked off the system, priorities are rejiggered and so on.
Nothing works. The load processes just don’t seem to take advantage of the resources made available to them.
from Computerworld https://ift.tt/2zvNnsm
No comments:
Post a Comment