Iodrives : RE: Vantage getting slower by the week

system · February 2, 2010, 1:18pm

There is no way that Epicor recommended that.... Who did your install?
Epicor or a VAR/3rd party?

Ben Nixon heads up that department and he is adamant about NOT doing
that.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mmcwilliams22
Sent: Tuesday, February 02, 2010 12:59 PM
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, "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]
>

------------------------------------

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, 1:21pm

Whoa...

A single RAID with 3 partitions? Who at Epicor reccomended that? I can't
think of anyone i know who would actually make that for a recomendation.

I would start out with that being part of your problem. How many drives in
the one RAID? 2? What size are they?

You should have a minimum of 2 RAID setups so that you are actually
segmenting different physical spindals for the processes.

6+ individual discs is best though, size being irrelevant, 2 in a RAID1 for
the OS, 2+ in RAID10 for the DB and program, 2 in RAID1 for the logs and
Page file, if you can get them on seperate RAID controllers completely then
that would be even better, but segregating them into seperate arrays is at
least a decent step in the right direction.

----- Original Message -----
From: "mmcwilliams22" <mmcwilliams22@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, February 02, 2010 12:58 PM
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, "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]
>>
>
>
>
>
> ------------------------------------
>
> 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, 1:24pm

The stories have not been exagerated... death could result from not
following those directions from Ben...

----- Original Message -----
From: "Vic Drecchio" <vic.drecchio@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, February 02, 2010 1:17 PM
Subject: RE: [Vantage] Re: Vantage getting slower by the week.

> There is no way that Epicor recommended that.... Who did your install?
> Epicor or a VAR/3rd party?
>
> Ben Nixon heads up that department and he is adamant about NOT doing
> that.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 12:59 PM
> 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, "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]
>>
>
>
>
>
> ------------------------------------
>
> 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
>
>
>
>
>
> ------------------------------------
>
> 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, 1:24pm

Ben did the install in 06. When we were sizing up the server I took exactly what they said to buy for the server at the time. I took the server recommendation & purchased that. I submited the specs of the server before purchasing it & it was all good to go. Anyways shame on me, I knew there would be something more to get from raid10, but if this is the cause of my problems recently I will need to change.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> There is no way that Epicor recommended that.... Who did your install?
> Epicor or a VAR/3rd party?
>
> Ben Nixon heads up that department and he is adamant about NOT doing
> that.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of mmcwilliams22
> Sent: Tuesday, February 02, 2010 12:59 PM
> 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, "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]
> >
>
>
>
>
> ------------------------------------
>
> 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, 1:26pm

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@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Tuesday, February 02, 2010 12:15 PM
To: vantage@yahoogroups.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@yahoogroups.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>
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]

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

system · February 2, 2010, 1:47pm

There are a couple of interesting items about your description of the performance issues. First is that you describe them as episodic and recurring rather than a general condition. Second, the instances you described are all database read instances (running a report, pauses in lines appearing in AP Invoice entry, etc..). A reasonably configured DB server should expect well above a 95% cache hit ratio so, for the most part, as far as reads are concerned the IO subsystem would be out of play. Have you checked your hit ratio?

The fact that it is episodic is also curious. When it occurs, is it confined to a single workstation or does the entire system come to its knees? The instances you described seem to isolate the problem to a single user at a time. Is that the case or does the whole system just crawl at once?

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 10:22 AM, mmcwilliams22 wrote:

> Ben did the install in 06. When we were sizing up the server I took exactly what they said to buy for the server at the time. I took the server recommendation & purchased that. I submited the specs of the server before purchasing it & it was all good to go. Anyways shame on me, I knew there would be something more to get from raid10, but if this is the cause of my problems recently I will need to change.
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
> >
> > There is no way that Epicor recommended that.... Who did your install?
> > Epicor or a VAR/3rd party?
> >
> > Ben Nixon heads up that department and he is adamant about NOT doing
> > that.
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of mmcwilliams22
> > Sent: Tuesday, February 02, 2010 12:59 PM
> > 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, "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]
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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
> >
>
>

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

system · February 2, 2010, 1:54pm

It is the whole system comming to a crawl. As soon as I get one call I know I will get 10 more. I really to appreciate all the input..

--- In vantage@yahoogroups.com, Michael Barry <mbarry@...> wrote:
>
> There are a couple of interesting items about your description of the performance issues. First is that you describe them as episodic and recurring rather than a general condition. Second, the instances you described are all database read instances (running a report, pauses in lines appearing in AP Invoice entry, etc..). A reasonably configured DB server should expect well above a 95% cache hit ratio so, for the most part, as far as reads are concerned the IO subsystem would be out of play. Have you checked your hit ratio?
>
> The fact that it is episodic is also curious. When it occurs, is it confined to a single workstation or does the entire system come to its knees? The instances you described seem to isolate the problem to a single user at a time. Is that the case or does the whole system just crawl at once?
>
> 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 10:22 AM, mmcwilliams22 wrote:
>
> > Ben did the install in 06. When we were sizing up the server I took exactly what they said to buy for the server at the time. I took the server recommendation & purchased that. I submited the specs of the server before purchasing it & it was all good to go. Anyways shame on me, I knew there would be something more to get from raid10, but if this is the cause of my problems recently I will need to change.
> >
> > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > >
> > > There is no way that Epicor recommended that.... Who did your install?
> > > Epicor or a VAR/3rd party?
> > >
> > > Ben Nixon heads up that department and he is adamant about NOT doing
> > > that.
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of mmcwilliams22
> > > Sent: Tuesday, February 02, 2010 12:59 PM
> > > 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, "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]
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > 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
> > >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 2, 2010, 2:07pm

If you are running progress it has a set of tools where you can see cache
hit ratios.

Let me know if you are on progress I'll give you directions so you can check
on your cache hit.

~Charlie

_____

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

It is the whole system comming to a crawl. As soon as I get one call I know
I will get 10 more. I really to appreciate all the input..

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

>
> There are a couple of interesting items about your description of the

performance issues. First is that you describe them as episodic and
recurring rather than a general condition. Second, the instances you
described are all database read instances (running a report, pauses in lines
appearing in AP Invoice entry, etc..). A reasonably configured DB server
should expect well above a 95% cache hit ratio so, for the most part, as far
as reads are concerned the IO subsystem would be out of play. Have you
checked your hit ratio?

>
> The fact that it is episodic is also curious. When it occurs, is it

confined to a single workstation or does the entire system come to its
knees? The instances you described seem to isolate the problem to a single
user at a time. Is that the case or does the whole system just crawl at
once?

>
> 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 10:22 AM, mmcwilliams22 wrote:
>
> > Ben did the install in 06. When we were sizing up the server I took

exactly what they said to buy for the server at the time. I took the server
recommendation & purchased that. I submited the specs of the server before
purchasing it & it was all good to go. Anyways shame on me, I knew there
would be something more to get from raid10, but if this is the cause of my
problems recently I will need to change.

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

Drecchio" <vic.drecchio@> wrote:

> > >
> > > There is no way that Epicor recommended that.... Who did your install?
> > > Epicor or a VAR/3rd party?
> > >
> > > Ben Nixon heads up that department and he is adamant about NOT doing
> > > that.
> > >
> > > -----Original Message-----
> > > 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:59 PM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .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 <mailto:vantage%40yahoogroups.com> .com,

"Charlie Wilson" <foamdesigncsw@>

> > > wrote:
> > > >
> > > > And everything is on this raid 1?
> > > >
> > > >
> > > >
> > > > ~Charlie
> > > >
> > > > _____
> > > >
> > > > 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:42 PM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .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]
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > 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. <http://groups.yahoo.com/group/vantage/files/>

yahoo.com/group/vantage/files/.

> > > (2) To search through old msg's goto:
> > > http://groups. <http://groups.yahoo.com/group/vantage/messages>

yahoo.com/group/vantage/messages

> > > (3) To view links to Vendors that provide Vantage services goto:
> > > http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>

yahoo.com/group/vantage/linksYahoo! Groups Links

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

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

system · February 2, 2010, 2:40pm

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@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of IT Support
Sent: Tuesday, February 02, 2010 1:27 PM
To: vantage@yahoogroups.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@yahoogroups.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>
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@yahoogroups.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>
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/> >
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]

system · February 2, 2010, 2:44pm

I see thie buffer hits all over the place when I refresh using promon.
55% 0% 65% 85% 100% etc. Is there a better way to get a ratio?

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> If you are running progress it has a set of tools where you can see cache
> hit ratios.
>
>
>
> Let me know if you are on progress I'll give you directions so you can check
> on your cache hit.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> mmcwilliams22
> Sent: Tuesday, February 02, 2010 1:55 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> It is the whole system comming to a crawl. As soon as I get one call I know
> I will get 10 more. I really to appreciate all the input..
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, Michael
> Barry <mbarry@> wrote:
> >
> > There are a couple of interesting items about your description of the
> performance issues. First is that you describe them as episodic and
> recurring rather than a general condition. Second, the instances you
> described are all database read instances (running a report, pauses in lines
> appearing in AP Invoice entry, etc..). A reasonably configured DB server
> should expect well above a 95% cache hit ratio so, for the most part, as far
> as reads are concerned the IO subsystem would be out of play. Have you
> checked your hit ratio?
> >
> > The fact that it is episodic is also curious. When it occurs, is it
> confined to a single workstation or does the entire system come to its
> knees? The instances you described seem to isolate the problem to a single
> user at a time. Is that the case or does the whole system just crawl at
> once?
> >
> > 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 10:22 AM, mmcwilliams22 wrote:
> >
> > > Ben did the install in 06. When we were sizing up the server I took
> exactly what they said to buy for the server at the time. I took the server
> recommendation & purchased that. I submited the specs of the server before
> purchasing it & it was all good to go. Anyways shame on me, I knew there
> would be something more to get from raid10, but if this is the cause of my
> problems recently I will need to change.
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Vic
> Drecchio" <vic.drecchio@> wrote:
> > > >
> > > > There is no way that Epicor recommended that.... Who did your install?
> > > > Epicor or a VAR/3rd party?
> > > >
> > > > Ben Nixon heads up that department and he is adamant about NOT doing
> > > > that.
> > > >
> > > > -----Original Message-----
> > > > 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:59 PM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .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 <mailto:vantage%40yahoogroups.com> .com,
> "Charlie Wilson" <foamdesigncsw@>
> > > > wrote:
> > > > >
> > > > > And everything is on this raid 1?
> > > > >
> > > > >
> > > > >
> > > > > ~Charlie
> > > > >
> > > > > _____
> > > > >
> > > > > 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:42 PM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .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]
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > 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. <http://groups.yahoo.com/group/vantage/files/>
> yahoo.com/group/vantage/files/.
> > > > (2) To search through old msg's goto:
> > > > http://groups. <http://groups.yahoo.com/group/vantage/messages>
> yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
> yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > >
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 2, 2010, 3:21pm

1. Start>>All programs>>OpenEdge X.XX>>Proenv

2. type command promon c:\epicor\mfgsys803\db\mfgsys (this will need
altered to fit your environment)

3. option 5

4. this will bring up a whole screen of information about the DB.

The Performance tuning document that is available on epicweb will explain
what most of this means but the one you might want to lool at is "Buffer
Hits"

~Charlie

_____

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

I see thie buffer hits all over the place when I refresh using promon.
55% 0% 65% 85% 100% etc. Is there a better way to get a ratio?

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

>
> If you are running progress it has a set of tools where you can see cache
> hit ratios.
>
>
>
> Let me know if you are on progress I'll give you directions so you can

check

> on your cache hit.
>
>
>
> ~Charlie
>
> _____
>
> 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 1:55 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: Vantage getting slower by the week.
>
>
>
>
>
> It is the whole system comming to a crawl. As soon as I get one call I

know

> I will get 10 more. I really to appreciate all the input..
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

Michael

> Barry <mbarry@> wrote:
> >
> > There are a couple of interesting items about your description of the
> performance issues. First is that you describe them as episodic and
> recurring rather than a general condition. Second, the instances you
> described are all database read instances (running a report, pauses in

lines

> appearing in AP Invoice entry, etc..). A reasonably configured DB server
> should expect well above a 95% cache hit ratio so, for the most part, as

far

> as reads are concerned the IO subsystem would be out of play. Have you
> checked your hit ratio?
> >
> > The fact that it is episodic is also curious. When it occurs, is it
> confined to a single workstation or does the entire system come to its
> knees? The instances you described seem to isolate the problem to a single
> user at a time. Is that the case or does the whole system just crawl at
> once?
> >
> > 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 10:22 AM, mmcwilliams22 wrote:
> >
> > > Ben did the install in 06. When we were sizing up the server I took
> exactly what they said to buy for the server at the time. I took the

server

> recommendation & purchased that. I submited the specs of the server before
> purchasing it & it was all good to go. Anyways shame on me, I knew there
> would be something more to get from raid10, but if this is the cause of my
> problems recently I will need to change.
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Vic

> Drecchio" <vic.drecchio@> wrote:
> > > >
> > > > There is no way that Epicor recommended that.... Who did your

install?

> > > > Epicor or a VAR/3rd party?
> > > >
> > > > Ben Nixon heads up that department and he is adamant about NOT doing
> > > > that.
> > > >
> > > > -----Original Message-----
> > > > 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:59 PM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .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 <mailto:vantage%40yahoogroups.com> .com,
> "Charlie Wilson" <foamdesigncsw@>
> > > > wrote:
> > > > >
> > > > > And everything is on this raid 1?
> > > > >
> > > > >
> > > > >
> > > > > ~Charlie
> > > > >
> > > > > _____
> > > > >
> > > > > 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:42 PM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .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.

<http://www.aspacia.com/> 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]
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > 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. <http://groups.

<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>

> yahoo.com/group/vantage/files/.
> > > > (2) To search through old msg's goto:
> > > > http://groups. <http://groups.

<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>

> yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > http://groups. <http://groups.

<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>

> yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > >
> > >
> >
> >
> >
> > [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, 3:52pm

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@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Tuesday, February 02, 2010 1:40 PM
To: vantage@yahoogroups.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>

________________________________

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 1:27 PM
To: vantage@yahoogroups.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@yahoogroups.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>
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@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:02 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.

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

system · February 2, 2010, 4:38pm

I believe you mentioned you are on SQL version, and you are backing up several times per day, are these full backups, or log backups? Are you sure the degraded performance does not coincide with a backup? I have found Volume Shadow Service helpful, but someone else mentioned to disable it. Are you in Simple or Full Recovery mode? Is your log file really bloated? How large is your data file?

Perfmon is going to be your friend in narrowing down any physical bottlenecks like disk I/O, CPU, memory. Offhand I would suggest that 4GB is pretty small by today's standards. If you have more slots, you can upgrade fairly cheaply.

Are you comfortable running SQL queries using SQL Server Management Studio (SSMS)? Try this script to see what SQL statement is currently executing on the server. Might help you determine what user activities are the dog.

USE [Mfgsys803]
GO
BEGIN
-- Do not lock anything, and do not get held up by any locks.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

-- What SQL Statements Are Currently Running?
SELECT [Spid] = session_Id
, ecid
, [Database] = DB_NAME(sp.dbid)
, [User] = nt_username
, [Status] = er.status
, [Wait] = wait_type
, [Individual Query] = SUBSTRING (qt.text,
er.statement_start_offset/2,
(CASE WHEN er.statement_end_offset = -1
THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
ELSE er.statement_end_offset END -
er.statement_start_offset)/2)
,[Parent Query] = qt.text
, Program = program_name
, Hostname
, nt_domain
, start_time
FROM sys.dm_exec_requests er
INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
WHERE session_Id > 50 -- Ignore system spids.
AND session_Id NOT IN (@@SPID) -- Ignore this current statement.
ORDER BY 1, 2
END

Jared
_______________________
Jared Allmond
IT Systems Engineer
Wright Coating Technologies
jallmond@...<mailto:jallmond@...>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007

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

system · February 2, 2010, 4:55pm

We are progress.
Sorry to take up so much of the forum today.
I notice at points stats like this in promon:
I wonder if these reads are really killing me.
Record Updates 9
Record Creates 2
DB Writes 91
BI Writes 3
Record Locks 1022
Record Reads 198728
DBReads 115146
Writes by APW 100%
Buffer Hits 72%
Writes by BIW 33%
DB size 977MB

--- In vantage@yahoogroups.com, Jared Allmond <jallmond@...> wrote:
>
> I believe you mentioned you are on SQL version, and you are backing up several times per day, are these full backups, or log backups? Are you sure the degraded performance does not coincide with a backup? I have found Volume Shadow Service helpful, but someone else mentioned to disable it. Are you in Simple or Full Recovery mode? Is your log file really bloated? How large is your data file?
>
> Perfmon is going to be your friend in narrowing down any physical bottlenecks like disk I/O, CPU, memory. Offhand I would suggest that 4GB is pretty small by today's standards. If you have more slots, you can upgrade fairly cheaply.
>
> Are you comfortable running SQL queries using SQL Server Management Studio (SSMS)? Try this script to see what SQL statement is currently executing on the server. Might help you determine what user activities are the dog.
>
> USE [Mfgsys803]
> GO
> BEGIN
> -- Do not lock anything, and do not get held up by any locks.
> SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
>
> -- What SQL Statements Are Currently Running?
> SELECT [Spid] = session_Id
> , ecid
> , [Database] = DB_NAME(sp.dbid)
> , [User] = nt_username
> , [Status] = er.status
> , [Wait] = wait_type
> , [Individual Query] = SUBSTRING (qt.text,
> er.statement_start_offset/2,
> (CASE WHEN er.statement_end_offset = -1
> THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
> ELSE er.statement_end_offset END -
> er.statement_start_offset)/2)
> ,[Parent Query] = qt.text
> , Program = program_name
> , Hostname
> , nt_domain
> , start_time
> FROM sys.dm_exec_requests er
> INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
> CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
> WHERE session_Id > 50 -- Ignore system spids.
> AND session_Id NOT IN (@@SPID) -- Ignore this current statement.
> ORDER BY 1, 2
> END
>
> Jared
> _______________________
> Jared Allmond
> IT Systems Engineer
> Wright Coating Technologies
> jallmond@...<mailto:jallmond@...>
> voice: 269.344.8195
> direct: 269.341.4353
> fax: 269.344.3007
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 2, 2010, 5:06pm

That Buffer hit is killing you IMO. Mine is above 95% all the time no matter
when I look.

You can also look at your disk que length

Start>>Run>>perfmon

You will want to remove the default metrics it is watching and then add this
one:

Performance Object: PhysicalDisk

Select Counters from list = True

Avg Disk Queue Length

Select the physical drive you want to watch you will probably only have 1

You want the average for this to stay below 1

There are other options to see read queue length and write queue length but
the overall queue length will defiantly show you if your drives is getting
pummeled.

~Charlie

_____

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

We are progress.
Sorry to take up so much of the forum today.
I notice at points stats like this in promon:
I wonder if these reads are really killing me.
Record Updates 9
Record Creates 2
DB Writes 91
BI Writes 3
Record Locks 1022
Record Reads 198728
DBReads 115146
Writes by APW 100%
Buffer Hits 72%
Writes by BIW 33%
DB size 977MB

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, Jared
Allmond <jallmond@...> wrote:

>
> I believe you mentioned you are on SQL version, and you are backing up

several times per day, are these full backups, or log backups? Are you sure
the degraded performance does not coincide with a backup? I have found
Volume Shadow Service helpful, but someone else mentioned to disable it. Are
you in Simple or Full Recovery mode? Is your log file really bloated? How
large is your data file?

>
> Perfmon is going to be your friend in narrowing down any physical

bottlenecks like disk I/O, CPU, memory. Offhand I would suggest that 4GB is
pretty small by today's standards. If you have more slots, you can upgrade
fairly cheaply.

>
> Are you comfortable running SQL queries using SQL Server Management Studio

(SSMS)? Try this script to see what SQL statement is currently executing on
the server. Might help you determine what user activities are the dog.

>
> USE [Mfgsys803]
> GO
> BEGIN
> -- Do not lock anything, and do not get held up by any locks.
> SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
>
> -- What SQL Statements Are Currently Running?
> SELECT [Spid] = session_Id
> , ecid
> , [Database] = DB_NAME(sp.dbid)
> , [User] = nt_username
> , [Status] = er.status
> , [Wait] = wait_type
> , [Individual Query] = SUBSTRING (qt.text,
> er.statement_start_offset/2,
> (CASE WHEN er.statement_end_offset = -1
> THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
> ELSE er.statement_end_offset END -
> er.statement_start_offset)/2)
> ,[Parent Query] = qt.text
> , Program = program_name
> , Hostname
> , nt_domain
> , start_time
> FROM sys.dm_exec_requests er
> INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
> CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
> WHERE session_Id > 50 -- Ignore system spids.
> AND session_Id NOT IN (@@SPID) -- Ignore this current statement.
> ORDER BY 1, 2
> END
>
> Jared
> _______________________
> Jared Allmond
> IT Systems Engineer
> Wright Coating Technologies
> jallmond@...<mailto:jallmond@...>
> voice: 269.344.8195
> direct: 269.341.4353
> fax: 269.344.3007
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · February 2, 2010, 5:17pm

Have you looked at the scatter factor on your database lately?

We had slowdown issues with certain activities since converting from 6.1
to 8.03. I ran the table analysis about 2 months ago and found it at 7.
After a dump and load, the scatter went down to 3.4, but more
importantly, the responsiveness was much better on the larger files.

William Hannah

Director of Finance

William Frick & Company

Direct: 847.918.7338

www.fricknet.com

________________________________

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

We are progress.
Sorry to take up so much of the forum today.
I notice at points stats like this in promon:
I wonder if these reads are really killing me.
Record Updates 9
Record Creates 2
DB Writes 91
BI Writes 3
Record Locks 1022
Record Reads 198728
DBReads 115146
Writes by APW 100%
Buffer Hits 72%
Writes by BIW 33%
DB size 977MB

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Jared Allmond <jallmond@...> wrote:

>
> I believe you mentioned you are on SQL version, and you are backing up

several times per day, are these full backups, or log backups? Are you
sure the degraded performance does not coincide with a backup? I have
found Volume Shadow Service helpful, but someone else mentioned to
disable it. Are you in Simple or Full Recovery mode? Is your log file
really bloated? How large is your data file?

>
> Perfmon is going to be your friend in narrowing down any physical

bottlenecks like disk I/O, CPU, memory. Offhand I would suggest that 4GB
is pretty small by today's standards. If you have more slots, you can
upgrade fairly cheaply.

>
> Are you comfortable running SQL queries using SQL Server Management

Studio (SSMS)? Try this script to see what SQL statement is currently
executing on the server. Might help you determine what user activities
are the dog.

>
> USE [Mfgsys803]
> GO
> BEGIN
> -- Do not lock anything, and do not get held up by any locks.
> SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
>
> -- What SQL Statements Are Currently Running?
> SELECT [Spid] = session_Id
> , ecid
> , [Database] = DB_NAME(sp.dbid)
> , [User] = nt_username
> , [Status] = er.status
> , [Wait] = wait_type
> , [Individual Query] = SUBSTRING (qt.text,
> er.statement_start_offset/2,
> (CASE WHEN er.statement_end_offset = -1
> THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
> ELSE er.statement_end_offset END -
> er.statement_start_offset)/2)
> ,[Parent Query] = qt.text
> , Program = program_name
> , Hostname
> , nt_domain
> , start_time
> FROM sys.dm_exec_requests er
> INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
> CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
> WHERE session_Id > 50 -- Ignore system spids.
> AND session_Id NOT IN (@@SPID) -- Ignore this current statement.
> ORDER BY 1, 2
> END
>
> Jared
> _______________________
> Jared Allmond
> IT Systems Engineer
> Wright Coating Technologies
> jallmond@...<mailto:jallmond@...>
> voice: 269.344.8195
> direct: 269.341.4353
> fax: 269.344.3007
>
>
>
> [Non-text portions of this message have been removed]
>

--------------------------------------------------------------------------

William Frick & Co's SmartMarkT RFID Named to 2008 Top Ten Products List

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

system · February 2, 2010, 5:18pm

Your buffer hit rate is way to low and so are your BI Writes. How many blocks are allocated in memory and how many bi buffers do you have set? Also, what are your spin lock retries set to?

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 1:55 PM, mmcwilliams22 wrote:

> We are progress.
> Sorry to take up so much of the forum today.
> I notice at points stats like this in promon:
> I wonder if these reads are really killing me.
> Record Updates 9
> Record Creates 2
> DB Writes 91
> BI Writes 3
> Record Locks 1022
> Record Reads 198728
> DBReads 115146
> Writes by APW 100%
> Buffer Hits 72%
> Writes by BIW 33%
> DB size 977MB
>
> --- In vantage@yahoogroups.com, Jared Allmond <jallmond@...> wrote:
> >
> > I believe you mentioned you are on SQL version, and you are backing up several times per day, are these full backups, or log backups? Are you sure the degraded performance does not coincide with a backup? I have found Volume Shadow Service helpful, but someone else mentioned to disable it. Are you in Simple or Full Recovery mode? Is your log file really bloated? How large is your data file?
> >
> > Perfmon is going to be your friend in narrowing down any physical bottlenecks like disk I/O, CPU, memory. Offhand I would suggest that 4GB is pretty small by today's standards. If you have more slots, you can upgrade fairly cheaply.
> >
> > Are you comfortable running SQL queries using SQL Server Management Studio (SSMS)? Try this script to see what SQL statement is currently executing on the server. Might help you determine what user activities are the dog.
> >
> > USE [Mfgsys803]
> > GO
> > BEGIN
> > -- Do not lock anything, and do not get held up by any locks.
> > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
> >
> > -- What SQL Statements Are Currently Running?
> > SELECT [Spid] = session_Id
> > , ecid
> > , [Database] = DB_NAME(sp.dbid)
> > , [User] = nt_username
> > , [Status] = er.status
> > , [Wait] = wait_type
> > , [Individual Query] = SUBSTRING (qt.text,
> > er.statement_start_offset/2,
> > (CASE WHEN er.statement_end_offset = -1
> > THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
> > ELSE er.statement_end_offset END -
> > er.statement_start_offset)/2)
> > ,[Parent Query] = qt.text
> > , Program = program_name
> > , Hostname
> > , nt_domain
> > , start_time
> > FROM sys.dm_exec_requests er
> > INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
> > CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
> > WHERE session_Id > 50 -- Ignore system spids.
> > AND session_Id NOT IN (@@SPID) -- Ignore this current statement.
> > ORDER BY 1, 2
> > END
> >
> > Jared
> > _______________________
> > Jared Allmond
> > IT Systems Engineer
> > Wright Coating Technologies
> > jallmond@...<mailto:jallmond@...>
> > voice: 269.344.8195
> > direct: 269.341.4353
> > fax: 269.344.3007
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>

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

system · February 2, 2010, 5:22pm

20K blocks in DB Buffer.
5 BI buffers
SpinLock are set to 50k. I guess I could bump to 80K
ODBC does not hit the disk que, but running any tracker or vantage form will make the que go above 1

--- In vantage@yahoogroups.com, Michael Barry <mbarry@...> wrote:
>
> Your buffer hit rate is way to low and so are your BI Writes. How many blocks are allocated in memory and how many bi buffers do you have set? Also, what are your spin lock retries set to?
>
> 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 1:55 PM, mmcwilliams22 wrote:
>
> > We are progress.
> > Sorry to take up so much of the forum today.
> > I notice at points stats like this in promon:
> > I wonder if these reads are really killing me.
> > Record Updates 9
> > Record Creates 2
> > DB Writes 91
> > BI Writes 3
> > Record Locks 1022
> > Record Reads 198728
> > DBReads 115146
> > Writes by APW 100%
> > Buffer Hits 72%
> > Writes by BIW 33%
> > DB size 977MB
> >
> > --- In vantage@yahoogroups.com, Jared Allmond <jallmond@> wrote:
> > >
> > > I believe you mentioned you are on SQL version, and you are backing up several times per day, are these full backups, or log backups? Are you sure the degraded performance does not coincide with a backup? I have found Volume Shadow Service helpful, but someone else mentioned to disable it. Are you in Simple or Full Recovery mode? Is your log file really bloated? How large is your data file?
> > >
> > > Perfmon is going to be your friend in narrowing down any physical bottlenecks like disk I/O, CPU, memory. Offhand I would suggest that 4GB is pretty small by today's standards. If you have more slots, you can upgrade fairly cheaply.
> > >
> > > Are you comfortable running SQL queries using SQL Server Management Studio (SSMS)? Try this script to see what SQL statement is currently executing on the server. Might help you determine what user activities are the dog.
> > >
> > > USE [Mfgsys803]
> > > GO
> > > BEGIN
> > > -- Do not lock anything, and do not get held up by any locks.
> > > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
> > >
> > > -- What SQL Statements Are Currently Running?
> > > SELECT [Spid] = session_Id
> > > , ecid
> > > , [Database] = DB_NAME(sp.dbid)
> > > , [User] = nt_username
> > > , [Status] = er.status
> > > , [Wait] = wait_type
> > > , [Individual Query] = SUBSTRING (qt.text,
> > > er.statement_start_offset/2,
> > > (CASE WHEN er.statement_end_offset = -1
> > > THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
> > > ELSE er.statement_end_offset END -
> > > er.statement_start_offset)/2)
> > > ,[Parent Query] = qt.text
> > > , Program = program_name
> > > , Hostname
> > > , nt_domain
> > > , start_time
> > > FROM sys.dm_exec_requests er
> > > INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
> > > CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
> > > WHERE session_Id > 50 -- Ignore system spids.
> > > AND session_Id NOT IN (@@SPID) -- Ignore this current statement.
> > > ORDER BY 1, 2
> > > END
> > >
> > > Jared
> > > _______________________
> > > Jared Allmond
> > > IT Systems Engineer
> > > Wright Coating Technologies
> > > jallmond@<mailto:jallmond@>
> > > voice: 269.344.8195
> > > direct: 269.341.4353
> > > fax: 269.344.3007
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 2, 2010, 5:36pm

Assuming that you are running the default 4k DB block size the 20k allocated blocks only allocates about 80meg of system memory for the DB. If you bump that number to 240k, you can allocate enough RAM for the entire DB. Also bump your BI buffers to 25. Spin lock should be 20k per core.

Give those a try and see how it works.

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 2:21 PM, mmcwilliams22 wrote:

> 20K blocks in DB Buffer.
> 5 BI buffers
> SpinLock are set to 50k. I guess I could bump to 80K
> ODBC does not hit the disk que, but running any tracker or vantage form will make the que go above 1
>
> --- In vantage@yahoogroups.com, Michael Barry <mbarry@...> wrote:
> >
> > Your buffer hit rate is way to low and so are your BI Writes. How many blocks are allocated in memory and how many bi buffers do you have set? Also, what are your spin lock retries set to?
> >
> > 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 1:55 PM, mmcwilliams22 wrote:
> >
> > > We are progress.
> > > Sorry to take up so much of the forum today.
> > > I notice at points stats like this in promon:
> > > I wonder if these reads are really killing me.
> > > Record Updates 9
> > > Record Creates 2
> > > DB Writes 91
> > > BI Writes 3
> > > Record Locks 1022
> > > Record Reads 198728
> > > DBReads 115146
> > > Writes by APW 100%
> > > Buffer Hits 72%
> > > Writes by BIW 33%
> > > DB size 977MB
> > >
> > > --- In vantage@yahoogroups.com, Jared Allmond <jallmond@> wrote:
> > > >
> > > > I believe you mentioned you are on SQL version, and you are backing up several times per day, are these full backups, or log backups? Are you sure the degraded performance does not coincide with a backup? I have found Volume Shadow Service helpful, but someone else mentioned to disable it. Are you in Simple or Full Recovery mode? Is your log file really bloated? How large is your data file?
> > > >
> > > > Perfmon is going to be your friend in narrowing down any physical bottlenecks like disk I/O, CPU, memory. Offhand I would suggest that 4GB is pretty small by today's standards. If you have more slots, you can upgrade fairly cheaply.
> > > >
> > > > Are you comfortable running SQL queries using SQL Server Management Studio (SSMS)? Try this script to see what SQL statement is currently executing on the server. Might help you determine what user activities are the dog.
> > > >
> > > > USE [Mfgsys803]
> > > > GO
> > > > BEGIN
> > > > -- Do not lock anything, and do not get held up by any locks.
> > > > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
> > > >
> > > > -- What SQL Statements Are Currently Running?
> > > > SELECT [Spid] = session_Id
> > > > , ecid
> > > > , [Database] = DB_NAME(sp.dbid)
> > > > , [User] = nt_username
> > > > , [Status] = er.status
> > > > , [Wait] = wait_type
> > > > , [Individual Query] = SUBSTRING (qt.text,
> > > > er.statement_start_offset/2,
> > > > (CASE WHEN er.statement_end_offset = -1
> > > > THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
> > > > ELSE er.statement_end_offset END -
> > > > er.statement_start_offset)/2)
> > > > ,[Parent Query] = qt.text
> > > > , Program = program_name
> > > > , Hostname
> > > > , nt_domain
> > > > , start_time
> > > > FROM sys.dm_exec_requests er
> > > > INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
> > > > CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
> > > > WHERE session_Id > 50 -- Ignore system spids.
> > > > AND session_Id NOT IN (@@SPID) -- Ignore this current statement.
> > > > ORDER BY 1, 2
> > > > END
> > > >
> > > > Jared
> > > > _______________________
> > > > Jared Allmond
> > > > IT Systems Engineer
> > > > Wright Coating Technologies
> > > > jallmond@<mailto:jallmond@>
> > > > voice: 269.344.8195
> > > > direct: 269.341.4353
> > > > fax: 269.344.3007
> > > >
> > > >
> > > >
> > > > [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 3, 2010, 2:55am

Are you using MES or Office MES for production.

If so, make sure that users are clocking out every night or when necessary - If this is not done it ccan impact the speed significantly.

you can also run 8920 and 8930 in admin to see the current usage within jobs and see if peeps are actually clocking out.

>