by The only thought that I have:
* Are you perform your daily backups during this time?
* Was there a program modification recently done?
* Do you have nested subroutines?
Just thoughts...
Grant
> We're seeing something really odd at a UniData site. If there's a lot
> of activity during the day, then from 12 AM to about 5 AM the
> following morning, everything grinds to a halt. Processes that
> normally finish in 10-15 seconds take hours. This doesn't happen
> every day, only on days that (in hindsight) were especially busy.
> There's nothing in the cron, no PHANTOMs running, nothing that we can
> see that could be causing this.
> of activity during the day, then from 12 AM to about 5 AM the
> following morning, everything grinds to a halt. Processes that
> normally finish in 10-15 seconds take hours. This doesn't happen
> every day, only on days that (in hindsight) were especially busy.
> There's nothing in the cron, no PHANTOMs running, nothing that we can
> see that could be causing this.
> They do have a big application running on that box (that we don't have
> the source code for), could it be some hidden TRANACTION COMMIT,
> ROLLBACK, etc. calls? If so, how could we identify this while it's
> happening?
> Ray
> --
> .=================================================================.
> | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= |
> | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- |
> |Midwest Regional Office: 815-547-0662 (voice) 503-905-8153 (eFax)|
> .=================================================================.