Database Conversion Speeds

The conversion is single threaded.



Michael





Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Toby Boogerd
Sent: Wednesday, August 08, 2007 12:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Database Conversion Speeds



We are in the process of converting 6.1 to 8.00
Our current database is about 10GB in size. We ran the schema change on
a new Dell server in 1 1/2 hours. We then started the database and ran
the 8.0 admin tool and entered in our licenses. From there it runs
another conversion which run a lot of progress scripts. When looking at
perfmon and task manager we noticed that it is only utilizing one
processor of eight and is maxing the one processor out. Does anyone know
of any settings or anything we can change to utilize our hardware and
other 7 processors? I have provided a link to the image showing the
conversion and performance.

http://www.bccmobile.com/images/ConversionPic.jpg


Toby Boogerd
Information Systems

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





[Non-text portions of this message have been removed]
We are in the process of converting 6.1 to 8.00
Our current database is about 10GB in size. We ran the schema change on
a new Dell server in 1 1/2 hours. We then started the database and ran
the 8.0 admin tool and entered in our licenses. From there it runs
another conversion which run a lot of progress scripts. When looking at
perfmon and task manager we noticed that it is only utilizing one
processor of eight and is maxing the one processor out. Does anyone know
of any settings or anything we can change to utilize our hardware and
other 7 processors? I have provided a link to the image showing the
conversion and performance.

http://www.bccmobile.com/images/ConversionPic.jpg






Toby Boogerd
Information Systems





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