Hi, I am working with a couple of the top BMC Solution Architects on a project at the moment who have seen scalability issues on earlier versions (< 2005) when working on enterprise customers with terra bytes of data i.e. 40 million + CI's, large Incident and attachment counts, etc.
The performance took a massive hit when the database reached large numbers. That said MS SQL 2008 introduced a Resource Governor and Performance Data Collector, along with other tools, for better performance tuning, and later versions have improved on this further. This closed the gap on Oracle by being more "tuneable". If you have good DBA's, then you should have no issues. The difference between Standard and Enterprise is what number of CPU's are supported e.g. Standard supports 4, Enterprise the OS maximum. Enterprise is geared toward mission critical, large enterprises. It offers enterprise scalability, high availability and security. If you are a small to medium deployment that does not rapidly grow, then Standard is recommended. There is a large array of information available for comparisons of the versions along with the features introduced over the versions. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad Esser Sent: 05 September 2012 22:01 To: [email protected] Subject: Re: Oracle vs. SQL ** Carl, We just made the descisioni to switch to MS SQL from Oracle due to licensing costs, so I think you are right about that. Having never worked with MS SQL though, I am curious what sort of scalability issues exist? Also, my architect was asking if we needed the Enterprise Edition or if Standard suffices. Why would one be chosen over the other (in the context of ARS, full ITSM suite/CMDB)? Thanks, Thad On Wed, Sep 5, 2012 at 1:46 PM, Carl Wilson <[email protected]> wrote: ** Hi, there are still question marks around the scalability of MS SQL, but the later version have come a long way in a short period of time so if running the latest supported version of MS SQL there "should" be no issues. I think the licensing is no killing Oracle as I am seeing a number of customer move away from this and do to MS SQL (or DB2 - which does not seem to have as much support from BMC). Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tauf Chowdhury Sent: 05 September 2012 21:43 To: [email protected] Subject: Oracle vs. SQL ** All, To those of you who have run Remedy on both Oracle and SQL DB, do you have a preference as to which is better/stable/faster etc..? I know SQL has come a long way. Any opinions are welcome. -- Tauf Chowdhury _attend WWRUG12 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
