Browse by Tags

Related Posts
  • Blog Post: Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes

    [Prior Post in Series] [Next Post in Series] In my prior posts, I looked at adding indexes with Database Engine Tuning Advisor. In this post, I will look at the other side of the coin and delete indexes that are unused or that cost more resources than they save. Indexes primary use is to find records...
  • Blog Post: 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...
  • Blog Post: Fundamentals: Creating a Workload by Using a Trace Log

    [Next Post in Series] This is the kick-off post of a regular Friday series of posts, " Basic Skills for SQL Server ISV Administrators ". I have found that ISV Administrators are often Professional Engineers (P.E.) -- rich in business knowledge and light in Information Technology expertise. In this...
  • Blog Post: 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...
  • Blog Post: Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

    [Prior Post in Series] [Next Post in Series] In my last post Fundamentals: Creating a Workload by Using a Trace Log , I illustrated how to create a workload. In this post, I will look at the complimentary step, using the log as input to the Database Engine Tuning Advisor to identify performance...
  • Blog Post: Tuning Enovia SmarTeam – Indexes – Part 1

    [Prior Post in Series] [Next Post in Series] Adding indexes helps SQL Server retrieve records in a table faster. There is a special type of index called ‘clustered’; a clustered index determines the physical order of the records on the disk. For the most common reads, you want the records...
  • Blog Post: Tuning Enovia SmarTeam - Indexes - Conclusion

    [Prior Post in Series] [Next Post in Series] In this part, I will deal with the fact that many remaining tables do not have clustered indexes on them. In my humble opinion, ANY reasonable order of the disk will perform better than a random order, so putting a clustered index on every table is a must...
  • Blog Post: Index Fragmentation–“If it isn’t broken, don’t fix it”

    Indexes get fragmented. It’s a fact of database life and something that every DBA has to deal with but we do get a choice on HOW we deal with it. The phrase “If it isn’t broken, don’t fix it” is made in reference to SQL Server Maintenance Plans and more specifically the...
  • Blog Post: SQLCAT: Table-Valued Functions and tempdb Contention

    Steve Howard from the SQLCAT team recently published a great article on Table-Valued Functions (TVFs) and tempdb Contention. SQLCAT Article: Table-Valued Functions and tempdb Contention Here is the overview: "tempdb contention can be caused by using multi-statement table-valued functions (TVFs...
  • Blog Post: Using RCSI with Kronos

    Author: This article is written by our contributing author Ken Lassesen. His bio can be found here . Recently, I observed the impact that turning on RCSI had on a Kronos installation, and I was impressed by the reduction in blockages that were created by super-users' ad hoc queries. RCSI...
  • Blog Post: Recommendations for Monitoring Performance of the Temenos T24 Database Tier

    You should perform system monitoring during development of your system and periodically during production. Before “going live,” look for bottlenecks and gauge your ability to scale to your expected long-term workload. Once in production, you should create a performance baseline and monitor...
  • Blog Post: Tuning Enovia Smarteam at Langen Packaging Group – Summary

    [Prior Post in Series] [Next Post in Series] Recently I had an opportunity to do an example tuning on an Enovia SmarTeam installation. Marc Young at xML Solutions arranged for me to work with the folks at Langen Packaging Group in Mississauga, Ontario. Mirek Tokarz facilitated the access: dealing...
  • Blog Post: OpenText: Multiple Instances or a Single Instance of SQL Server - Part 2: Moving Databases

    [Previous Post] [ Next Post ] In our last post, we described how random acts of installation may result in two or more instances of SQL Server on the same machine. If you are reading this post, you are likely the proud owner of such a machine. Moving SQL Server databases is a very rare event for most...
  • Blog Post: 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...
  • Blog Post: Tuning Enovia SmarTeam – Indexes – Part 2

    [Prior Post in Series] [Next Post in Series] In this post I continue on with index analysis from my prior post. First, I will intentionally walk you into a dead end to illustrate when things go wrong and what you should do. Second I will take the right path and show the results. I took the wrong...
  • Blog Post: Update Statistics Job for Temenos T24

    According to the Optimizing Windows and SQL Server for Temenos T24 whitepaper it is recommended to keep the AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS databases options on. The whitepaper also recommends creating a maintenance plan to update statistics. Q: If AUTO_UPDATE_STATISTICS is enabled...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Desire2Learn: Improving Performance

    Recently I reviewed some public posts on Desire2Learn SQL Server Performance and extracted some recommendations of common issues: Often, I have seen an increase of CPUs without increasing RAM or the number of TempDB files. Each CPU (or core on a CPU) creates a "mini-PC". A configuration with 4 GB...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Tuning ISV SQL Server databases - Overview

    [Next Post in Series - SmarTeam Tuning] In the following months, I hope to do some hands-on tuning of various ISV SQL Server databases in use at client sites. Some folks would assume that there is nothing to do – the ISV have already tuned it. I hate to disappoint you, but as an ISV Architect...
  • Blog Post: Kronos: Improving the performance of ad-hoc reports up to 3600%

    One of Kronos' features is the ability to build ad-hoc reports. With SQL Server, the ability for a power-user to generate almost any type of report exists. The issue often arises that while you get your report -- eventually; the performance time is not ideal. One part of the solution is the use of read...