[Axapta-Knowledge-Village] Error Journal Posting A key with the name 0,00 already exists
Title: RecID Dear all,Do you have any idea how we can solve that problemthxsas Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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.
[Axapta-Knowledge-Village] Poor Working set SQlservr ( SQL )
Dear all, We're running SQL2K EE (sp3a)and Windows 2K3 ( SP1) with 16 GB physical memory , we already set : Boot.ini /3GB /PAE AWE enabled sql memory setting dynamic 0 to 14 GB set working set to 1 but when we check working set for sqlservr is always less than 250 MB , even i have already to select a big table Does any body has the solution for this problem . thank you regrads' sas 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.
Re: [Axapta-Knowledge-Village] Re: SQL Server SP4
SP4 , does not support AWE yet ! - Original Message - From: Kang Shang Yie [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, June 15, 2005 11:03 AM Subject: [Axapta-Knowledge-Village] Re: SQL Server SP4 Hi Harry, My client is running with this spec. without problem. No worry. Regards, Kang --- In Axapta-Knowledge-Village@yahoogroups.com, Harry \(Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Hopefully someone can help me. 1. Is Axapta certified for SQL server 2000 sp 4? 2. Is it a practice to certify Axapta against any sql service pack? 3. Is there any one who is using Axapta with SQL server 2000 sp 4? regards harry - Discover Yahoo! Get on-the-go sports scores, stock quotes, news more. Check it out! Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Inventory amount adjustment some warehouse not shown ???
Dear all, we want to do on hand amount adjustment on an item number , if we check on "ON Hand" inventory , there are several warehouse over there , but when we wanna do "on hand amount inventory adjustment " we saw the warehouse number is less then on "on hand inventory ". ( suppose if check on hand inventory , there are warehouse a1,a2,a3 but when we will do on hand amount adjustment only warehouse a1 and a2 over there ). do you have any idea how we can show all warehouse ? thx sas Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Split SQL table into multi drive partition
Dear Madhur, thank you very much for your response , I wan to do this it's because , we want to add more disk on database sql server , since our sql database running on windows cluster environtment , so we can not just add that new disk into old array , because on cluster environtment the disk should be basic can not dynamic disk , on the other hand if we want to add disk , the disk type configuration should dynamic disk , otherwise we have to scratch existing disk and the create a new partition . thx sas - Original Message - From: madhur halapeti To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, June 06, 2005 4:13 PM Subject: Re: [Axapta-Knowledge-Village] Split SQL table into multi drive partition Hi SAS, This is possible. But please confirm why you want to do this. Normally partitioning is done to improve database performance. The tables you want to place on the newly created X Drive what purpose will they serve. Anyways, after confirming please follow the steps: The first thing you will have to do is create filegroups. That means you will have to create secondary files within the database. The file extention will be .ndf by default. You can do this in Enterprise Manager. Go to the properties of the database and in the data files tab add a new entry just below the primary filegroup row. For eg: 1. FileName (This can be anything but follow a naming convention)2. Location (Give the location on your new X Drive)3. Space Allocated (as per your requirements)4. Filegroup (Give a new name to this filegroup. Again follow a naming convention) Clicking on ok will create a filegroup on your new X Drive. You can cross check by looking for the file you just created on the X Drive. Now select the table that you want to move to this filegroup, i.e. on X Drive. Right Click on this table and select Design Table. Right Click any cloumn and click on properties from the context menu. On the tables tab, select the newly created filegroup in the Table Filegroup combo box. This will move the table to the newly created filegroup on X Drive. Try this out first on a temporary database and then apply on the live Axapta database. Revert in case you need any clarifications. Thanks and RegardsMadhurSAS [EMAIL PROTECTED] wrote: Dear all, does any one on the list has any experience how to split sqltable into multi partition drive ? background : on SQL database Cluster we want to add another partition ( ex. current partition database on drive R: , we want to add new disk array suppose we called X ) is it possible to move some tables into X ? ) thx sas Sharing the knowledge on Axapta. How much free photo storage do you get? Store your friends n family photos for FREE with Yahoo! Photos. http://in.photos.yahoo.com Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Split SQL table into multi drive partition
Dear all, does any one on the list has any experience how to split sqltable into multi partition drive ? background : on SQL database Cluster we want to add another partition ( ex. current partition database on drive R: , we want to add new disk array suppose we called X ) is it possible to move some tables into X ? ) thx sas Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Inventory Calculation and Adjustment ( Urgent )
Just make sure you have already installed SP3.
when you run inventory closing , please monitor your sql server performance
1. CPU utilization ( higher is better )
2.(database) avg disk queue lenght ( less is better . max . 2X number disk
array database )
3.buffer cache ratio ( 90 % )
4. page/second on memory ( less is better )
please let me know your hardware configuration , database server , OAS
server , cpu , disk , memory , network configration
please try to ping to your data base server and AOS server ( should be less
the 30 ms )
hth
sas
ps. we have 5 millions records on inventtrans or at least 30 records on
calculated month with 30 users ( 10 workstations ) running invent closing
we can achive 15 hours , database server 8 CPU , 8 GB memory , AWE enabled ,
10 disk array 15K rpm 40 % utilization .
- Original Message -
From: Gokhan Can [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com;
Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, June 02, 2005 12:58 PM
Subject: YNT: [Axapta-Knowledge-Village] Inventory Calculation and
Adjustment ( Urgent )
Hi;
I did the things you said but I am very conserned about the performance and
maybe deadlock on the calculation.
We started calculation on monday night and It worked for monday night,
tuesday ( all day ) , tuesday night
, wednesday ( till noon ) , wednesday night and still not finished and the
calculation list is getting larger.
We have 198000 transactions on InventTrans for the calculated month.
Is it normal or is something going wrong ??
Gkhan CAN
Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kiinin yerine: SAS
Gnderilmi: ar 01.06.2005 11:48
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: Re: [Axapta-Knowledge-Village] Inventory Calculation and Adjustment
( Urgent )
suppose you already on Axapta 3.0 SP3 ,
here my recomendations :
1. please run Inventory closing by 2 tier configuration
2.Please run multiple inventory closing on multiple workstation as much as
possible ( depend on user license )
3. Run inventory closing at night
4. if in the morning the calculation not finished yet , stop the calculation
by calculation stop button and continue later
5.To address this issue, customers' system administrators must add one line
in
the InventCostItemDim\run before the first while loop:
loopX = 0;
as shown in the following:
else
{
this.updateSettleRefItem(inventCostList.ItemId);
mapLoopTrans= new map(types::INTEGER,types::RECORD);
mapLoopDim = new map(types::INTEGER,types::RECORD);
loopX = 0;
queryRun =
inventCostHelp.initQueryRunTrans(this.inventTable(inventCostList.ItemId));
while (queryRun.next())
{
loopX++;
mapLoopTrans.insert(loopX,queryRun.get(tableNum(InventTrans)));
mapLoopDim.insert(loopX,queryRun.get(tableNum(InventDim)));
}
loopMax = loopX;
loopX = 0;
while (loopX loopMax)
{
loopX++;
this.updateItemDim(mapLoopTrans.lookup(loopX),mapLoopDim.lookup(loopX));
}
}
HTH
sas
- Original Message -
From: Gokhan Can [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Wednesday, June 01, 2005 3:45 PM
Subject: [Axapta-Knowledge-Village] Inventory Calculation and Adjustment (
Urgent )
Hi;
We started our inventory calculation on Monday ( this is not good ) and it
is still going on but there is
unhappiness about the performance of the system today very badly.
What if we select Calculation - Stop Calculation and at night when weight
gets lower select Calculation - Help Calculation ??
Does the calculation brake down or does it handle calculation from place
that it
paused ??
Has anyone tried stop and restart calculation before ??
and also I got an error message like ( The value 1 is not found in the map )
but I select help calculation ..
Is this a problem about calculation ??
Gkhan CAN
mailto:[EMAIL PROTECTED]
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Yahoo! Groups Sponsor ~--
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Inventory Calculation and Adjustment ( Urgent )
suppose you already on Axapta 3.0 SP3 ,
here my recomendations :
1. please run Inventory closing by 2 tier configuration
2.Please run multiple inventory closing on multiple workstation as much as
possible ( depend on user license )
3. Run inventory closing at night
4. if in the morning the calculation not finished yet , stop the calculation
by calculation stop button and continue later
5.To address this issue, customers' system administrators must add one line
in
the InventCostItemDim\run before the first while loop:
loopX = 0;
as shown in the following:
else
{
this.updateSettleRefItem(inventCostList.ItemId);
mapLoopTrans= new map(types::INTEGER,types::RECORD);
mapLoopDim = new map(types::INTEGER,types::RECORD);
loopX = 0;
queryRun =
inventCostHelp.initQueryRunTrans(this.inventTable(inventCostList.ItemId));
while (queryRun.next())
{
loopX++;
mapLoopTrans.insert(loopX,queryRun.get(tableNum(InventTrans)));
mapLoopDim.insert(loopX,queryRun.get(tableNum(InventDim)));
}
loopMax = loopX;
loopX = 0;
while (loopX loopMax)
{
loopX++;
this.updateItemDim(mapLoopTrans.lookup(loopX),mapLoopDim.lookup(loopX));
}
}
HTH
sas
- Original Message -
From: Gokhan Can [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Wednesday, June 01, 2005 3:45 PM
Subject: [Axapta-Knowledge-Village] Inventory Calculation and Adjustment (
Urgent )
Hi;
We started our inventory calculation on Monday ( this is not good ) and it
is still going on but there is
unhappiness about the performance of the system today very badly.
What if we select Calculation - Stop Calculation and at night when weight
gets lower select Calculation - Help Calculation ??
Does the calculation brake down or does it handle calculation from place
that it
paused ??
Has anyone tried stop and restart calculation before ??
and also I got an error message like ( The value 1 is not found in the map )
but I select help calculation ..
Is this a problem about calculation ??
Gkhan CAN
mailto:[EMAIL PROTECTED]
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Yahoo! Groups Sponsor ~--
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Account number for transaction type does not exist ???
Dear All, We get this error Account number for transaction type ' ' does not exist , when we do update costing on production order . Do we miss something on parameter setup posting Inventory management ? thx Sas Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?
Dear Rocco , As far as I know AWE memory only possible on SQL 2000 Enterprise edition . - Original Message - From: Rocco Giumelli To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, March 08, 2005 10:46 AM Subject: RE: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Varden/SAS Can you explain 'We already enabled AWE Memory'. When we deployed Axapta no mention by our MBS Partner was given to the type of SQL we needed to own, We Purchased SQL Standard Edition, and of Late I discovered that this version is not able to Handle 3Gb of RAM. There is also no upgrade path from Standard to Enterprise. Before I get the boss to spend more cash on this SQL Upgrade, do you know of any way to get SQL to use 3GB of RAM on the Standard Edition. ps. Also any Tips on Table Indexing. Rocco From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Monday, 7 March 2005 7:15 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Sas, Please let us know the cause of your problem when you look at the code. SAS [EMAIL PROTECTED] wrote: Dear Verden , In my opinion , as long as the disk performance is not bottle neck ( ex. Avg disk queue lenght= 2 X number disk ) it is not necessary to modify raid configuration. for memory , we already enabled AWE memory . thx sas - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, March 05, 2005 1:24 AM Subject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Sas The hardware looks good to me, away from the RAID 5 for the database. RAID 5 does not give good performance for writing since it involves the calculation of parity. I made a mistake in my first email to you. We do not use RAID 15 but RAID 10. RAID 15 also involves parity. It is a combination of RAID 10 and RAID 5. RAID 10 is a combination of RAID 1 (mirror) and RAID 0 (striped). You only use 50% of your storage but you get good performance for writing. Did you configure windows and SQL to see 3G of memory and over? There are some tools that you can use to find the exact problem. They are costly but they work. Spotlight for SQL and windows work well. It shows up all the flaws. Our consultant used it to solve our problems and we are currently in the process of purchasing the software. Sometimes the log file disk could be running out of space and you dont know and this slows down the entire system. The problems are endless and many. The code could very well be a problem too. Have you done a lot of customization? If this is the case you may have code that is inefficient. SAS [EMAIL PROTECTED] wrote: Dear Verden, my Hadrware configuration , Database server , 4 Proccessor 3.0 Ghz , 8 GB RAM , Quorum : 2 Disk raid 1, Tempdb 2 Disk raid 1 , database 7 Disk Raid 5 , all disk are Fibre channel 2 Gb disk 15K rpm. For application server 2 Proccessor 3.0 Ghz , 2 GB RAM .Concurent user 70 users. I tought my hardware configuration are enough ,So I suspect it's bacuse our coding . my experience tuning hardware , OSand SQL server only give 10% improvement, table indexing also improve the performance . and now we are investigating our coding. thx sas - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 04, 2005 12:58 AM Subject: RE: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Rocco If disk queue and swapping are acceptable for the object server during peak periods this should be an indication that the object server(s)is ok. We had 1G of memory and two Pentium III processors in two object servers. The disk queue was high as a result of the processors not being able to adequately manage the requests from the clients. Also, there was a lot of swapping resulting from the memory not being enough. For some reason this resulted in the database locking up.Rocco Giumelli [EMAIL PROTECTED] wrote: Hi Varden Can I ask, We have recently upgraded our SQL Server
Re: [Axapta-Knowledge-Village] AOS on SQL server Cluster problem ????
Dear Verden , thank you for your reply promtly , our problem is when database server move to 2nd database server , the connection bewwen AOS to the 2nd database is down ( that why all axapta client are down ), so we have to restart the AOS , after restarting the AOS , the axapta client will running normal .. thx sas - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, March 07, 2005 6:55 PM Subject: Re: [Axapta-Knowledge-Village] AOS on SQL server Cluster problem Hi Sas, We had the same problem. This results from a timeout of the Axapta application. The application has a limited timeout period to wait on the database and when that period is exceeded the application will fail. The time that the resources take to switch from one server to the next is a function of the load on the server at the time of failure. The smaller the load is the quicker the switch. The only way you may get around this problem is to use the active-active mode of the clustering for SQL. At the moment you are using active-passive. From the materials I have read for SQL I understand that the active-active mode is more complicated. The overall performance will be better because the resources are shared across both servers and if one server goes down the other will carry the load provided that the resources being used at the time of failure are less than or equal to the resources available on the up server. Performance will degrade after failure since one server will be carrying the load. The only form of clustering available for the application server is load balancing which is also a part of the OS as in the case of SQL clustering. In this case the application is central to both AOS. The AOS is not the application as many people may believe. It is a windows service that loads the application and makes the necessary connections to the database for the client(s). With the application files in a central location you setup both AOS to load the files from that location so that all clients will see the same application. In the case of a failure of one of the AOS the client(s) on that AOS will loose connection. All incomplete transactions will be rolled back and the client(s) just need to restart the program to regain access. In order for this kind of clustering to take place you have to type -cluster=clutername in the advanced text box on both AOS and also type the same thing in the advanced text box for each clients configuration. When you have done this the OS will and ensure that each AOS has half of the connections as users connect and disconnect. In other words a new connection will always be made to the AOS with the lease connections. If both AOS have the same number of connections I do not know how the system decide which one should get the next connection. SAS [EMAIL PROTECTED] wrote: when server database 1 have any problem ( network ..etc ) , the cluster will automatically move the SQL server to the second database server ( of course we should assign that second database into cluster administration ). - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, March 05, 2005 12:30 AM Subject: Re: [Axapta-Knowledge-Village] AOS on SQL server Cluster problem Hi Sas Could you please explain what you mean by "move from DB server1 into db Server 2." VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] SAS [EMAIL PROTECTED] wrote: Dear ll,We get problem on AOS when try to move from DB server1 into db Server 2 ,there are no problem on SQL , but all the axapta client disconnecting ,until we have to restart the axapta object server ( we're running on 3 Tiersenvironment) ,Would you mind sharing your axperience , how to implement AOS on CLusterenvirontment .Thank youregards'SasSharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Grou
Re: [Axapta-Knowledge-Village] AOS on SQL server Cluster problem ????
when server database 1 have any problem ( network ..etc ) , the cluster will automatically move the SQL server to the second database server ( of course we should assign that second database into cluster administration ). - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, March 05, 2005 12:30 AM Subject: Re: [Axapta-Knowledge-Village] AOS on SQL server Cluster problem Hi Sas Could you please explain what you mean by "move from DB server1 into db Server 2." VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] SAS [EMAIL PROTECTED] wrote: Dear ll,We get problem on AOS when try to move from DB server1 into db Server 2 ,there are no problem on SQL , but all the axapta client disconnecting ,until we have to restart the axapta object server ( we're running on 3 Tiersenvironment) ,Would you mind sharing your axperience , how to implement AOS on CLusterenvirontment .Thank youregards'SasSharing the knowledge on Axapta. __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ?
Dear Verden , In my opinion , as long as the disk performance is not bottle neck ( ex. Avg disk queue lenght= 2 X number disk ) it is not necessary to modify raid configuration. for memory , we already enabled AWE memory . thx sas - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, March 05, 2005 1:24 AM Subject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Sas The hardware looks good to me, away from the RAID 5 for the database. RAID 5 does not give good performance for writing since it involves the calculation of parity. I made a mistake in my first email to you. We do not use RAID 15 but RAID 10. RAID 15 also involves parity. It is a combination of RAID 10 and RAID 5. RAID 10 is a combination of RAID 1 (mirror) and RAID 0 (striped). You only use 50% of your storage but you get good performance for writing. Did you configure windows and SQL to see 3G of memory and over? There are some tools that you can use to find the exact problem. They are costly but they work. Spotlight for SQL and windows work well. It shows up all the flaws. Our consultant used it to solve our problems and we are currently in the process of purchasing the software. Sometimes the log file disk could be running out of space and you dont know and this slows down the entire system. The problems are endless and many. The code could very well be a problem too. Have you done a lot of customization? If this is the case you may have code that is inefficient. SAS [EMAIL PROTECTED] wrote: Dear Verden, my Hadrware configuration , Database server , 4 Proccessor 3.0 Ghz , 8 GB RAM , Quorum : 2 Disk raid 1, Tempdb 2 Disk raid 1 , database 7 Disk Raid 5 , all disk are Fibre channel 2 Gb disk 15K rpm. For application server 2 Proccessor 3.0 Ghz , 2 GB RAM .Concurent user 70 users. I tought my hardware configuration are enough ,So I suspect it's bacuse our coding . my experience tuning hardware , OSand SQL server only give 10% improvement, table indexing also improve the performance . and now we are investigating our coding. thx sas - Original Message - From: Varden Morris To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 04, 2005 12:58 AM Subject: RE: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? Hi Rocco If disk queue and swapping are acceptable for the object server during peak periods this should be an indication that the object server(s)is ok. We had 1G of memory and two Pentium III processors in two object servers. The disk queue was high as a result of the processors not being able to adequately manage the requests from the clients. Also, there was a lot of swapping resulting from the memory not being enough. For some reason this resulted in the database locking up.Rocco Giumelli [EMAIL PROTECTED] wrote: Hi Varden Can I ask, We have recently upgraded our SQL Server, But the application server we didn't becasue when I look at the task manager the machine does not do much, systemidle is running 90% + , and the Networkwork interface runs at less than 10% on 100 link most of the time. Has Scsi Hard Drive. It indicates to me that an upgrade is not needed.. Would you agree? Rocco From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 March 2005 7:59 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] how to minimize blocking on axapta ? The two main things I know can affect blocking are hardware and code. I have experienced major blocking as a result of hardware. I understand the technical concept involved but I do not have all the details at hand. You can use one server as the application and database server but this may not be ideal for your situation. The best configuration for top performance is at least one database server with a SAN unit for the data and an application server that may also be the object server if you are going 3-Tier. You may optionally use a different server for the object server. One object server should be adequate for up to one hundred users. Over that you may use two in load balancing mode. Now blocking can be a result of the existence of a bottle neck with your hardware. The client in a 2-tier configuration and the object server in a 3-tier configuration
[Axapta-Knowledge-Village] AOS on SQL server Cluster problem ????
Dear ll, We get problem on AOS when try to move from DB server1 into db Server 2 , there are no problem on SQL , but all the axapta client disconnecting , until we have to restart the axapta object server ( we're running on 3 Tiers environment) , Would you mind sharing your axperience , how to implement AOS on CLuster environtment . Thank you regards' Sas Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
