Hi Bhupesh, One thing that no one has mentioned on this thread is the consideration of case sensitivity. If you want case-insensitive searches then MS-SQL would be a better bet. However db performance would be reduced compared to Oracle. Since it is MS-SQL your choice of OS becomes more clear ...
Oracle Provides Case-Insensitive searching but it is my understanding that the performance of the DB is reduced dramatically when it is turned on (I'm sure someone on the list may disagree). Another option is to use Oracle and utilize "Full Text Search" cabability within Remedy. This requires some customization in that you must choose the fields that belong to the "Full Text Search" capability but also requires more resources for your app server. The advantage of this approach is that you get the faster Oracle performance (case-sensitive) with the advantages of case-insensitive searches. In addition I would recommend separating your app server from your DB server if you haven't decided that already. 7.6 has new search capabilities which may make this an irrelevant discussion. I have been burned before because I did not bring up the case insensitive issue. Just speaking from experience. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bhupesh Gupta Sent: Wednesday, October 05, 2011 5:19 AM To: arslist@ARSLIST.ORG Subject: BMC Performance Matrix on ARS 7.6.04 on Different OS ** Hi - Does anybody has any input or any matrix on Performace og BMC ARS on different OS, so that We can take a decision that Which OS is more suitable. I have option of both Windows 2008 or Unix , but on Which OS BMC Product's performace is better. Please advise -- Regards, Bhupesh Gupta _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
