That's just it. The Epicor Server has 4 quad core processors, 64GB of
RAM, Server 2008 R2 SP1, and all Epicor related files are stored on a
Fusion IO drive.
Nothing is maxed out on either the Epicor server or 32 bit admin.
The 32 bit admin is running 1 quad core processor, 4GB RAM, Server 2003
SP2, regular spin drives.
Epicor just recommended trying one of two things, either a dump and load
to see if that helps or run everything on a 32 bit machine with SSD
drives.
I'll try the dump and load but the other option seems extreme based on
my serve specs.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Monday, February 04, 2013 5:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DB Conversion Time
Alternatively, disk speed is a really big factor, if you have a desktop
with
a SSD in it, you can do a 32-bit install locally there, and run the
processes much much faster, same with a RAM drive if you have the
available
RAM on a server to put everything into RAM.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Joe Rojas
Sent: Monday, February 04, 2013 5:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DB Conversion Time
Hi Ned,
You helped me before the last time I tried this several months ago.
My Mm is set to 4096 and the Bt is set to 4096.
I will try bumping up the Bt on the next test.
It's still running. It's been 7 hours. Ugh!
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ned
Sent: Monday, February 04, 2013 4:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DB Conversion Time
Joe, that is way excessive. If I remember correctly, you are running a
progress SB. I don't think the schema changes move any data, that's what
the
conversions are for, but it should be a lot faster than that. I would
check
the .pf you are using to run the schema change, if you are running
default
then you can speed it up by upping the -Mm to 4096 and upping the -Bt to
16384 to give the process plenty of space in RAM and shrink down the
number
of messages that need to bounce back and forth.
I have never run schema changes that tool more than 5 hours to run for a
jump version like that. I did an update this past weekend and the schema
changes took 2.5 hours for 9.04.5xx to 9.05.700 which is the same jump
you
are trying to get to. That was only a 3GB DB, but still, your's sounds
way
off from what it should be.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and
beautiful matting and flooring
This message is intended only for the individual named. If you are not
the
named addressee you should not disseminate, distribute or copy this
e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in
this
email are solely those of the author and do not necessarily represent
those
of the company.
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Joe Rojas
Sent: Monday, February 04, 2013 3:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DB Conversion Time
Hi All,
We are converting our DB from 9.04.507a to 9.05.701
I'm at the first DB conversion step of running the schema change.
I ran this from the Epicor server, which is 64 bit, because I didn't see
anything calling out that this step must be run from the 32 bit admin
workstation. It took 60 hours to complete against a 10GB database.
Epicor support says that is must be run from a 32 bit admin workstation
so
I'm running the schema change again to see what happens.
It's been 5 hours now and it's still running. I can see that
prowin32.exe is
working and the Schema Upgrade window is whited out.
I'm just wondering what others have experienced for schema upgrade
times.
I know at this pace, the database conversions are going to take days!
The major problem with this is that when it's time to cutover, I'm only
going to have a weekend to do this conversion.
My Epicor server specs are pretty high and both the admin workstation
and
the Epicor server are not maxing out.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and
beautiful matting and flooring
This message is intended only for the individual named. If you are not
the
named addressee you should not disseminate, distribute or copy this
e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in
this
email are solely those of the author and do not necessarily represent
those
of the company.
[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/>
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]
------------------------------------
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]
RAM, Server 2008 R2 SP1, and all Epicor related files are stored on a
Fusion IO drive.
Nothing is maxed out on either the Epicor server or 32 bit admin.
The 32 bit admin is running 1 quad core processor, 4GB RAM, Server 2003
SP2, regular spin drives.
Epicor just recommended trying one of two things, either a dump and load
to see if that helps or run everything on a 32 bit machine with SSD
drives.
I'll try the dump and load but the other option seems extreme based on
my serve specs.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Monday, February 04, 2013 5:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DB Conversion Time
Alternatively, disk speed is a really big factor, if you have a desktop
with
a SSD in it, you can do a 32-bit install locally there, and run the
processes much much faster, same with a RAM drive if you have the
available
RAM on a server to put everything into RAM.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Joe Rojas
Sent: Monday, February 04, 2013 5:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DB Conversion Time
Hi Ned,
You helped me before the last time I tried this several months ago.
My Mm is set to 4096 and the Bt is set to 4096.
I will try bumping up the Bt on the next test.
It's still running. It's been 7 hours. Ugh!
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ned
Sent: Monday, February 04, 2013 4:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DB Conversion Time
Joe, that is way excessive. If I remember correctly, you are running a
progress SB. I don't think the schema changes move any data, that's what
the
conversions are for, but it should be a lot faster than that. I would
check
the .pf you are using to run the schema change, if you are running
default
then you can speed it up by upping the -Mm to 4096 and upping the -Bt to
16384 to give the process plenty of space in RAM and shrink down the
number
of messages that need to bounce back and forth.
I have never run schema changes that tool more than 5 hours to run for a
jump version like that. I did an update this past weekend and the schema
changes took 2.5 hours for 9.04.5xx to 9.05.700 which is the same jump
you
are trying to get to. That was only a 3GB DB, but still, your's sounds
way
off from what it should be.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and
beautiful matting and flooring
This message is intended only for the individual named. If you are not
the
named addressee you should not disseminate, distribute or copy this
e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in
this
email are solely those of the author and do not necessarily represent
those
of the company.
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Joe Rojas
Sent: Monday, February 04, 2013 3:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DB Conversion Time
Hi All,
We are converting our DB from 9.04.507a to 9.05.701
I'm at the first DB conversion step of running the schema change.
I ran this from the Epicor server, which is 64 bit, because I didn't see
anything calling out that this step must be run from the 32 bit admin
workstation. It took 60 hours to complete against a 10GB database.
Epicor support says that is must be run from a 32 bit admin workstation
so
I'm running the schema change again to see what happens.
It's been 5 hours now and it's still running. I can see that
prowin32.exe is
working and the Schema Upgrade window is whited out.
I'm just wondering what others have experienced for schema upgrade
times.
I know at this pace, the database conversions are going to take days!
The major problem with this is that when it's time to cutover, I'm only
going to have a weekend to do this conversion.
My Epicor server specs are pretty high and both the admin workstation
and
the Epicor server are not maxing out.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and
beautiful matting and flooring
This message is intended only for the individual named. If you are not
the
named addressee you should not disseminate, distribute or copy this
e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in
this
email are solely those of the author and do not necessarily represent
those
of the company.
[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/>
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]
------------------------------------
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]