Re: [Axapta-Knowledge-Village] AOS on SQL server Cluster problem ????

[SAS]

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 client’s 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."   Varden Morris   J. Wray & Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I.   Phone:  (876) - 923 - 6141 Ext. 2226 Fax:      (876) - 923 - 5372 Cell:      (876) - 3833566 Email:   [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 Tiers environment) , Would you mind sharing your axperience , how to implement AOS on CLuster environtment . Thank you regards' Sas Sharing 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! 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.