Re-indexing Database in Vantage 8

system · March 29, 2006, 2:02pm

Missi,

We too are on Vantage version 8 and we experience daily app server
issues. Epicor has us forwarding our log files to them after each issue.
We have yet to resolve the problem.

Tom

________________________________

From: how2wow [mailto:mhow@...]
Sent: Wednesday, March 29, 2006 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Re-indexing Database in Vantage 8

Hi, Charles,

The IT director is going to check some more on whether or not the
memory might be the issue, but said he's already looked into that and
doesn't believe that is causing all the problems.

Epicor helped us "tweak" some settings last night, so we'll see what
happens today!

Thanks for the idea!

Missi

--- In vantage@yahoogroups.com, "Charles Paluska - HPN" <cpaluska@...>
wrote:

>
> Missi,
>
> What kind of diagnostics have you run on the server to verify proper
> hardware operations ?
>
> Alot of times flakey memory will cause a system to behave much like

yours

> seems to be.
>
> Charles
>
>

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/links

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

system · March 28, 2006, 3:24pm

Does anyone reindex their database on Vantage 8.00 on a regular
basis? If so, does this help with the speed and performance issue?

We have been struggling since our implementation on 9/1 on the
performance/speed/lock up issue. Epicor has had us try some different
things and has looked at a couple different issues, but nothing so far
has really helped. We are currently locking up and having to restart
the apps server and DB at least daily. We have 40 users on the system.

It has been determined that our hardware isn't the issue- the server
is much bigger than what was even needed. So, it seems to be either
disk contention or a data issue. We are looking for user info on the
reindexing of the data to see if that might be part of the problem.

Any info would be appreciated.

Missi How
Accounting Mgr.
ASV, Inc.

system · March 28, 2006, 4:07pm

Missi,

What kind of diagnostics have you run on the server to verify proper
hardware operations ?

Alot of times flakey memory will cause a system to behave much like yours
seems to be.

Charles

----- Original Message -----
From: "how2wow" <mhow@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, March 28, 2006 3:24 PM
Subject: [Vantage] Re-indexing Database in Vantage 8

> Does anyone reindex their database on Vantage 8.00 on a regular
> basis? If so, does this help with the speed and performance issue?
>
> We have been struggling since our implementation on 9/1 on the
> performance/speed/lock up issue. Epicor has had us try some different
> things and has looked at a couple different issues, but nothing so far
> has really helped. We are currently locking up and having to restart
> the apps server and DB at least daily. We have 40 users on the system.
>
>
> It has been determined that our hardware isn't the issue- the server
> is much bigger than what was even needed. So, it seems to be either
> disk contention or a data issue. We are looking for user info on the
> reindexing of the data to see if that might be part of the problem.
>
> Any info would be appreciated.
>
> Missi How
> Accounting Mgr.
> ASV, Inc.
>
>
>
>
>
>
>
> 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/links
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

system · March 28, 2006, 5:10pm

Yeah, I would agree with Charles if your server isn't equipped with
Registered ECC memory, I would take a serious look there.

Michael

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charles Paluska - HPN
Sent: Tuesday, March 28, 2006 1:07 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re-indexing Database in Vantage 8

Missi,

What kind of diagnostics have you run on the server to verify proper
hardware operations ?

Alot of times flakey memory will cause a system to behave much like yours
seems to be.

Charles

----- Original Message -----
From: "how2wow" <mhow@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, March 28, 2006 3:24 PM
Subject: [Vantage] Re-indexing Database in Vantage 8

> Does anyone reindex their database on Vantage 8.00 on a regular
> basis? If so, does this help with the speed and performance issue?
>
> We have been struggling since our implementation on 9/1 on the
> performance/speed/lock up issue. Epicor has had us try some different
> things and has looked at a couple different issues, but nothing so far
> has really helped. We are currently locking up and having to restart
> the apps server and DB at least daily. We have 40 users on the system.
>
>
> It has been determined that our hardware isn't the issue- the server
> is much bigger than what was even needed. So, it seems to be either
> disk contention or a data issue. We are looking for user info on the
> reindexing of the data to see if that might be part of the problem.
>
> Any info would be appreciated.
>
> Missi How
> Accounting Mgr.
> ASV, Inc.
>
>
>
>
>
>
>
> 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/links
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

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/links
Yahoo! Groups Links

system · March 29, 2006, 12:29pm

Hi, Charles,

The IT director is going to check some more on whether or not the
memory might be the issue, but said he's already looked into that and
doesn't believe that is causing all the problems.

Epicor helped us "tweak" some settings last night, so we'll see what
happens today!

Thanks for the idea!

Missi

--- In vantage@yahoogroups.com, "Charles Paluska - HPN" <cpaluska@...>
wrote:

>
> Missi,
>
> What kind of diagnostics have you run on the server to verify proper
> hardware operations ?
>
> Alot of times flakey memory will cause a system to behave much like

yours

> seems to be.
>
> Charles
>
>

system · March 29, 2006, 1:08pm

Hi Missi,

Just a suggestion - if your server has more memory than is being currently
used (task manager can display the memory usage) and the memory installed is
done in multiple "sticks" - then remove some (it might hurt performance -
but since it has been unstable and crashing anyway.....). So if you have
4gb of ram using 8 sticks (512mb each) - take 4 sticks out.

Also, be sure to check the memory is all the same type and speed. Mixed
memory can cause issues as well.

Also check for overheating !!!

Not knowing your server - remove as many "unnecessary" things as possible -
sound cards, modems, printers - any hardware that isn't being used. And
software - antivirus in the past was not recommended by Epicor to be running
on the Vantage server (might be different with 8), your Vantage server
should be just that - not file and print or email or serving webpages.

We had a server that would crash during backup - never at any other time.
We replaced the tape drive, the hard drives, the controllers. It always
died while backing up the same folder. We moved the folder to another
server on the premise that perhaps there was file corruption that was
confusing the hardware - still died during backup. Finally, we were left
with "what's left?" We had more than enough memory installed in the box and
took some out - problem solved.

Good Luck,

Charles

----- Original Message -----
From: "how2wow" <mhow@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, March 29, 2006 12:26 PM
Subject: [Vantage] Re: Re-indexing Database in Vantage 8

> Hi, Charles,
>
> The IT director is going to check some more on whether or not the
> memory might be the issue, but said he's already looked into that and
> doesn't believe that is causing all the problems.
>
> Epicor helped us "tweak" some settings last night, so we'll see what
> happens today!
>
> Thanks for the idea!
>
> Missi
>
>
> --- In vantage@yahoogroups.com, "Charles Paluska - HPN" <cpaluska@...>
> wrote:
>>
>> Missi,
>>
>> What kind of diagnostics have you run on the server to verify proper
>> hardware operations ?
>>
>> Alot of times flakey memory will cause a system to behave much like
> yours
>> seems to be.
>>
>> Charles
>>
>>
>
>
>
>
>
>
> 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/links
> Yahoo! Groups Links
>
>
>
>
>
>
>
>