Iodrives : RE: Vantage getting slower by the week

system · February 3, 2010, 4:56pm

Len,

Hope all is well, sorry for the delay, I was out for most of the day...

No the cards we're looking at are about 7K. They are the 160GB single versions, not the multi...

The single cell are 40 percent faster & more reliable.

Ron Flynn

Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

16770 West Victor Road

New Berlin, WI 53151

262.789.1966 xt. 124

262.789.1970 fax

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Wednesday, February 03, 2010 10:19 AM
To: vantage@yahoogroups.com
Subject: Iodrives : RE: [Vantage] Re: Vantage getting slower by the week.

Good Day Ron:

I could not come up with a good term for the Iodrive - Solid state
flash memory is good.

You may well be OK with that since one vendor said the Iodrive is
the equivalent of 100-500 "Spindles"; whereas a 24-disc Array is just 24
spindles.

Do the Iodrives still cost $15,000?

Len

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of IT Support
Sent: Tuesday, February 02, 2010 3:47 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

Len,

We currently only have a PE2900 @ 2x 2.0GHz with 24GB memory.

We are only a 30 user company, with 20 consistent users thru out the
day.

Vantage 803.408B is running quite well for us now (performance wise) &
we did a pretty good analysis of our server when we had the performance
issues.

After every test we did, no matter what time of day or how many users
were on the system, the only taxed part of the server was the disk IO.

I know we are not optimal in this area as well... we really should have
another RAID 10 volume, but things are running well.

We are considered a "small" Vantage customer I guess & separating
Progress off onto another server would be overkill for us.

When we move the R710, we will be gaining quite a bit; 1 thousand MHz
per CPU, the new 1333 memory architecture, the ioDrive, & 64bit server
OS.

The ioDrive is not SSD, but solid-state flash memory. It's really quite
impressive.

I guess if we are not satisfied after the move to 9.05 with that setup,
we'll just wait for 10.0 & try again... J

Ron Flynn

Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

16770 West Victor Road

New Berlin, WI 53151

262.789.1966 xt. 124

262.789.1970 fax

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 Len Hartka
Sent: Tuesday, February 02, 2010 1:40 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

Good Day Ron:

A R710?
For 75-100 users, we have three R710's plus a 24 drive array.
Of course, we did NOT get the iodrivecard - I assume that is the
"SSD unit" that plugs right into the PCI slot on the motherboard. I
know it as an IOmega device.

len.hartka@... <mailto:len.hartka%40sunautomation.com> <mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of IT Support
Sent: Tuesday, February 02, 2010 1:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

Charlie,

I never had the opportunity to attend that class, however even though it
was after the fact,

I attended the admin/performance class at Perspectives & that's all they
stated as well.

When we go to Epicor 9.05, we are going a different route yet again.

We will be going with a R710 maxed out and using a ioDrive160 card to
handle the DB's.

Due to 2009 being such a poor year, we were not able to make any
hardware improvements, but things are getting better to the point

That we do not want to make that mistake again in 2010 for Epicor 9.

A fellow group member brought up the card & after thorough conversations
with our consultants & ioFusion we feel for the money there isn't a
better solution.

1 caveat though is that the card is not currently bootable, so we will
have the OS on a RAID 1 volume & everything else on the card.

Ron Flynn

Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

16770 West Victor Road

New Berlin, WI 53151

262.789.1966 xt. 124

262.789.1970 fax

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Charlie Wilson
Sent: Tuesday, February 02, 2010 12:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

Depending on how many drives are in the array of a raid 10 you can
double
and quadrpel read and write rates. This is due to the fact that the raid
is
a stripe across multiple mirrors which means you can write a string
sectors
at once basically. There are 1000 and white paper reports about raid
configurations you can go read. But I can't believe that was epicors
recommendation. I went to the admin class and it was raid 10 raid 10
raid 10
I had to make sure it wasn't tattooed on me somewhere before I left.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
IT Support
Sent: Tuesday, February 02, 2010 1:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

I'm with Charlie if that's true...

We had severe performance issues & installed a RAID 10 volume for the
DB & have seen a much improved performance increase.

People actually comment on how well Vantage is running, which was NEVER
the case before.

We were only able to add a single 3x3 RAID 10 (15K Drives) due to
chassis limitations, otherwise I would have added a second set like
suggested for the transaction logs...

Also, our consultants did a very thorough tuning of the entire server...

We are a 30 user SQL environment.

Ron Flynn

Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

16770 West Victor Road

New Berlin, WI 53151

262.789.1966 xt. 124

262.789.1970 fax

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, February 02, 2010 11:53 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

And everything is on this raid 1?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
mmcwilliams22
Sent: Tuesday, February 02, 2010 12:42 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Vantage getting slower by the week.

Dual Xeon 2.8 with 4GB of RAM 15k disks
Windows 2003 Server
15 Shop Floor
25 Office users
Antivirus is ESET with all the recommended exlusions.
Volume shadow copy is not enabled.
Indexing is disabled.
I defragged the server on Sunday yet still have 60% file & 30% total.
Vantage is backed up at 2a, 6a, 10a, 4p & then also uploaded to an
offsite
location.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
Michael
Barry <mbarry@...> wrote:

>
> Sorry, I left out a couple of additional questions. How is your server

configured? I got the RAID 1 but what about CPU/RAM etc? How many
concurrent
users including shop floor? I'm assuming that you are running some
variant
of Windows Server so do you have things like volume shadow copy or the
indexing service running? Is there a periodic disk defragmenter or
online
backup process running?

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

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

>
> This email, and any attachments thereto, is intended only for use by

the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly
prohibited.
If you have received this email in error, please immediately notify me
by
telephone and permanently delete the original and any copy of any email
and
any printout thereof.

>
>
>
>
> On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:
>
> > Yes. The thing is that it is not only ODBC, it is the whole system.

A
user may be in AP invoice entry and all the sudden they start getting
"Not
Responding" and it takes a minute for a new line to appear and then 30
minutes later it is just cruising along. We are using 15k drives in RAID
1,
I am sure that has some to do with it. But will RAID 10 really make that
much of a difference & if that is the case then maybe SSD is really
worth
looking into. If I knew where to pinpoint I could throw the resources at
it.

> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Blake Clemens" <blake.clemens@> wrote:

> > >
> > > Is your DSN setup for "Read Uncommitted"?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf

> > > Of mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 12:00 PM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > 11.5.3
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com> ,

> > > "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > What version of Crystal are you using to design your reports?

I'm
not

> > > > talking about the Crystal version on each client machine.
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com> ] On

> > > Behalf
> > > > Of mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 408
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > What version of Vantage are you on?
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com> ] On
> > > > Behalf
> > > > > Of mmcwilliams22
> > > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Vantage getting slower by the week.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > I am working on increasing the performance of Vantage but

cannot

> > > seem
> > > > to
> > > > > find the bottleneck. At times when users are complainaing the

CPU

> > > > > utilization is at 1% on server and less than 3% on client.

Memory

> > > > usage
> > > > > is not a factor at all, we are not even close on the client &

the

> > > > server
> > > > > has about 1gig free room. I ran wireshark on the clients to

look
for

> > > > tcp
> > > > > retransmits or packet loss & no problems there. Some times an

ODBC

> > > > > report will take 10 seconds and then a few minutes later 3

minutes,

> > > > but
> > > > > I cannot pinpoint what is causing the performance issue.
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release

Date:

> > > > 02/02/10
> > > > > 02:35:00
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> > > 02:35:00
> > >
> > >
> > >
> > > [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]

[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]

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

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

system · February 2, 2010, 11:46am

I am working on increasing the performance of Vantage but cannot seem to find the bottleneck. At times when users are complainaing the CPU utilization is at 1% on server and less than 3% on client. Memory usage is not a factor at all, we are not even close on the client & the server has about 1gig free room. I ran wireshark on the clients to look for tcp retransmits or packet loss & no problems there. Some times an ODBC report will take 10 seconds and then a few minutes later 3 minutes, but I cannot pinpoint what is causing the performance issue.

system · February 2, 2010, 11:49am

What version of Vantage are you on?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mmcwilliams22
Sent: Tuesday, February 02, 2010 11:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage getting slower by the week.

I am working on increasing the performance of Vantage but cannot seem to
find the bottleneck. At times when users are complainaing the CPU
utilization is at 1% on server and less than 3% on client. Memory usage
is not a factor at all, we are not even close on the client & the server
has about 1gig free room. I ran wireshark on the clients to look for tcp
retransmits or packet loss & no problems there. Some times an ODBC
report will take 10 seconds and then a few minutes later 3 minutes, but
I cannot pinpoint what is causing the performance issue.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
02:35:00

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

system · February 2, 2010, 11:53am

408

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> What version of Vantage are you on?
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 11:43 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage getting slower by the week.
>
>
>
>
>
> I am working on increasing the performance of Vantage but cannot seem to
> find the bottleneck. At times when users are complainaing the CPU
> utilization is at 1% on server and less than 3% on client. Memory usage
> is not a factor at all, we are not even close on the client & the server
> has about 1gig free room. I ran wireshark on the clients to look for tcp
> retransmits or packet loss & no problems there. Some times an ODBC
> report will take 10 seconds and then a few minutes later 3 minutes, but
> I cannot pinpoint what is causing the performance issue.
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
> 02:35:00
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 2, 2010, 11:55am

What version of Crystal are you using to design your reports? I'm not
talking about the Crystal version on each client machine.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mmcwilliams22
Sent: Tuesday, February 02, 2010 11:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage getting slower by the week.

408

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Blake Clemens" <blake.clemens@...> wrote:

>
> What version of Vantage are you on?
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 11:43 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Vantage getting slower by the week.
>
>
>
>
>
> I am working on increasing the performance of Vantage but cannot seem

to

> find the bottleneck. At times when users are complainaing the CPU
> utilization is at 1% on server and less than 3% on client. Memory

usage

> is not a factor at all, we are not even close on the client & the

server

> has about 1gig free room. I ran wireshark on the clients to look for

tcp

> retransmits or packet loss & no problems there. Some times an ODBC
> report will take 10 seconds and then a few minutes later 3 minutes,

but

> I cannot pinpoint what is causing the performance issue.
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> 02:35:00
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
02:35:00

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

system · February 2, 2010, 11:59am

This is such a difficult question to answer.

Are you SQL?

If so, have you went through all the Performance tweaks on indexes, etc
that Epicor suggests?

Are you transaction heavy? PartTran can fill up quickly and if you have
clunky reports hitting that table it can be hit-or-miss.

Change Logs? Try to limit them as much as possible; especially on Jobs
if you run MRP.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mmcwilliams22
Sent: Tuesday, February 02, 2010 11:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage getting slower by the week.

408

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...>
wrote:

>
> What version of Vantage are you on?
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf

> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 11:43 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage getting slower by the week.
>
>
>
>
>
> I am working on increasing the performance of Vantage but cannot seem

to

> find the bottleneck. At times when users are complainaing the CPU
> utilization is at 1% on server and less than 3% on client. Memory

usage

> is not a factor at all, we are not even close on the client & the

server

> has about 1gig free room. I ran wireshark on the clients to look for

tcp

> retransmits or packet loss & no problems there. Some times an ODBC
> report will take 10 seconds and then a few minutes later 3 minutes,

but

> I cannot pinpoint what is causing the performance issue.
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> 02:35:00
>
>
>
> [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

system · February 2, 2010, 12:01pm

11.5.3

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> What version of Crystal are you using to design your reports? I'm not
> talking about the Crystal version on each client machine.
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 11:50 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> 408
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Blake Clemens" <blake.clemens@> wrote:
> >
> > What version of Vantage are you on?
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of mmcwilliams22
> > Sent: Tuesday, February 02, 2010 11:43 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Vantage getting slower by the week.
> >
> >
> >
> >
> >
> > I am working on increasing the performance of Vantage but cannot seem
> to
> > find the bottleneck. At times when users are complainaing the CPU
> > utilization is at 1% on server and less than 3% on client. Memory
> usage
> > is not a factor at all, we are not even close on the client & the
> server
> > has about 1gig free room. I ran wireshark on the clients to look for
> tcp
> > retransmits or packet loss & no problems there. Some times an ODBC
> > report will take 10 seconds and then a few minutes later 3 minutes,
> but
> > I cannot pinpoint what is causing the performance issue.
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> 02/02/10
> > 02:35:00
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
> 02:35:00
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 2, 2010, 12:03pm

Is your DSN setup for "Read Uncommitted"?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mmcwilliams22
Sent: Tuesday, February 02, 2010 12:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage getting slower by the week.

11.5.3

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Blake Clemens" <blake.clemens@...> wrote:

>
> What version of Crystal are you using to design your reports? I'm not
> talking about the Crystal version on each client machine.
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 11:50 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> 408
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com> ,

> "Blake Clemens" <blake.clemens@> wrote:
> >
> > What version of Vantage are you on?
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > 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 mmcwilliams22
> > Sent: Tuesday, February 02, 2010 11:43 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com>

> > Subject: [Vantage] Vantage getting slower by the week.
> >
> >
> >
> >
> >
> > I am working on increasing the performance of Vantage but cannot

seem

> to
> > find the bottleneck. At times when users are complainaing the CPU
> > utilization is at 1% on server and less than 3% on client. Memory
> usage
> > is not a factor at all, we are not even close on the client & the
> server
> > has about 1gig free room. I ran wireshark on the clients to look for
> tcp
> > retransmits or packet loss & no problems there. Some times an ODBC
> > report will take 10 seconds and then a few minutes later 3 minutes,
> but
> > I cannot pinpoint what is causing the performance issue.
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> 02/02/10
> > 02:35:00
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> 02:35:00
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
02:35:00

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

system · February 2, 2010, 12:11pm

Raid Configuration on the server?

I would recommend that the vantage DB be on a stand alone raid 10 array. If
you can I would have two raid 10 arrays one for the data file and one for
the transaction log file.

These should be separate from another array I would recommend raid 1 for the
OS and App.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Blake Clemens
Sent: Tuesday, February 02, 2010 12:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

Is your DSN setup for "Read Uncommitted"?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of mmcwilliams22
Sent: Tuesday, February 02, 2010 12:00 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Vantage getting slower by the week.

11.5.3

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ,
"Blake Clemens" <blake.clemens@...> wrote:

>
> What version of Crystal are you using to design your reports? I'm not
> talking about the Crystal version on each client machine.
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 11:50 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> 408
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,

> "Blake Clemens" <blake.clemens@> wrote:
> >
> > What version of Vantage are you on?
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>

> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On

> Behalf
> > Of mmcwilliams22
> > Sent: Tuesday, February 02, 2010 11:43 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>

> > Subject: [Vantage] Vantage getting slower by the week.
> >
> >
> >
> >
> >
> > I am working on increasing the performance of Vantage but cannot

seem

> to
> > find the bottleneck. At times when users are complainaing the CPU
> > utilization is at 1% on server and less than 3% on client. Memory
> usage
> > is not a factor at all, we are not even close on the client & the
> server
> > has about 1gig free room. I ran wireshark on the clients to look for
> tcp
> > retransmits or packet loss & no problems there. Some times an ODBC
> > report will take 10 seconds and then a few minutes later 3 minutes,
> but
> > I cannot pinpoint what is causing the performance issue.
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> 02/02/10
> > 02:35:00
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> 02:35:00
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
02:35:00

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

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

system · February 2, 2010, 12:17pm

Yes. The thing is that it is not only ODBC, it is the whole system. A user may be in AP invoice entry and all the sudden they start getting "Not Responding" and it takes a minute for a new line to appear and then 30 minutes later it is just cruising along. We are using 15k drives in RAID 1, I am sure that has some to do with it. But will RAID 10 really make that much of a difference & if that is the case then maybe SSD is really worth looking into. If I knew where to pinpoint I could throw the resources at it.

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> Is your DSN setup for "Read Uncommitted"?
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 12:00 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> 11.5.3
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Blake Clemens" <blake.clemens@> wrote:
> >
> > What version of Crystal are you using to design your reports? I'm not
> > talking about the Crystal version on each client machine.
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of mmcwilliams22
> > Sent: Tuesday, February 02, 2010 11:50 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Vantage getting slower by the week.
> >
> >
> >
> >
> >
> > 408
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "Blake Clemens" <blake.clemens@> wrote:
> > >
> > > What version of Vantage are you on?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > 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 mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > I am working on increasing the performance of Vantage but cannot
> seem
> > to
> > > find the bottleneck. At times when users are complainaing the CPU
> > > utilization is at 1% on server and less than 3% on client. Memory
> > usage
> > > is not a factor at all, we are not even close on the client & the
> > server
> > > has about 1gig free room. I ran wireshark on the clients to look for
> > tcp
> > > retransmits or packet loss & no problems there. Some times an ODBC
> > > report will take 10 seconds and then a few minutes later 3 minutes,
> > but
> > > I cannot pinpoint what is causing the performance issue.
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > 02/02/10
> > > 02:35:00
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> 02/02/10
> > 02:35:00
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
> 02:35:00
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 2, 2010, 12:26pm

Ok, but we still need some additional information. For example, what version are you on. Progress or SQL Server? Is the server dedicated to Vantage/E9 or is it also a PDC/Exchange server? What is your AV software and how is it configured?

Regards,

Michael

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

This email, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this email, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you have received this email in error, please immediately notify me by telephone and permanently delete the original and any copy of any email and any printout thereof.

On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:

> Yes. The thing is that it is not only ODBC, it is the whole system. A user may be in AP invoice entry and all the sudden they start getting "Not Responding" and it takes a minute for a new line to appear and then 30 minutes later it is just cruising along. We are using 15k drives in RAID 1, I am sure that has some to do with it. But will RAID 10 really make that much of a difference & if that is the case then maybe SSD is really worth looking into. If I knew where to pinpoint I could throw the resources at it.
>
> --- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
> >
> > Is your DSN setup for "Read Uncommitted"?
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of mmcwilliams22
> > Sent: Tuesday, February 02, 2010 12:00 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Vantage getting slower by the week.
> >
> >
> >
> >
> >
> > 11.5.3
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Blake Clemens" <blake.clemens@> wrote:
> > >
> > > What version of Crystal are you using to design your reports? I'm not
> > > talking about the Crystal version on each client machine.
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > > Of mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > 408
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > What version of Vantage are you on?
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > 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 mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > I am working on increasing the performance of Vantage but cannot
> > seem
> > > to
> > > > find the bottleneck. At times when users are complainaing the CPU
> > > > utilization is at 1% on server and less than 3% on client. Memory
> > > usage
> > > > is not a factor at all, we are not even close on the client & the
> > > server
> > > > has about 1gig free room. I ran wireshark on the clients to look for
> > > tcp
> > > > retransmits or packet loss & no problems there. Some times an ODBC
> > > > report will take 10 seconds and then a few minutes later 3 minutes,
> > > but
> > > > I cannot pinpoint what is causing the performance issue.
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > 02/02/10
> > > 02:35:00
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
> > 02:35:00
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>

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

system · February 2, 2010, 12:28pm

We've had issues with bad routers/switches before. Vantage is very
chatty and cognizant of even the slightest network blip.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mmcwilliams22
Sent: Tuesday, February 02, 2010 12:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage getting slower by the week.

Yes. The thing is that it is not only ODBC, it is the whole system. A
user may be in AP invoice entry and all the sudden they start getting
"Not Responding" and it takes a minute for a new line to appear and
then 30 minutes later it is just cruising along. We are using 15k
drives in RAID 1, I am sure that has some to do with it. But will RAID
10 really make that much of a difference & if that is the case then
maybe SSD is really worth looking into. If I knew where to pinpoint I
could throw the resources at it.

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...>
wrote:

>
> Is your DSN setup for "Read Uncommitted"?
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf

> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 12:00 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> 11.5.3
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Blake Clemens" <blake.clemens@> wrote:
> >
> > What version of Crystal are you using to design your reports? I'm

not

> > talking about the Crystal version on each client machine.
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]

On

> Behalf
> > Of mmcwilliams22
> > Sent: Tuesday, February 02, 2010 11:50 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Vantage getting slower by the week.
> >
> >
> >
> >
> >
> > 408
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > "Blake Clemens" <blake.clemens@> wrote:
> > >
> > > What version of Vantage are you on?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > 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 mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > I am working on increasing the performance of Vantage but cannot
> seem
> > to
> > > find the bottleneck. At times when users are complainaing the CPU
> > > utilization is at 1% on server and less than 3% on client. Memory
> > usage
> > > is not a factor at all, we are not even close on the client & the
> > server
> > > has about 1gig free room. I ran wireshark on the clients to look

for

> > tcp
> > > retransmits or packet loss & no problems there. Some times an ODBC
> > > report will take 10 seconds and then a few minutes later 3

minutes,

> > but
> > > I cannot pinpoint what is causing the performance issue.
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > 02/02/10
> > > 02:35:00
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> 02/02/10
> > 02:35:00
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> 02:35:00
>
>
>
> [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

system · February 2, 2010, 12:32pm

Sorry, I left out a couple of additional questions. How is your server configured? I got the RAID 1 but what about CPU/RAM etc? How many concurrent users including shop floor? I'm assuming that you are running some variant of Windows Server so do you have things like volume shadow copy or the indexing service running? Is there a periodic disk defragmenter or online backup process running?

Regards,

Michael

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

This email, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this email, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you have received this email in error, please immediately notify me by telephone and permanently delete the original and any copy of any email and any printout thereof.

On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:

> Yes. The thing is that it is not only ODBC, it is the whole system. A user may be in AP invoice entry and all the sudden they start getting "Not Responding" and it takes a minute for a new line to appear and then 30 minutes later it is just cruising along. We are using 15k drives in RAID 1, I am sure that has some to do with it. But will RAID 10 really make that much of a difference & if that is the case then maybe SSD is really worth looking into. If I knew where to pinpoint I could throw the resources at it.
>
> --- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
> >
> > Is your DSN setup for "Read Uncommitted"?
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of mmcwilliams22
> > Sent: Tuesday, February 02, 2010 12:00 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Vantage getting slower by the week.
> >
> >
> >
> >
> >
> > 11.5.3
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Blake Clemens" <blake.clemens@> wrote:
> > >
> > > What version of Crystal are you using to design your reports? I'm not
> > > talking about the Crystal version on each client machine.
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > > Of mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > 408
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > > "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > What version of Vantage are you on?
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > 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 mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > I am working on increasing the performance of Vantage but cannot
> > seem
> > > to
> > > > find the bottleneck. At times when users are complainaing the CPU
> > > > utilization is at 1% on server and less than 3% on client. Memory
> > > usage
> > > > is not a factor at all, we are not even close on the client & the
> > > server
> > > > has about 1gig free room. I ran wireshark on the clients to look for
> > > tcp
> > > > retransmits or packet loss & no problems there. Some times an ODBC
> > > > report will take 10 seconds and then a few minutes later 3 minutes,
> > > but
> > > > I cannot pinpoint what is causing the performance issue.
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > 02/02/10
> > > 02:35:00
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
> > 02:35:00
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>

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

system · February 2, 2010, 12:45pm

Dual Xeon 2.8 with 4GB of RAM 15k disks
Windows 2003 Server
15 Shop Floor
25 Office users
Antivirus is ESET with all the recommended exlusions.
Volume shadow copy is not enabled.
Indexing is disabled.
I defragged the server on Sunday yet still have 60% file & 30% total.
Vantage is backed up at 2a, 6a, 10a, 4p & then also uploaded to an offsite location.

--- In vantage@yahoogroups.com, Michael Barry <mbarry@...> wrote:
>
> Sorry, I left out a couple of additional questions. How is your server configured? I got the RAID 1 but what about CPU/RAM etc? How many concurrent users including shop floor? I'm assuming that you are running some variant of Windows Server so do you have things like volume shadow copy or the indexing service running? Is there a periodic disk defragmenter or online backup process running?
>
> Regards,
>
> Michael
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia.com/
>
> This email, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this email, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you have received this email in error, please immediately notify me by telephone and permanently delete the original and any copy of any email and any printout thereof.
>
>
>
>
> On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:
>
> > Yes. The thing is that it is not only ODBC, it is the whole system. A user may be in AP invoice entry and all the sudden they start getting "Not Responding" and it takes a minute for a new line to appear and then 30 minutes later it is just cruising along. We are using 15k drives in RAID 1, I am sure that has some to do with it. But will RAID 10 really make that much of a difference & if that is the case then maybe SSD is really worth looking into. If I knew where to pinpoint I could throw the resources at it.
> >
> > --- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@> wrote:
> > >
> > > Is your DSN setup for "Read Uncommitted"?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 12:00 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > 11.5.3
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > What version of Crystal are you using to design your reports? I'm not
> > > > talking about the Crystal version on each client machine.
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf
> > > > Of mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 408
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > What version of Vantage are you on?
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > 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 mmcwilliams22
> > > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Vantage getting slower by the week.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > I am working on increasing the performance of Vantage but cannot
> > > seem
> > > > to
> > > > > find the bottleneck. At times when users are complainaing the CPU
> > > > > utilization is at 1% on server and less than 3% on client. Memory
> > > > usage
> > > > > is not a factor at all, we are not even close on the client & the
> > > > server
> > > > > has about 1gig free room. I ran wireshark on the clients to look for
> > > > tcp
> > > > > retransmits or packet loss & no problems there. Some times an ODBC
> > > > > report will take 10 seconds and then a few minutes later 3 minutes,
> > > > but
> > > > > I cannot pinpoint what is causing the performance issue.
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > > 02/02/10
> > > > > 02:35:00
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
> > > 02:35:00
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 2, 2010, 12:54pm

And everything is on this raid 1?

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mmcwilliams22
Sent: Tuesday, February 02, 2010 12:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage getting slower by the week.

Dual Xeon 2.8 with 4GB of RAM 15k disks
Windows 2003 Server
15 Shop Floor
25 Office users
Antivirus is ESET with all the recommended exlusions.
Volume shadow copy is not enabled.
Indexing is disabled.
I defragged the server on Sunday yet still have 60% file & 30% total.
Vantage is backed up at 2a, 6a, 10a, 4p & then also uploaded to an offsite
location.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, Michael
Barry <mbarry@...> wrote:

>
> Sorry, I left out a couple of additional questions. How is your server

configured? I got the RAID 1 but what about CPU/RAM etc? How many concurrent
users including shop floor? I'm assuming that you are running some variant
of Windows Server so do you have things like volume shadow copy or the
indexing service running? Is there a periodic disk defragmenter or online
backup process running?

>
> Regards,
>
> Michael
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia <http://www.aspacia.com/> com/
>
> This email, and any attachments thereto, is intended only for use by the

addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly prohibited.
If you have received this email in error, please immediately notify me by
telephone and permanently delete the original and any copy of any email and
any printout thereof.

>
>
>
>
> On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:
>
> > Yes. The thing is that it is not only ODBC, it is the whole system. A

user may be in AP invoice entry and all the sudden they start getting "Not
Responding" and it takes a minute for a new line to appear and then 30
minutes later it is just cruising along. We are using 15k drives in RAID 1,
I am sure that has some to do with it. But will RAID 10 really make that
much of a difference & if that is the case then maybe SSD is really worth
looking into. If I knew where to pinpoint I could throw the resources at it.

> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Blake Clemens" <blake.clemens@> wrote:

> > >
> > > Is your DSN setup for "Read Uncommitted"?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf

> > > Of mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 12:00 PM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > 11.5.3
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com> ,

> > > "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > What version of Crystal are you using to design your reports? I'm

not

> > > > talking about the Crystal version on each client machine.
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com> ] On

> > > Behalf
> > > > Of mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 408
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > What version of Vantage are you on?
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com> ] On
> > > > Behalf
> > > > > Of mmcwilliams22
> > > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Vantage getting slower by the week.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > I am working on increasing the performance of Vantage but cannot
> > > seem
> > > > to
> > > > > find the bottleneck. At times when users are complainaing the CPU
> > > > > utilization is at 1% on server and less than 3% on client. Memory
> > > > usage
> > > > > is not a factor at all, we are not even close on the client & the
> > > > server
> > > > > has about 1gig free room. I ran wireshark on the clients to look

for

> > > > tcp
> > > > > retransmits or packet loss & no problems there. Some times an ODBC
> > > > > report will take 10 seconds and then a few minutes later 3

minutes,

> > > > but
> > > > > I cannot pinpoint what is causing the performance issue.
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > > 02/02/10
> > > > > 02:35:00
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> > > 02:35:00
> > >
> > >
> > >
> > > [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]

system · February 2, 2010, 12:54pm

What version and what backend DB are you running?

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

This email, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this email, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you have received this email in error, please immediately notify me by telephone and permanently delete the original and any copy of any email and any printout thereof.

On Feb 2, 2010, at 9:42 AM, mmcwilliams22 wrote:

> Dual Xeon 2.8 with 4GB of RAM 15k disks
> Windows 2003 Server
> 15 Shop Floor
> 25 Office users
> Antivirus is ESET with all the recommended exlusions.
> Volume shadow copy is not enabled.
> Indexing is disabled.
> I defragged the server on Sunday yet still have 60% file & 30% total.
> Vantage is backed up at 2a, 6a, 10a, 4p & then also uploaded to an offsite location.
>
> --- In vantage@yahoogroups.com, Michael Barry <mbarry@...> wrote:
> >
> > Sorry, I left out a couple of additional questions. How is your server configured? I got the RAID 1 but what about CPU/RAM etc? How many concurrent users including shop floor? I'm assuming that you are running some variant of Windows Server so do you have things like volume shadow copy or the indexing service running? Is there a periodic disk defragmenter or online backup process running?
> >
> > Regards,
> >
> > Michael
> >
> > Michael Barry
> > Aspacia Systems Inc
> > 866.566.9600
> > 312.803.0730 fax
> > http://www.aspacia.com/
> >
> > This email, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this email, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you have received this email in error, please immediately notify me by telephone and permanently delete the original and any copy of any email and any printout thereof.
> >
> >
> >
> >
> > On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:
> >
> > > Yes. The thing is that it is not only ODBC, it is the whole system. A user may be in AP invoice entry and all the sudden they start getting "Not Responding" and it takes a minute for a new line to appear and then 30 minutes later it is just cruising along. We are using 15k drives in RAID 1, I am sure that has some to do with it. But will RAID 10 really make that much of a difference & if that is the case then maybe SSD is really worth looking into. If I knew where to pinpoint I could throw the resources at it.
> > >
> > > --- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > Is your DSN setup for "Read Uncommitted"?
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > > Of mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 12:00 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 11.5.3
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > What version of Crystal are you using to design your reports? I'm not
> > > > > talking about the Crystal version on each client machine.
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > > Behalf
> > > > > Of mmcwilliams22
> > > > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > 408
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > > >
> > > > > > What version of Vantage are you on?
> > > > > >
> > > > > >
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Blake Clemens
> > > > > >
> > > > > > IT Systems Engineer
> > > > > >
> > > > > > Delmarva Millwork Corporation
> > > > > >
> > > > > > (800) 360-2364 x132
> > > > > >
> > > > > > 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 mmcwilliams22
> > > > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > > Subject: [Vantage] Vantage getting slower by the week.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > I am working on increasing the performance of Vantage but cannot
> > > > seem
> > > > > to
> > > > > > find the bottleneck. At times when users are complainaing the CPU
> > > > > > utilization is at 1% on server and less than 3% on client. Memory
> > > > > usage
> > > > > > is not a factor at all, we are not even close on the client & the
> > > > > server
> > > > > > has about 1gig free room. I ran wireshark on the clients to look for
> > > > > tcp
> > > > > > retransmits or packet loss & no problems there. Some times an ODBC
> > > > > > report will take 10 seconds and then a few minutes later 3 minutes,
> > > > > but
> > > > > > I cannot pinpoint what is causing the performance issue.
> > > > > >
> > > > > >
> > > > > >
> > > > > > No virus found in this incoming message.
> > > > > > Checked by AVG - www.avg.com
> > > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > > > 02/02/10
> > > > > > 02:35:00
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > > 02/02/10
> > > > > 02:35:00
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date: 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [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]

system · February 2, 2010, 1:00pm

Yes, all on single raid partitioned 3 ways. OS, Vantage, Page File..
This was the recommendation of Epicor.

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> And everything is on this raid 1?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> mmcwilliams22
> Sent: Tuesday, February 02, 2010 12:42 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> Dual Xeon 2.8 with 4GB of RAM 15k disks
> Windows 2003 Server
> 15 Shop Floor
> 25 Office users
> Antivirus is ESET with all the recommended exlusions.
> Volume shadow copy is not enabled.
> Indexing is disabled.
> I defragged the server on Sunday yet still have 60% file & 30% total.
> Vantage is backed up at 2a, 6a, 10a, 4p & then also uploaded to an offsite
> location.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, Michael
> Barry <mbarry@> wrote:
> >
> > Sorry, I left out a couple of additional questions. How is your server
> configured? I got the RAID 1 but what about CPU/RAM etc? How many concurrent
> users including shop floor? I'm assuming that you are running some variant
> of Windows Server so do you have things like volume shadow copy or the
> indexing service running? Is there a periodic disk defragmenter or online
> backup process running?
> >
> > Regards,
> >
> > Michael
> >
> > Michael Barry
> > Aspacia Systems Inc
> > 866.566.9600
> > 312.803.0730 fax
> > http://www.aspacia <http://www.aspacia.com/> com/
> >
> > This email, and any attachments thereto, is intended only for use by the
> addressee(s) named herein and may contain legally privileged and/or
> confidential information. If you are not the intended recipient of this
> email, you are hereby notified that any dissemination, distribution or
> copying of this email, and any attachments thereto, is strictly prohibited.
> If you have received this email in error, please immediately notify me by
> telephone and permanently delete the original and any copy of any email and
> any printout thereof.
> >
> >
> >
> >
> > On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:
> >
> > > Yes. The thing is that it is not only ODBC, it is the whole system. A
> user may be in AP invoice entry and all the sudden they start getting "Not
> Responding" and it takes a minute for a new line to appear and then 30
> minutes later it is just cruising along. We are using 15k drives in RAID 1,
> I am sure that has some to do with it. But will RAID 10 really make that
> much of a difference & if that is the case then maybe SSD is really worth
> looking into. If I knew where to pinpoint I could throw the resources at it.
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > Is your DSN setup for "Read Uncommitted"?
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf
> > > > Of mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 12:00 PM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 11.5.3
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com> ,
> > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > What version of Crystal are you using to design your reports? I'm
> not
> > > > > talking about the Crystal version on each client machine.
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com> ] On
> > > > Behalf
> > > > > Of mmcwilliams22
> > > > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > 408
> > > > >
> > > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > > >
> > > > > > What version of Vantage are you on?
> > > > > >
> > > > > >
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Blake Clemens
> > > > > >
> > > > > > IT Systems Engineer
> > > > > >
> > > > > > Delmarva Millwork Corporation
> > > > > >
> > > > > > (800) 360-2364 x132
> > > > > >
> > > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ] On
> > > > > Behalf
> > > > > > Of mmcwilliams22
> > > > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > > Subject: [Vantage] Vantage getting slower by the week.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > I am working on increasing the performance of Vantage but cannot
> > > > seem
> > > > > to
> > > > > > find the bottleneck. At times when users are complainaing the CPU
> > > > > > utilization is at 1% on server and less than 3% on client. Memory
> > > > > usage
> > > > > > is not a factor at all, we are not even close on the client & the
> > > > > server
> > > > > > has about 1gig free room. I ran wireshark on the clients to look
> for
> > > > > tcp
> > > > > > retransmits or packet loss & no problems there. Some times an ODBC
> > > > > > report will take 10 seconds and then a few minutes later 3
> minutes,
> > > > > but
> > > > > > I cannot pinpoint what is causing the performance issue.
> > > > > >
> > > > > >
> > > > > >
> > > > > > No virus found in this incoming message.
> > > > > > Checked by AVG - www.avg.com
> > > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > > > 02/02/10
> > > > > > 02:35:00
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > > 02/02/10
> > > > > 02:35:00
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [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]
>

system · February 2, 2010, 1:02pm

I'm with Charlie if that's true...

We had severe performance issues & installed a RAID 10 volume for the
DB & have seen a much improved performance increase.

People actually comment on how well Vantage is running, which was NEVER
the case before.

We were only able to add a single 3x3 RAID 10 (15K Drives) due to
chassis limitations, otherwise I would have added a second set like
suggested for the transaction logs...

Also, our consultants did a very thorough tuning of the entire server...

We are a 30 user SQL environment.

Ron Flynn

Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

16770 West Victor Road

New Berlin, WI 53151

262.789.1966 xt. 124

262.789.1970 fax

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Tuesday, February 02, 2010 11:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

And everything is on this raid 1?

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
mmcwilliams22
Sent: Tuesday, February 02, 2010 12:42 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Vantage getting slower by the week.

Dual Xeon 2.8 with 4GB of RAM 15k disks
Windows 2003 Server
15 Shop Floor
25 Office users
Antivirus is ESET with all the recommended exlusions.
Volume shadow copy is not enabled.
Indexing is disabled.
I defragged the server on Sunday yet still have 60% file & 30% total.
Vantage is backed up at 2a, 6a, 10a, 4p & then also uploaded to an
offsite
location.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
Michael
Barry <mbarry@...> wrote:

>
> Sorry, I left out a couple of additional questions. How is your server

configured? I got the RAID 1 but what about CPU/RAM etc? How many
concurrent
users including shop floor? I'm assuming that you are running some
variant
of Windows Server so do you have things like volume shadow copy or the
indexing service running? Is there a periodic disk defragmenter or
online
backup process running?

>
> Regards,
>
> Michael
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia <http://www.aspacia.com/> com/
>
> This email, and any attachments thereto, is intended only for use by

the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly
prohibited.
If you have received this email in error, please immediately notify me
by
telephone and permanently delete the original and any copy of any email
and
any printout thereof.

>
>
>
>
> On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:
>
> > Yes. The thing is that it is not only ODBC, it is the whole system.

A
user may be in AP invoice entry and all the sudden they start getting
"Not
Responding" and it takes a minute for a new line to appear and then 30
minutes later it is just cruising along. We are using 15k drives in RAID
1,
I am sure that has some to do with it. But will RAID 10 really make that
much of a difference & if that is the case then maybe SSD is really
worth
looking into. If I knew where to pinpoint I could throw the resources at
it.

> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Blake Clemens" <blake.clemens@> wrote:

> > >
> > > Is your DSN setup for "Read Uncommitted"?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf

> > > Of mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 12:00 PM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > 11.5.3
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com> ,

> > > "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > What version of Crystal are you using to design your reports?

I'm
not

> > > > talking about the Crystal version on each client machine.
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com> ] On

> > > Behalf
> > > > Of mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 408
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > What version of Vantage are you on?
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com> ] On
> > > > Behalf
> > > > > Of mmcwilliams22
> > > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Vantage getting slower by the week.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > I am working on increasing the performance of Vantage but

cannot

> > > seem
> > > > to
> > > > > find the bottleneck. At times when users are complainaing the

CPU

> > > > > utilization is at 1% on server and less than 3% on client.

Memory

> > > > usage
> > > > > is not a factor at all, we are not even close on the client &

the

> > > > server
> > > > > has about 1gig free room. I ran wireshark on the clients to

look
for

> > > > tcp
> > > > > retransmits or packet loss & no problems there. Some times an

ODBC

> > > > > report will take 10 seconds and then a few minutes later 3

minutes,

> > > > but
> > > > > I cannot pinpoint what is causing the performance issue.
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release

Date:

> > > > 02/02/10
> > > > > 02:35:00
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> > > 02:35:00
> > >
> > >
> > >
> > > [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]

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

system · February 2, 2010, 1:05pm

That's funny, they recommended 3x RAID 1 for us, at least they got the
splitting up of the DB's correct.

We also installed 16GB more of memory for a total of 24GB now I believe.

We did that first... on recommendation from the group.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mmcwilliams22
Sent: Tuesday, February 02, 2010 11:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage getting slower by the week.

Yes, all on single raid partitioned 3 ways. OS, Vantage, Page File..
This was the recommendation of Epicor.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Charlie Wilson" <foamdesigncsw@...> wrote:

>
> And everything is on this raid 1?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of

> mmcwilliams22
> Sent: Tuesday, February 02, 2010 12:42 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> Dual Xeon 2.8 with 4GB of RAM 15k disks
> Windows 2003 Server
> 15 Shop Floor
> 25 Office users
> Antivirus is ESET with all the recommended exlusions.
> Volume shadow copy is not enabled.
> Indexing is disabled.
> I defragged the server on Sunday yet still have 60% file & 30% total.
> Vantage is backed up at 2a, 6a, 10a, 4p & then also uploaded to an

offsite

> location.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

Michael

> Barry <mbarry@> wrote:
> >
> > Sorry, I left out a couple of additional questions. How is your

server

> configured? I got the RAID 1 but what about CPU/RAM etc? How many

concurrent

> users including shop floor? I'm assuming that you are running some

variant

> of Windows Server so do you have things like volume shadow copy or the
> indexing service running? Is there a periodic disk defragmenter or

online

> backup process running?
> >
> > Regards,
> >
> > Michael
> >
> > Michael Barry
> > Aspacia Systems Inc
> > 866.566.9600
> > 312.803.0730 fax
> > http://www.aspacia <http://www.aspacia.com/> com/
> >
> > This email, and any attachments thereto, is intended only for use by

the

> addressee(s) named herein and may contain legally privileged and/or
> confidential information. If you are not the intended recipient of

this

> email, you are hereby notified that any dissemination, distribution or
> copying of this email, and any attachments thereto, is strictly

prohibited.

> If you have received this email in error, please immediately notify me

by

> telephone and permanently delete the original and any copy of any

email and

> any printout thereof.
> >
> >
> >
> >
> > On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:
> >
> > > Yes. The thing is that it is not only ODBC, it is the whole

system. A

> user may be in AP invoice entry and all the sudden they start getting

"Not

> Responding" and it takes a minute for a new line to appear and then 30
> minutes later it is just cruising along. We are using 15k drives in

RAID 1,

> I am sure that has some to do with it. But will RAID 10 really make

that

> much of a difference & if that is the case then maybe SSD is really

worth

> looking into. If I knew where to pinpoint I could throw the resources

at it.

> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com,

> "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > Is your DSN setup for "Read Uncommitted"?
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]

On

> Behalf
> > > > Of mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 12:00 PM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 11.5.3
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> <mailto:vantage%40yahoogroups.com> ,
> > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > What version of Crystal are you using to design your reports?

I'm

> not
> > > > > talking about the Crystal version on each client machine.
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> <mailto:vantage%40yahoogroups.com> ] On
> > > > Behalf
> > > > > Of mmcwilliams22
> > > > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > 408
> > > > >
> > > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ,
> > > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > > >
> > > > > > What version of Vantage are you on?
> > > > > >
> > > > > >
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Blake Clemens
> > > > > >
> > > > > > IT Systems Engineer
> > > > > >
> > > > > > Delmarva Millwork Corporation
> > > > > >
> > > > > > (800) 360-2364 x132
> > > > > >
> > > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> ] On
> > > > > Behalf
> > > > > > Of mmcwilliams22
> > > > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > > Subject: [Vantage] Vantage getting slower by the week.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > I am working on increasing the performance of Vantage but

cannot

> > > > seem
> > > > > to
> > > > > > find the bottleneck. At times when users are complainaing

the CPU

> > > > > > utilization is at 1% on server and less than 3% on client.

Memory

> > > > > usage
> > > > > > is not a factor at all, we are not even close on the client

& the

> > > > > server
> > > > > > has about 1gig free room. I ran wireshark on the clients to

look

> for
> > > > > tcp
> > > > > > retransmits or packet loss & no problems there. Some times

an ODBC

> > > > > > report will take 10 seconds and then a few minutes later 3
> minutes,
> > > > > but
> > > > > > I cannot pinpoint what is causing the performance issue.
> > > > > >
> > > > > >
> > > > > >
> > > > > > No virus found in this incoming message.
> > > > > > Checked by AVG - www.avg.com
> > > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release

Date:

> > > > > 02/02/10
> > > > > > 02:35:00
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release

Date:

> > > > 02/02/10
> > > > > 02:35:00
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [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]
>

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

system · February 2, 2010, 1:15pm

Depending on how many drives are in the array of a raid 10 you can double
and quadrpel read and write rates. This is due to the fact that the raid is
a stripe across multiple mirrors which means you can write a string sectors
at once basically. There are 1000 and white paper reports about raid
configurations you can go read. But I can't believe that was epicors
recommendation. I went to the admin class and it was raid 10 raid 10 raid 10
I had to make sure it wasn't tattooed on me somewhere before I left.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
IT Support
Sent: Tuesday, February 02, 2010 1:02 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

I'm with Charlie if that's true...

We had severe performance issues & installed a RAID 10 volume for the
DB & have seen a much improved performance increase.

People actually comment on how well Vantage is running, which was NEVER
the case before.

We were only able to add a single 3x3 RAID 10 (15K Drives) due to
chassis limitations, otherwise I would have added a second set like
suggested for the transaction logs...

Also, our consultants did a very thorough tuning of the entire server...

We are a 30 user SQL environment.

Ron Flynn

Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

16770 West Victor Road

New Berlin, WI 53151

262.789.1966 xt. 124

262.789.1970 fax

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, February 02, 2010 11:53 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

And everything is on this raid 1?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
mmcwilliams22
Sent: Tuesday, February 02, 2010 12:42 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Vantage getting slower by the week.

Dual Xeon 2.8 with 4GB of RAM 15k disks
Windows 2003 Server
15 Shop Floor
25 Office users
Antivirus is ESET with all the recommended exlusions.
Volume shadow copy is not enabled.
Indexing is disabled.
I defragged the server on Sunday yet still have 60% file & 30% total.
Vantage is backed up at 2a, 6a, 10a, 4p & then also uploaded to an
offsite
location.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
Michael
Barry <mbarry@...> wrote:

>
> Sorry, I left out a couple of additional questions. How is your server

configured? I got the RAID 1 but what about CPU/RAM etc? How many
concurrent
users including shop floor? I'm assuming that you are running some
variant
of Windows Server so do you have things like volume shadow copy or the
indexing service running? Is there a periodic disk defragmenter or
online
backup process running?

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

com/

>
> This email, and any attachments thereto, is intended only for use by

the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly
prohibited.
If you have received this email in error, please immediately notify me
by
telephone and permanently delete the original and any copy of any email
and
any printout thereof.

>
>
>
>
> On Feb 2, 2010, at 9:17 AM, mmcwilliams22 wrote:
>
> > Yes. The thing is that it is not only ODBC, it is the whole system.

A
user may be in AP invoice entry and all the sudden they start getting
"Not
Responding" and it takes a minute for a new line to appear and then 30
minutes later it is just cruising along. We are using 15k drives in RAID
1,
I am sure that has some to do with it. But will RAID 10 really make that
much of a difference & if that is the case then maybe SSD is really
worth
looking into. If I knew where to pinpoint I could throw the resources at
it.

> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Blake Clemens" <blake.clemens@> wrote:

> > >
> > > Is your DSN setup for "Read Uncommitted"?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf

> > > Of mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 12:00 PM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > >
> > >
> > >
> > >
> > >
> > > 11.5.3
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com> ,

> > > "Blake Clemens" <blake.clemens@> wrote:
> > > >
> > > > What version of Crystal are you using to design your reports?

I'm
not

> > > > talking about the Crystal version on each client machine.
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Blake Clemens
> > > >
> > > > IT Systems Engineer
> > > >
> > > > Delmarva Millwork Corporation
> > > >
> > > > (800) 360-2364 x132
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com> ] On

> > > Behalf
> > > > Of mmcwilliams22
> > > > Sent: Tuesday, February 02, 2010 11:50 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

<mailto:vantage%40yahoogroups.com>

> > > > Subject: [Vantage] Re: Vantage getting slower by the week.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 408
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com> ,
> > > > "Blake Clemens" <blake.clemens@> wrote:
> > > > >
> > > > > What version of Vantage are you on?
> > > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Blake Clemens
> > > > >
> > > > > IT Systems Engineer
> > > > >
> > > > > Delmarva Millwork Corporation
> > > > >
> > > > > (800) 360-2364 x132
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com> ] On
> > > > Behalf
> > > > > Of mmcwilliams22
> > > > > Sent: Tuesday, February 02, 2010 11:43 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com
<mailto:vantage%40yahoogroups.com>

> > > <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Vantage getting slower by the week.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > I am working on increasing the performance of Vantage but

cannot

> > > seem
> > > > to
> > > > > find the bottleneck. At times when users are complainaing the

CPU

> > > > > utilization is at 1% on server and less than 3% on client.

Memory

> > > > usage
> > > > > is not a factor at all, we are not even close on the client &

the

> > > > server
> > > > > has about 1gig free room. I ran wireshark on the clients to

look
for

> > > > tcp
> > > > > retransmits or packet loss & no problems there. Some times an

ODBC

> > > > > report will take 10 seconds and then a few minutes later 3

minutes,

> > > > but
> > > > > I cannot pinpoint what is causing the performance issue.
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - www.avg.com
> > > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release

Date:

> > > > 02/02/10
> > > > > 02:35:00
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:
> > > 02/02/10
> > > > 02:35:00
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 9.0.733 / Virus Database: 271.1.1/2662 - Release Date:

02/02/10

> > > 02:35:00
> > >
> > >
> > >
> > > [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]

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

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

Topic		Replies	Views
Solid state disk? Yahoo Archive	10	596	September 4, 2002
5.2 running slow Yahoo Archive	18	479	December 15, 2003
[Off Topic] - New Server AND Back Up Yahoo Archive	23	703	June 5, 2002
Solid State Drives Yahoo Archive	8	439	September 20, 2002
Computer performance issues Yahoo Archive	4	394	September 6, 2007

Iodrives : RE: Vantage getting slower by the week

Related Topics