Hello All, In my opinion is much easier to admin a MS SQL than Oracle. You do not need any special skills. I have done it for 6 years. For better integration with other applications developed on Oracle we decided to migrate ARS server to ORCL. My advice is to my a machine with at least 2 separate controllers. Create a data base spread on 2 HDDs. Each HDD has to be on separate controller. On one HDD you must keep all field in a form except: attachments, memo and indexes. This technique applies to any RDBMS, including ORCL & MSSQL. It delivers a performance 10 times faster than a normal configuration. For MS SQL you can reserve some memory and processor. As I sayed I am not a database expert. For this reason I have maid mistackes whe ARS was running on MS SQL. After we migrated to ORCL, the Orcl DBA discoverd something running for 2 hours. Usesles to say that on MS SQL with the above configuration there was no penality regardin performange. Daniel
________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ex Soundgarden Sent: Tuesday, May 04, 2010 9:37 AM To: [email protected] Subject: UNIX to Windows Remedy Migration ** Hi ARSListers! We're currently planning to migrate existing Remedy environment in Sun Solaris to Windows Server. Below is the current system information: ARS 7.0.1 p10 running on Sun Solaris 10 Oracle 10g running on the same server Mid-tier 7.0.1 patch 6 running on MS Windows Server 2003 Memory size 8GB 4 UltraSPARC-IIIi virtual processors each running on 1.6GHz No ITSM applications installed. AR System is used for in-house developed applications (consisting of 1052 forms). average of 60-70 concurrent users. 600 registered users Initial possible scenario I'm currently looking at 2 options below: 1.Upgrade Remedy Server to latest version, purchase new hardware, and use the same platform (Solaris 10) . OR 2. Full migration to Windows Server 2008, including the database migration to SQL Server 2008. This is to reduce the cost of our support and maintenance for the servers Please give me any advice if what option is the best to implement. I'm really keen on just using the same platform (Solaris) but we currently don't have any Solaris/Oracle support which pretty much led us to looking at the Windows migration. If you can list all the pros and cons on doing any of the options, that will surely help me. In addition to that, may I know if anyone here has any experiences migrating from Unix to Windows environment recently or in the past? If you can let me know your success stories (and migration strategy), it would be greatly appreciated. Any good inputs will be appreciated. Regards... Gabud _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************* This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ******************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
