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

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

RedPrairie: Improving performance by using Parallelism

By David Erickson, RedPrairie Most of you know that computer CPUs are not getting faster anymore, instead they are getting more cores. Microsoft SQL Server has two parameters that control whether work goes to one core or to many cores. I’d like to give a simple explanation of these two factors and share my experience…

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

Siemens: Using compression to improve performance and reduce costs

In prior posts, I have described the benefit of Read-Committed Snapshot Isolation (RCSI). RCSI will usually benefit most ISV databases. Another method may benefit many ISV databases (running on SQL Server 2008 and later):  compression. Compression is often ignored because of user experiences with the apparent slowness of zipping and unzipping files. There is an important…

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

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