We're on SQL. A therapeutic reboot solved the problem.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of markewhittaker
Sent: Thursday, January 27, 2011 10:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Suddenly Long MRP Run Time
Are there a lot of engineering changes to methods being made on parts in
that company code? Or has there recently been a change in some of the
planning parameters of parts, such as days of supply? Those can cause
the mrp process to work harder. Also, did you recently truncate your
.bi file? If you truncate the .bi file and don't use a BIGROW option to
expand it, once the default space for the .bi file is used up, the
database has to format additional space for the .bi file to use as it
grows, which slows things down. MRP is very intensive in writing to the
.bi file.
--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...>
wrote:
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of markewhittaker
Sent: Thursday, January 27, 2011 10:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Suddenly Long MRP Run Time
Are there a lot of engineering changes to methods being made on parts in
that company code? Or has there recently been a change in some of the
planning parameters of parts, such as days of supply? Those can cause
the mrp process to work harder. Also, did you recently truncate your
.bi file? If you truncate the .bi file and don't use a BIGROW option to
expand it, once the default space for the .bi file is used up, the
database has to format additional space for the .bi file to use as it
grows, which slows things down. MRP is very intensive in writing to the
.bi file.
--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...>
wrote:
>way
> Typically MRP for one of our companies takes 3.5 hours to run. Last
> night suddenly it took 8 hours.
>
>
>
> One thing we notice is that the amount of non-scheduling time went
> up:/
>
>
>
> 08:00:17 MRP process 101 done. Total Non Scheduling Time = 05:01:15.
> Scheduled Jobs: 3132 Deleted Jobs: 2399 Save Load Jobs: 1931
>
>
>
> Vs
>
>
>
> 03:28:10 MRP process 101 done. Total Non Scheduling Time = 01:16:10.
> Scheduled Jobs: 3143 Deleted Jobs: 1553 Save Load Jobs: 1545
>
>
>
> We're not aware of any obvious changes, and the server didn't appear
> to be having any difficulty. The Vantage logs are clean, the server
> didn't appear to be especially busy doing other stuff, etc.
>
>
>
> What might be going on here?
>
>
>
> -bws
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
> Picometrix------------------------------------
>
> bspolarich@...
> <mailto:bspolarich@...> ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links