Running OpenText Email Monitoring and Records Management on SQL Server 2012 provides excellent performance and scalability

In February 2012, OpenText and Microsoft conducted “real-world” performance and scalability testing on the Email Monitoring and Records Management components of the OpenText ECM offering running on SQL Server 2012. The tests measured thepeak ingestion of email messages, in addition to the throughput when ingestion and dispositions of email messages were running concurrently. The benchmark…

0

Impressive Results: SQL Server 2012 and OpenText Email Monitoring and Records Management

In February 2012, OpenText and Microsoft conducted performance and scalability testing on the email-monitoring and records-management components of the OpenText ECM Suite running on the Microsoft SQL Server 2012 data-management software. The benchmark testing was very successful, with a peak ingestion of 995,000 email messages in a single hour, 14.8 million messages in a 24-hour period,…

0

OpenText: Multiple Instances or a Single Instance of SQL Server - Part 4: Uninstalling Instances

[Prior Post] In the prior post of this series, I recommended not uninstalling the other SQL Server instances unless you are planning to reuse the license elsewhere.  Reasons to retain the instance include: It can take a significant amount of time to do compared to disabling. It will only free up a little disk space. If…

0

OpenText: Multiple Instances or a Single Instance of SQL Server - Part 3: Disabling Instances

[Prior Post]   [Next Post] In the prior post of this series, we showed how to move databases to one SQL Server instance. Once this process is completed, we need to disable or uninstall the other instances. My recommendation is to always disable instances and delay uninstalling the instance. Disabling the instance is quick and can be…

0

OpenText: Multiple Instances or a Single Instance of SQL Server - Part 1: Counting Instances

[Next Post] OpenText often installs with two SQL Server databases. One database is for OpenText and the other database is for Microsoft SharePoint Server. This often leads to random acts of installation including putting two or more instances of SQL Server on the same computer. This situation should be avoided for several reasons: Each instance consumes a license,…

0

OpenText: When cash counts, go Microsoft SQL Server

Recently I reviewed Steve Simpson’s OPENTEXT document “OpenText eDOCS DM 5.3 – Technical Architecture, Tips and Tricks” and noticed some useful information worth repeating. Financial Cost difference between Oracle™and SQL Server I extracted the table below from the above presentation to illustrate key factors emphasized. Aspect Oracle Database 11g SQL Server 2008 R2 Staff DBA Required…

0

Migration: The value gained moving from Oracle to SQL Server 2008R2

[DB2 Migration Value]  [Sybase Migration Value] In the early 1980’s I was an Oracle Developer on mainframes and on MS-DOS using Oracle 5.1 on MS-DOS (distributed on some 20+ diskettes — I still have them). It was an interesting time because PC products like dBase II were power-user friendly but did not scale. Oracle scaled, but was…

0

OpenText: Guidance for Administrators

Contributed by Steve Simpson Optimizing your database is the key to good performance.  OpenText libraries are created with generic performance parameters to support the basic document and record creation for an average customer site. Indexes created on the database by Library Generator benefit when clients tune them to their environment. As the volume of data…

0

OpenText: Business Development Bank of Canada using SQL Server for their Commercial Lending Solution

On March 28th, 2011 Business Development Bank of Canada (BDC) signed an agreement with the CGI Group for detailed analysis, manufacturing, testing and rollout of the commercial lending IT solution. This solution will be based on Microsoft technology consisting of three parts the customer relationship management system Dynamics CRM, the enterprise content management system OpenText…

0