RE: RE : [Axapta-Knowledge-Village] Performance analysis

[ANIL OZAY]

Yes i think so,   We had performance bottenecks about SQL Server. We looked that Disk Queue values are very high, CPU is normal, RAM is normal.. We changed disk system to better, set AWE and changed priority of the SQL Server to high. Also we added extra indexes to many tables. Everything is normal now;) SQL Server performance is the most important factor for Axapta.   Regards,   Anil Ozay Software Engineer   From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Harry (Harshawardhan Deshpande Sent: Wednesday, October 26, 2005 10:39 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE : [Axapta-Knowledge-Village] Performance analysis   hi Steve   Dont have a clue about SQL server and I am no expert on hardware.   But I had a client who had the same problem. We got in an electronic expert who identified the problem with number of read-write heads on the sql server, problem with the temporary memory on sql server and some network card on the machine that hosted sql server.   Dont know how he figured out the problem but that did the trick.   you are looking at a person who has a degree in electronics with substantially experience with sql server and some experience with Axapta   regards   harry Steeve Gilbert <[EMAIL PROTECTED]> wrote: Hi Harry and Brandon,   Here's our setup for a 60 users environment:   1 AOS Dual 1.3 Ghz 1 gig RAM   1 DB Server Dual 1.3 Ghz 3 gig RAM DB : 4 SCSI disks Raid 10 Log : 2 SCSI disks Mirror OS : 2 SCSI disks Mirror   Brandon : We're already did a review from the ground up and added some RAM to our DB server and now the sqlserver uses 1.7 gig and there's always 1gig available.  The real bottleneck we've found is the Read on our DB disks.  When looking at the windows performance tool we can see "Avg. Disk Read Queue Length" hitting real high for long period of time.  I'm guessing some querys uses Table Scan.  That's why I wanted to reduce read by reviewing bad queries in the code.  Our DB disk setup with pretty much the best we can do before going on a SAN.  Our AOS seems at ease with the work load.  That's why I'm now arrived at step 4, looking at the code.   Harry : No specific place in Axapta.  What I want to do is reduced Table Scan globally and minimize blocking.  For blocking I will start to look at custom process that does a lot of inventory transfer in 1 long transaction and try to split it up.  Blocking here is a major pain.  It can happen 3 times a day sometimes.  They usually resolve themselves out but the more it takes time, the more people get blocked.   Finally, I'm using the SQL Profiler to check query with long duration.  Sometimes, when I see lines like : exec sp_cursorexecute 241, @P1 output, @P2 output, @P3 output, @P4 output, 'boa', 0, 0, 'boa', '596965' How can I know the query that is executed?   Thanks for reading thru, Regards, Steeve...   -----Message d'origine----- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] De la part de Brandon George Envoyé : 20 octobre 2005 07:54 À : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] Performance analysis   Steve,    The improvement of performance, for any system, starts always at the bottom level. So I would do the following:   (1) Can you improve your system through hardware? (ex: increase RAM, CPU, Speed of Hard Drives, etc.) (2) Can you increase performance at the Database level? (ex: RAM of SQL server, SQL server AWE configuration, Multiple Processors, un-needed performance drags by Non-Axapta Queries., clustering.) (3) Can you increase performance at the Business level? (ex: have two AOS server for load balance, etc.) (4) Can you increase performance through code? (ex: making sure Axapta-SQL statements make use of Indices, review large chunks of code and break them down into more efficient functional blocks of code, etc.)   This is how I would approach it... from the ground up, not the other way around.   -Brandon   From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Steeve Gilbert Sent: Wednesday, October 19, 2005 9:15 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Performance analysis Hi everyone,     I'm currently looking at ways to improve performance of our installation.  When looking thru menus I stumble upon "Performance analysis" in Administration -> Performance test wizard.  I've run it in our Dev environment to see what it does and the result was just an info box with the name of some forms.  What does it do and where are the result of that analysis?     Btw, if you have any hints at where to look to improve performance/minimize blocking (software way) besides maximizing the use of index, let me know.   Have a nice day, Steeve...   Yahoo! FareChase - Search multiple travel sites in one click. Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz. This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS  Visit your group "Axapta-Knowledge-Village" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.