How often do you restart/reboot your Vantage server?

Chris,

I am not sure of your hardware but I have recently had a lot of issues with the app servers for Vantage slowing down the overall system too often. After several calls I have learned the following:

1) Bad BAQ or reports will drag down a system
2) Runaway/Hung processes

I felt a system should be able to run for a decent period of time w/o reboots or restarts..I may be old school but that is my belief.

I have learned from several support calls as of late that you need to monitor the PIDs that relate to the _proapsv.exe*32 of Vantage. Chances are they are the app servers that get hung and will effect system performance.

You can see them in the PET tool, DB app server, status, details. You should see requests for the suspicous PID/process change pretty often if the process is working normally. You will need to monitor them for a bit to get a feel for your particular system.

If any of those are running for more than say 60 minutes and taking constant excessive cpu cycles chances are good they are hosed..Again, that number is based on my hardware, you mileage may vary. I have dual quad 3.0Ghz with 16 gig of memory and RAID 10 Dell PE 2900 that is about 3 years old. For point of reference my MRP for the largest company takes 4 minutes to run)

One thing is certain, when you see these processes running for longer than expected you will see performance begin to take a hit and it just keeps taking performance down over a relatively short time.

It is normal for these processes to take up about 13%, my system, of cpu while they are processing requests from users but they should "free up" after a period of time and drop there cpu time and usage back to zero briefly. The average time for me is about 30 minutes before they free up for more requests. I know if I see one
running an hour chances are it has an issue.

So what do I do when I see them run longer?

I check the system monitor, all process display checked and search out the PID to ensure it is truly hung. (Also check the DB app server, status, detail to see if requests increment)
If I determine it's hung I kill it via task manager on the server..after trying to kill it from the user session..if possible. Sometimes the user can not kill it even though they initiated it...don't ask me why. ;)

If it(app server) is needed Vantage cranks it up again. Worse case the user running the process, BAQ or report will lose that.

It's been a long learning curve for me as I do not have the luxury of a dedicated DB person. I am a generalist and get to be bad at everything. ;)

I don't know if this is best practices or not but I am used to seeing DB servers run for months at a good performance level before a reboot.(SQL servers) I know there are memory leaks in Windows 2003 R2 and a reboot does some good from time to time.

I am aiming for at least a month for now and if my insight from Vantage tech support is correct I should be able to run it longer w/o going through kicking everyone off and rebooting more than once a month to start with. I know there are temp files that need to get cleaned out occassionaly but many are related to those runaway processes. My theory is if you can kill those early then the temp
files should stay small and managable.

The above is based on a couple deep conversation with some decent tech people I have engaged at Epicor..the above is my summation of those conversations.


Tom Bosko
Miner Enterprises


--- In vantage@yahoogroups.com, "tbmuzic" <tombosko@...> wrote:
>
> That does NOT seem right..that is too frequent.
>
> Tom
>
> --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> >
> > We used to have to kick everyone out of the system mid-day every 7-10 days
> > because the speed would be dramatically reduced and it would get to a point
> > where it wouldn't let us log in.
> >
> > 1- Each night we stop and start our Apps (our of hours) on a scheduled task.
> >
> > 2- Each weekend we stop the apps, stop the db, clear out any temp files, clear
> > out any old report .xml files (which can be upto 8GB each), defrag the server,
> > start the db, start the app.
> >
> > Since doing the above, we have never had any dramatic slow downs and we have
> > never had any situations where it wouldnt let us log in.
> >
> > I would recommend the above steps based on what we have found.
> >
> > It's interesting to hear that we were not alone with the issues.
> >
> > If you want any of the scripts, I will be happy to share them.
> >
> > Thanks.
> >
> >
> >
> >
> > ________________________________
> > From: tbmuzic <tombosko@>
> > To: vantage@yahoogroups.com
> > Sent: Wed, 1 September, 2010 16:59:17
> > Subject: [Vantage] How often do you restart/reboot your Vantage server?
> >
> > ÂÂ
> > Wondering what the consensus is. It seems I have to restart/reboot mine every 3
> > weeks before processes get "hung" or error messages like "Maximum number of
> > client connections has been reached." I've had multiple calls into Epicor and
> > they have gone over my system setting several times and are within their specs
> > for 100 full users and 100 MES users. I average 90 full and 60 MES with plenty
> > of reusable licenses available)
> > Yet still I am forced to restart the database during the middle of the day
> > occasionally to rid these issues. Very frustrating to say the least, they can
> > never really pinpoint why these issues keep reoccurring.
> >
> > So, do you schedule reboots/restarts of your Vantage servers/databases? If so
> > how often? Weekly? biweekly? Monthly?
> >
> > What is best practice here to keep the system up 99.99% w/o intraday issues?
> >
> > Thanks!
> >
> > Tom Bosko
> > Miner Enterprises
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Wondering what the consensus is. It seems I have to restart/reboot mine every 3 weeks before processes get "hung" or error messages like "Maximum number of client connections has been reached." I've had multiple calls into Epicor and they have gone over my system setting several times and are within their specs for 100 full users and 100 MES users. I average 90 full and 60 MES with plenty of reusable licenses available)
Yet still I am forced to restart the database during the middle of the day occasionally to rid these issues. Very frustrating to say the least, they can never really pinpoint why these issues keep reoccurring.

So, do you schedule reboots/restarts of your Vantage servers/databases? If so how often? Weekly? biweekly? Monthly?

What is best practice here to keep the system up 99.99% w/o intraday issues?



Thanks!

Tom Bosko
Miner Enterprises
I reboot about once a month to two months and we are a small shop (17
licenses).



But I do this just because they are Microsoft servers....if I had Linux
I probably wouldn't bother.







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of tbmuzic
Sent: Wednesday, September 01, 2010 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How often do you restart/reboot your Vantage server?





Wondering what the consensus is. It seems I have to restart/reboot mine
every 3 weeks before processes get "hung" or error messages like
"Maximum number of client connections has been reached." I've had
multiple calls into Epicor and they have gone over my system setting
several times and are within their specs for 100 full users and 100 MES
users. I average 90 full and 60 MES with plenty of reusable licenses
available)
Yet still I am forced to restart the database during the middle of the
day occasionally to rid these issues. Very frustrating to say the least,
they can never really pinpoint why these issues keep reoccurring.

So, do you schedule reboots/restarts of your Vantage servers/databases?
If so how often? Weekly? biweekly? Monthly?

What is best practice here to keep the system up 99.99% w/o intraday
issues?

Thanks!

Tom Bosko
Miner Enterprises





[Non-text portions of this message have been removed]
At least once / month. Diddo on Linnux.



Bruce B.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Wednesday, September 01, 2010 11:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How often do you restart/reboot your Vantage
server?





I reboot about once a month to two months and we are a small shop (17
licenses).

But I do this just because they are Microsoft servers....if I had Linux
I probably wouldn't bother.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa@... <mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of tbmuzic
Sent: Wednesday, September 01, 2010 10:59 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] How often do you restart/reboot your Vantage server?

Wondering what the consensus is. It seems I have to restart/reboot mine
every 3 weeks before processes get "hung" or error messages like
"Maximum number of client connections has been reached." I've had
multiple calls into Epicor and they have gone over my system setting
several times and are within their specs for 100 full users and 100 MES
users. I average 90 full and 60 MES with plenty of reusable licenses
available)
Yet still I am forced to restart the database during the middle of the
day occasionally to rid these issues. Very frustrating to say the least,
they can never really pinpoint why these issues keep reoccurring.

So, do you schedule reboots/restarts of your Vantage servers/databases?
If so how often? Weekly? biweekly? Monthly?

What is best practice here to keep the system up 99.99% w/o intraday
issues?

Thanks!

Tom Bosko
Miner Enterprises

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
8.03.408B on MSSQL 2005, Server 2003 x64.

I never reboot/restart/etc. *except* that I restart my
MfgSys803ProcessServer and MfgSys803TaskAgent daily. I do this to keep
MultiCompany from breaking (at least in .405 it would stop randomly).

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Butler, Bruce
Sent: Wednesday, September 01, 2010 12:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How often do you restart/reboot your Vantage
server?

At least once / month. Diddo on Linnux.



Bruce B.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Wednesday, September 01, 2010 11:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How often do you restart/reboot your Vantage
server?





I reboot about once a month to two months and we are a small shop (17
licenses).

But I do this just because they are Microsoft servers....if I had Linux
I probably wouldn't bother.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa@... <mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of tbmuzic
Sent: Wednesday, September 01, 2010 10:59 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] How often do you restart/reboot your Vantage server?

Wondering what the consensus is. It seems I have to restart/reboot mine
every 3 weeks before processes get "hung" or error messages like
"Maximum number of client connections has been reached." I've had
multiple calls into Epicor and they have gone over my system setting
several times and are within their specs for 100 full users and 100 MES
users. I average 90 full and 60 MES with plenty of reusable licenses
available)
Yet still I am forced to restart the database during the middle of the
day occasionally to rid these issues. Very frustrating to say the least,
they can never really pinpoint why these issues keep reoccurring.

So, do you schedule reboots/restarts of your Vantage servers/databases?
If so how often? Weekly? biweekly? Monthly?

What is best practice here to keep the system up 99.99% w/o intraday
issues?

Thanks!

Tom Bosko
Miner Enterprises

[Non-text portions of this message have been removed]





[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
8.03.409a 30 users + 15 mes stations, we don't restart the computer
itself but typically restart the vantage database, process server and
task agent every Friday at noon. It doesn't always need it but there
seem to be less unexpected restart requirements if we schedule them.



Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Wednesday, September 01, 2010 11:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How often do you restart/reboot your Vantage
server?





8.03.408B on MSSQL 2005, Server 2003 x64.

I never reboot/restart/etc. *except* that I restart my
MfgSys803ProcessServer and MfgSys803TaskAgent daily. I do this to keep
MultiCompany from breaking (at least in .405 it would stop randomly).

-bws

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Butler, Bruce
Sent: Wednesday, September 01, 2010 12:51 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] How often do you restart/reboot your Vantage
server?

At least once / month. Diddo on Linnux.

Bruce B.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Wednesday, September 01, 2010 11:10 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] How often do you restart/reboot your Vantage
server?

I reboot about once a month to two months and we are a small shop (17
licenses).

But I do this just because they are Microsoft servers....if I had Linux
I probably wouldn't bother.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of tbmuzic
Sent: Wednesday, September 01, 2010 10:59 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] How often do you restart/reboot your Vantage server?

Wondering what the consensus is. It seems I have to restart/reboot mine
every 3 weeks before processes get "hung" or error messages like
"Maximum number of client connections has been reached." I've had
multiple calls into Epicor and they have gone over my system setting
several times and are within their specs for 100 full users and 100 MES
users. I average 90 full and 60 MES with plenty of reusable licenses
available)
Yet still I am forced to restart the database during the middle of the
day occasionally to rid these issues. Very frustrating to say the least,
they can never really pinpoint why these issues keep reoccurring.

So, do you schedule reboots/restarts of your Vantage servers/databases?
If so how often? Weekly? biweekly? Monthly?

What is best practice here to keep the system up 99.99% w/o intraday
issues?

Thanks!

Tom Bosko
Miner Enterprises

[Non-text portions of this message have been removed]

[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/.
<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





[Non-text portions of this message have been removed]
Similar to what Brian said, except I never restart for Vantage issues. I only restart when Windows needs updating (probably once a month on average). Granted we are not multicompany, and verly light on the customization side. The only real process attached to system agent is BPM processor. We are 8.03.408B on SQL 2008 with 20 seats. I may be in the minority but we are very stable. On the client side, employees are instructed to shutdown at the end of the day, so daily restarts.
Cheers,
Jared

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> 8.03.408B on MSSQL 2005, Server 2003 x64.
>
> I never reboot/restart/etc. *except* that I restart my
> MfgSys803ProcessServer and MfgSys803TaskAgent daily. I do this to keep
> MultiCompany from breaking (at least in .405 it would stop randomly).
>
> -bws
We used to have to kick everyone out of the system mid-day every 7-10 days
because the speed would be dramatically reduced and it would get to a point
where it wouldn't let us log in.

1- Each night we stop and start our Apps (our of hours) on a scheduled task.

2- Each weekend we stop the apps, stop the db, clear out any temp files, clear
out any old report .xml files (which can be upto 8GB each), defrag the server,
start the db, start the app.

Since doing the above, we have never had any dramatic slow downs and we have
never had any situations where it wouldnt let us log in.

I would recommend the above steps based on what we have found.

It's interesting to hear that we were not alone with the issues.

If you want any of the scripts, I will be happy to share them.

Thanks.




________________________________
From: tbmuzic <tombosko@...>
To: vantage@yahoogroups.com
Sent: Wed, 1 September, 2010 16:59:17
Subject: [Vantage] How often do you restart/reboot your Vantage server?

Â
Wondering what the consensus is. It seems I have to restart/reboot mine every 3
weeks before processes get "hung" or error messages like "Maximum number of
client connections has been reached." I've had multiple calls into Epicor and
they have gone over my system setting several times and are within their specs
for 100 full users and 100 MES users. I average 90 full and 60 MES with plenty
of reusable licenses available)
Yet still I am forced to restart the database during the middle of the day
occasionally to rid these issues. Very frustrating to say the least, they can
never really pinpoint why these issues keep reoccurring.

So, do you schedule reboots/restarts of your Vantage servers/databases? If so
how often? Weekly? biweekly? Monthly?

What is best practice here to keep the system up 99.99% w/o intraday issues?

Thanks!

Tom Bosko
Miner Enterprises







[Non-text portions of this message have been removed]
We are on Windows 2003 server, but it was Progress that was causing the issues,
not Windows.




________________________________
From: "Butler, Bruce" <bbutler@...>
To: vantage@yahoogroups.com
Sent: Wed, 1 September, 2010 17:51:01
Subject: RE: [Vantage] How often do you restart/reboot your Vantage server?

Â
At least once / month. Diddo on Linnux.

Bruce B.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Wednesday, September 01, 2010 11:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How often do you restart/reboot your Vantage
server?

I reboot about once a month to two months and we are a small shop (17
licenses).

But I do this just because they are Microsoft servers....if I had Linux
I probably wouldn't bother.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa@... <mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of tbmuzic
Sent: Wednesday, September 01, 2010 10:59 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] How often do you restart/reboot your Vantage server?

Wondering what the consensus is. It seems I have to restart/reboot mine
every 3 weeks before processes get "hung" or error messages like
"Maximum number of client connections has been reached." I've had
multiple calls into Epicor and they have gone over my system setting
several times and are within their specs for 100 full users and 100 MES
users. I average 90 full and 60 MES with plenty of reusable licenses
available)
Yet still I am forced to restart the database during the middle of the
day occasionally to rid these issues. Very frustrating to say the least,
they can never really pinpoint why these issues keep reoccurring.

So, do you schedule reboots/restarts of your Vantage servers/databases?
If so how often? Weekly? biweekly? Monthly?

What is best practice here to keep the system up 99.99% w/o intraday
issues?

Thanks!

Tom Bosko
Miner Enterprises

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
I have 2 CentOS 5.2 Linux systems running Vantage 8.03.408B with progress. The one server was up for over 450 days until we reconfigured our rack and had to shut everything down. The other server is not been restarted in 582 days. The progress database hasn't been restarted since the upgrade to 408B I do have to restart the task agent and process server appservers sometimes when the global alert email process stops.

Tom Osen
HiRel Systems LLC


--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> We are on Windows 2003 server, but it was Progress that was causing the issues,
> not Windows.
>
>
>
>
> ________________________________
> From: "Butler, Bruce" <bbutler@...>
> To: vantage@yahoogroups.com
> Sent: Wed, 1 September, 2010 17:51:01
> Subject: RE: [Vantage] How often do you restart/reboot your Vantage server?
>
> ÂÂ
> At least once / month. Diddo on Linnux.
>
> Bruce B.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Manasa Reddy
> Sent: Wednesday, September 01, 2010 11:10 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] How often do you restart/reboot your Vantage
> server?
>
> I reboot about once a month to two months and we are a small shop (17
> licenses).
>
> But I do this just because they are Microsoft servers....if I had Linux
> I probably wouldn't bother.
>
> M. Manasa Reddy
>
> manasa@... <mailto:manasa%40weldcoa.com>
> <mailto:manasa@... <mailto:manasa%40weldcoa.com> >
>
> 800.852.2325
>
> 630.806.2000 ofc
>
> 630.806.2001 fax
>
> www.weldcoa.com
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of tbmuzic
> Sent: Wednesday, September 01, 2010 10:59 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] How often do you restart/reboot your Vantage server?
>
> Wondering what the consensus is. It seems I have to restart/reboot mine
> every 3 weeks before processes get "hung" or error messages like
> "Maximum number of client connections has been reached." I've had
> multiple calls into Epicor and they have gone over my system setting
> several times and are within their specs for 100 full users and 100 MES
> users. I average 90 full and 60 MES with plenty of reusable licenses
> available)
> Yet still I am forced to restart the database during the middle of the
> day occasionally to rid these issues. Very frustrating to say the least,
> they can never really pinpoint why these issues keep reoccurring.
>
> So, do you schedule reboots/restarts of your Vantage servers/databases?
> If so how often? Weekly? biweekly? Monthly?
>
> What is best practice here to keep the system up 99.99% w/o intraday
> issues?
>
> Thanks!
>
> Tom Bosko
> Miner Enterprises
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
That does NOT seem right..that is too frequent.

Tom

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> We used to have to kick everyone out of the system mid-day every 7-10 days
> because the speed would be dramatically reduced and it would get to a point
> where it wouldn't let us log in.
>
> 1- Each night we stop and start our Apps (our of hours) on a scheduled task.
>
> 2- Each weekend we stop the apps, stop the db, clear out any temp files, clear
> out any old report .xml files (which can be upto 8GB each), defrag the server,
> start the db, start the app.
>
> Since doing the above, we have never had any dramatic slow downs and we have
> never had any situations where it wouldnt let us log in.
>
> I would recommend the above steps based on what we have found.
>
> It's interesting to hear that we were not alone with the issues.
>
> If you want any of the scripts, I will be happy to share them.
>
> Thanks.
>
>
>
>
> ________________________________
> From: tbmuzic <tombosko@...>
> To: vantage@yahoogroups.com
> Sent: Wed, 1 September, 2010 16:59:17
> Subject: [Vantage] How often do you restart/reboot your Vantage server?
>
> ÂÂ
> Wondering what the consensus is. It seems I have to restart/reboot mine every 3
> weeks before processes get "hung" or error messages like "Maximum number of
> client connections has been reached." I've had multiple calls into Epicor and
> they have gone over my system setting several times and are within their specs
> for 100 full users and 100 MES users. I average 90 full and 60 MES with plenty
> of reusable licenses available)
> Yet still I am forced to restart the database during the middle of the day
> occasionally to rid these issues. Very frustrating to say the least, they can
> never really pinpoint why these issues keep reoccurring.
>
> So, do you schedule reboots/restarts of your Vantage servers/databases? If so
> how often? Weekly? biweekly? Monthly?
>
> What is best practice here to keep the system up 99.99% w/o intraday issues?
>
> Thanks!
>
> Tom Bosko
> Miner Enterprises
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>