Best Practices for Running Temenos T24 on SQL Server and Windows Server

SQL Server provides an ideal database platform for TEMENOS T24. By choosing the Microsoft platform, T24 customers experience faster funds transfers, higher security-trade volumes, and quicker close-of-business processes. This white paper provides best practices for configuring and running T24 on SQL Server 2012, SQL Server 2008 R2, and Windows Server 2008 R2, including guidance for building…

0

White Paper: SQL Server 2008 R2 Provides Enterprise-Class Performance and Scalability for SunGard Front Arena

Today’s investors demand a wider variety of asset classes, more complex financial instruments, and a broader geographical range of products than ever before. SunGard meets these demands with Front Arena, an integrated cross-asset platform for sales, trading and risk management, operations, and distribution. Front Arena was designed to handle very large data flows; in high-volume…

0

Misys: Managing Risk & Compliance in a Volatile Market: Streamlining Trades and Ensuring ROI (Free Aberdeen Webinar!)

Global financial turmoil has grown, from the credit crisis crippling many financial institutions, to the current debt crisis that is bringing much valuation uncertainty to the capital markets. Within this market uncertainty is the firms continued commitment to reduce operational risk and cost, ensure regulatory compliance, and improve ROI measures. These initiatives are a necessary…

0

RedPrairie: Removing Unneeded Table Indices

By David Erickson, RedPrairie I wrote some internal notes to our developers recently, that I called “Lessons from the Lab”. I had the pleasure of joining RedPrairie’s WM Product Development team at a Microsoft testing lab in Dallas, Texas, with the intent of benchmarking WM 2009.2 and 2010.1 on SQL Server 2008 with various database configurations. …

2

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

Fundamentals: DBCC – SQL Server’s FDISK

[Prior Post In Series]     [Backup Series]  [Next Post in Series] In a time long long ago (last millennium), DBCC was known as Database Consistency Checker; today it stands for Database Console Command. It performs many functions similar to what the old utility FDISK did on hard drives — checks for errors of various types and…

0

Tuning Enovia Smarteam – End Solution

[Prior Post in Series] The result of the tuning exercise is TSQL shown below. The items included are those suggested by Database Engine Tuning Advisor (DTA) evaluated as being prime candidates by the author. The performance improvement expected is at least 15% and may be considerably more. A trace log of your operational SmarTeam should…

0

Backups: Doing it right so you can recover quickly!– Automating the backups

[Prior Post]    [Next Post] Getting backups scheduled appropriately tends to be a slow process with a lot of keying and mouse clicks.  The process can be simplified by the use of a couple of scripts that will backup every database on your SQL Server (including databases added to your SQL Server later!) There are three…

1

Tuning Enovia SmarTeam — Statistics

[Prior Post in Series] [Next Post in Series] Adding statistics helps SQL Server to determine which tables to scan first when there are joins. To understand statistics better, see Statistics Used by the Query Optimizer in Microsoft SQL Server 2005. Statistics are typically added after indexes because if there is an index on the column…

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