RE: [Axapta-Knowledge-Village] Peformance Issues

[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. Also I have un-checked the initialize for unicode' in the Configuration.   I did, come across this is a forum post: -AOS=hostIPaddress:port   The user said that they added as part of the command line parameters? I am wondering what does this do?   Anyway I am hoping that someone can give me some more feedback as to what I can do to help improve things. I have re-indexed everything, synchronized everything, etc. etc.   -Brandon From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: Tuesday, December 13, 2005 3:54 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Peformance Issues Hello All,    I was wondering if anyone has ever came across using the Clustered Index and Primary Index property fields of an Axapta table? Do setting these help performance at all?   We this week just started having issues with performance and Axapta. I have been running performance analyzer on SQL server and it seems as though the page life expectancy has dropped from an avg. values in secs. of 5200 down to 1650. This is the only real indication of the problem we are seeing. All the rest of the SQL related performance items are doing just about the same. The page life expectancy counter tells you, on average, how long data pages are staying in the buffer. The higher the number the better. Dropping number here means more memory is having to be used, and accessed more frequently.   Anyway I am puzzled, and I am trying to find out the best way to address this, as the memory in our SQL server is more than enough. I was wondering if anyone has any suggestions, as my eye's are getting tired from looking at the same data and not coming up with anything new....   thanks in advance....   -Brandon Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools 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.