I'm on SQL so should of worked, but I probably mucked something up along the way. Thanks for the info Brian i'll give it another whirl.
-Ramsey
-Ramsey
--- In vantage@yahoogroups.com, "Jeff Stockard" <jeff.stockard@...> wrote:
>
> If you are using Open4 you can't set your database to read only. Open4 will
> not work with a read only database.
>
> Jeff
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Brian W. Spolarich
> Sent: Tuesday, July 07, 2009 11:03 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: vantage 8.03.407a speed very slow
>
>
>
>
>
>
>
>
> The service-pack level shouldn't matter. The issues are the same.
>
> The read-only schema holder change is a big improvement, particularly for
> reports and sales order entry screens (at least for us).
>
> It took a bit of tinkering to get the appservers to start as I mis-read the
> .pf settings a couple of times. Once I did it correctly it worked as
> expected.
>
> Basically you purge the transactions from the Progress database, make the
> files read-only, and then tell the appserver in its .pf file about the new
> changes.
>
> The nonclustered index thing is separate, but also included in the SQL
> performance tuning guide. You basically run a bunch of ALTER statements
> against the DB and it changes the properties of the table indexes which
> improves INSERT performance if I remember correctly. You can verify whether
> its been done by looking at the Unique flag on the
> <tablename>#_#progress_recid index:
>
> You can verify that the index script was run. To do this:
> 1. Launch SQL Server Management Studio.
> 2. Connect to the server.
> 3. In the Object Explorer, navigate to: Database > Mfgsys803 > Tables >
> dbo.AbcCode > Indexes
> 4. Right-click on abccode#_#progress_recid.
> 5. From the context menu, select Properties.
> 6. If the Unique check box is selected, the index script has not run.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
> bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
> www.advancedphotonix.com
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of alldoneprojects
> Sent: Tuesday, July 07, 2009 10:14 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: vantage 8.03.407a speed very slow
>
> I very carefully followed the support document on how to make the schema
> holder read only but after that the app servers would never start. Any
> advice on what procedure worked for you? Was the non-clustered index a part
> of that as well, I'm not sure I remember that. I'm on .407 don't know if
> that makes any difference.
>
> -Ramsey
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brian
> W. Spolarich " <bspolarich@> wrote:
> >
> > For us at least with 8.03.405 MSSQL the thing that made the performance
> issue go away was to implement the nonclustered index schema changes and
> making the Progress schema holder database read-only. Once I did this
> performance improved considerably.
> >
> > -bws
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
> > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of Mark Wagner
> > Sent: Monday, July 06, 2009 9:26 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] vantage 8.03.407a speed very slow
> >
> > Glad to help, there are of course other things that can be done and should
> be looked at suc as your network environment (i.e. running gigabyte
> switching), your desktops running at least 1gb of memory, processors, etc
> that may or may not be warranted once the user environment is stabilized
> after go live
> >
> > If you have any other questions feel free to ask
> >
> > --- On Mon, 7/6/09, LeAnn Marruffo <lmarruffo@> wrote:
> >
> >
> > From: LeAnn Marruffo <lmarruffo@>
> > Subject: RE: [Vantage] vantage 8.03.407a speed very slow
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Date: Monday, July 6, 2009, 12:37 AM
> >
> >
> >
> >
> >
> >
> >
> >
> > Mark,
> >
> > Thank you so much! You hit on some of the things we do pretty
> > regularly- the folks who print pick slips are impatient. One of the
> > bigger challenges is to get folks to stop clicking in the screen. I have
> > an ISR (inside sales) who is so fast on the mouse and keyboard that
> > vantage can't keep up- she's not letting the system load what it needs
> > to go to the next buffered key stroke. They are coming off a very old
> > system, and those habits are going to die hard, I'm afraid. We will
> > check for the things you've described, though. We are already in the
> > process of moving to a totally separate test environment. It was a hard
> > battle getting them to understand why I needed it- maybe this will help
> > them understand.
> >
> > Thanks again!
> >
> > - leAnn
> >
> > From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
> > Of Mark Wagner
> > Sent: Friday, July 03, 2009 7:01 AM
> > To: vantage@yahoogroups .com
> > Subject: Re: [Vantage] vantage 8.03.407a speed very slow
> >
> > Leann, there are a lot of variables that affect performance, whether
> > client based or Citrix or both. As you go throughout the day obviously
> > things will slow down as more people start to run more reports and in
> > your case, start to "explore" the system if you are a fairly new
> > install.
> >
> > Some basic things to look at assuming you are running one server
> >
> > Make sure all your app servers and databases are not running (i.e.
> > Train, Test, Pilot) except your production mfgsys database and related
> > app servers. If these other databases and app servers are running they
> > are consuming memory and should be shut down
> >
> > Look at your system monitor. Are people running the same report over and
> > over again? Many times in new start ups if users dont see reports
> > immediately they continue to click on them, generating more reports,
> > which can have a huge impact on performance. Train people to look at
> > their system monitor after running a report if you havent done so
> > already. Be careful again with some reports they may not appear because
> > they simply didnt have any data, they will appear as an error in the
> > system monitor. Click on the detail tab on the report and it will tell
> > you if it didnt run due to no records selected
> >
> > Running reports are a big part of performance with new installs.
> > Sometimes people are on the system "just running reports and trackers"
> > to learn. Make your users aware that they should only be running those
> > reports that are needed. Again, look at your system monitor. If users
> > are running the same reports consider archiving those reports so others
> > can run them from the system monitor without having to recreate them
> >
> > If some of the issue is opening up dashboards, queries, trackers for the
> > first time, have your users go into tools/options and set memory cache
> > on those screens they use frequently. They will open up a lot quicker,
> > but be careful not to have an individual user set more than about 5 of
> > their favorite screens to use the cache option as it will reserve memory
> > on their machine
> >
> > If certain reports can be run overnight or in the morning, off peak time
> > (especially Gl reports) consider putting them on schedules and run them
> > when there are few if any users on the server
> >
> > Make sure your APP servers are tuned correctly. There are tuning PDF
> > documents if you need or work with Epicor technical support to make sure
> > they are set correctly
> >
> > Look at your server and watch the performance monitor throughout the
> > day. Look to see when peak demand is highest and what is consuming the
> > most memory and CPU. If there are other processes running on the server
> > that dont need to be make sure they are shut down as well
> >
> > Lastly, if you are running multiple sales order lines on sales order
> > entry, Epicor can be very slow when you start to get over 100 lines on
> > an order, If this is the case with you there are other suggestions which
> > can be offered
> >
> > These are the basics to start with. Let me know if you would like more
> > suggestions
> >
> > --- On Thu, 7/2/09, leann_37 <lmarruffo@steren. com
> > <mailto:lmarruffo% 40steren. com> > wrote:
> >
> > From: leann_37 <lmarruffo@steren. com <mailto:lmarruffo% 40steren. com> >
> > Subject: [Vantage] vantage 8.03.407a speed very slow
> > To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> > Date: Thursday, July 2, 2009, 7:00 PM
> >
> > All,
> > We are running Citrix for the most part, but added a couple of stations
> > running the client install in order to compare speed. At first, the
> > client install was fast compared to Citrix, but it got slower across the
> > day, and had more crashes. How are the crashes affecting client
> > performance, if at all?
> > We just went live last weekend, and it is being compared to their old
> > Dataworks. No one expects it to be as fast as dataworks- it does a lot
> > more than we were asking of the old system, but we weren't really
> > prepared for this type of slow performance.
> > Any opinions or suggestions would be appreciated!
> > Thanks!
> > - leAnn
> >
> > [Non-text portions of this message have been removed]
> >
> > Click here
> > <https://www. mailcontrol. com/sr/wQw0zmjPo HdJTZGyOCrrhg= =
> > AIlFt!onkasiaXMFXb7 5eO8hE!qwbbbTlit LRkMuvIdUTQ= => to report this email
> > as spam.
> >
> > This message has been scanned for malware by SurfControl plc.
> www.surfcontrol. com
> >
> > [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/.
> <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/.
> <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]
>