RE : [Axapta-Knowledge-Village] Peformance Issues

2005-12-14 Thread Steeve Gilbert
e-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Brandon George Envoyé : 14 décembre 2005 06:08 À : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] Peformance Issues   Yes I did commit out the credit check long ago, because it was taking forever on so

RE: [Axapta-Knowledge-Village] Peformance Issues

2005-12-14 Thread Varden Morris
-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Peformance Issues   Thanks!    My next step is to use the code profiler. The thing that is strange, is that just last week it was performing fine, and there have been Zero code changes to the code in the area that is s

RE: [Axapta-Knowledge-Village] Peformance Issues

2005-12-14 Thread Brandon George
[mailto:[EMAIL PROTECTED] On Behalf Of Hennie PotgieterSent: Wednesday, December 14, 2005 5:57 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Peformance Issues Hi,   Have a look at http://www.sql-server-performance.com/gv_clustered_indexes.asp   As you

RE: [Axapta-Knowledge-Village] Peformance Issues

2005-12-14 Thread Hennie Potgieter
ndon   From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: Wednesday, December 14, 2005 1:47 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Peformance Issues Hi Brandon,   We also had major perform

RE: [Axapta-Knowledge-Village] Peformance Issues

2005-12-14 Thread Brandon George
-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie PotgieterSent: Wednesday, December 14, 2005 1:47 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Peformance Issues Hi Brandon,   We also had major performance problems on our Axapta

RE: [Axapta-Knowledge-Village] Peformance Issues

2005-12-14 Thread Harry Deshpande
Hi Brandon   I am not very familiar with SQL server however….   I think cluster index will perform better if you have a single company in the database or out of the total companies in the database there is just one company that is very big and active. In this case what you could do is

RE: [Axapta-Knowledge-Village] Peformance Issues

2005-12-13 Thread Hennie Potgieter
f Of Brandon George Sent: 14 December 2005 02:14 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Peformance Issues   I have been researching, and done as much as I can with indexes / indices. I have added some to a couple of Axapta Tables, that according to

RE: [Axapta-Knowledge-Village] Peformance Issues

2005-12-13 Thread Brandon George
I have been researching, and done as much as I can with indexes / indices. I have added some to a couple of Axapta Tables, that according to SQL Index Tuning Wizard should improve overall performance by 18%. This will be some what of a boost, but not quite the at least 25% I was hoping for