SQL Server Performance

Best Practices, Tips, Benchmarks, Troubleshooting and Monitoring - SQL Server, ADO.NET, Analysis Services, and SSIS

The “Balanced Data Distributor” for SSIS

The “Balanced Data Distributor” for SSISLen Wyatt, SQL Server Performance Team There is...

Author: SQL Server Performance Team Date: 05/25/2011

Kilimanjaro Ships!

SQL Server 2008 R2 launches today! While the name “R2” sounds like an incremental update to SS2008...

Author: Len Wyatt Date: 04/21/2010

New TPC Results on SQL Server 2008 R2

On November 2, 2009, Unisys published two new TPC results (TPC-E and TPC-H) using the newly...

Author: Len Wyatt Date: 11/30/2009

Great New TPC-H Results with SQL Server 2008

  Our partners at Dell and HP have published 2 new TPC-H results with SQL Server 2008 using...

Author: Len Wyatt Date: 08/17/2009

Using SSIS to get data out of Oracle: A big surprise!

Since late last year, Microsoft has made the Attunity connectors to Oracle databases available to...

Author: Len Wyatt Date: 08/14/2009

Great new SQL Server performance on Intel's Xeon 5500 series, aka Nehalem-EP

Yesterday, Intel launched its new Xeon 5500 series processors, code named Nehalem-EP. This is...

Author: Len Wyatt Date: 03/31/2009

An ETL World Record Revealed (Finally)

We suppose a more appropriate title would have been: Better Late Than Never. David should begin by...

Author: Len Wyatt Date: 03/03/2009

Windows Server 2008 + SQL Server 2008 = Geo-replication Benefits

After running an experiment, using datacenters on each coast of the U.S., our friends in MSCOM ops...

Author: Len Wyatt Date: 11/24/2008

SQL Server is Movin' On Up!

At last week's WinHEC in Los Angeles, SQL GM Quentin Clark joined Windows Server VP Bill Laing on...

Author: Len Wyatt Date: 11/10/2008

TPC-E – Raising the Bar in OLTP Performance

Glenn Paulley, Director of Engineering at Sybase iAnywhere, posted a commentary titled “The State of...

Author: Len Wyatt Date: 10/23/2008

SQL Server 2008 is on its way with great performance

Just left the final shiproom meeting for SQL Server 2008, and am happy to say every team has signed...

Author: Len Wyatt Date: 08/06/2008

SQL Server 2008 launched today, with great performance and scalability

Today, as the old saying goes, is a red-letter day, with the launch of Windows Server 2008, Visual...

Author: Len Wyatt Date: 02/27/2008

ETL World Record!

Today at the launch of SQL Server 2008, you may have seen the references to world-record performance...

Author: Len Wyatt Date: 02/27/2008

Spool operators in query plan...

I came across a question in the relationalserver.performance newsgroup where a customer was...

Author: Len Wyatt Date: 08/30/2007

What's swimming in your bufferpool?

When doing a performance investigation a useful thing to do is look at what data is present in the...

Author: Len Wyatt Date: 05/18/2007

Adjust buffer size in SSIS data flow task

The data flow task in SSIS (SQL Server Integration Services) sends data in series of buffers. How...

Author: Len Wyatt Date: 05/11/2007

Implement Parallel Execution in SSIS

SQL Server Integration Services (SSIS) allows parallel execution in two different ways. These are...

Author: Len Wyatt Date: 05/11/2007

Something about SSIS Performance Counters

SQL Server Integration Services provide a set of performance counters. Among them the following few...

Author: Len Wyatt Date: 05/01/2007

Set BLOBTempStoragePath and BufferTempStoragePath to Fast Drives

BLOBTempStoragePath and BufferTempStoragePath are two properties on Data Flow Task. They define...

Author: Len Wyatt Date: 05/01/2007

Set up OLE DB source to read from View efficiently

Introduction OLE DB source adapter is one of the most commonly used components in SSIS data flow...

Author: Len Wyatt Date: 04/29/2007

Getting Optimal Performance with Integration Services Lookups

Introduction Most users see good performance from SSIS packages using out-of-the-box configurations...

Author: Len Wyatt Date: 04/24/2007

What’s so temporary about tempdb?

Other than #temptables, @localvariables and many other objects being stored in tempdb what’s so...

Author: Len Wyatt Date: 04/13/2007

SQL Server 2005 SP2 Re-release and post fixes

Bob Ward from PSS has a wonderful blog article that explains the details about the re-release of SQL...

Author: Len Wyatt Date: 04/11/2007

Microbenchmarking

Microbenchmarking is the art of testing your machine's basic configuration like disk latency, memory...

Author: Len Wyatt Date: 04/09/2007

New MSDN Books Online search functionality

Check out the new Books Online search functionality online. The link below provides a scoped search...

Author: Len Wyatt Date: 03/30/2007

SQL Server 2005 Performance Dashboard Reports

The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be...

Author: Len Wyatt Date: 03/29/2007

OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL Server 2005 SP2

SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new...

Author: Len Wyatt Date: 03/23/2007

Two handy papers on common database performance considerations

Len posted recently the link to the new Analysis Services performance guide. If you also care about...

Author: Len Wyatt Date: 03/23/2007

SQL Server 2005 SP2 has been released...

SQL Server 2005 Service Pack 2 has been released. You can find more information from the service...

Author: Len Wyatt Date: 02/19/2007

High Volume Update Performance

SQL Server does a great job of optimizing processing across a wide range of runtime scenarios, while...

Author: Len Wyatt Date: 02/16/2007

Storage Modes in Analysis Services

Why did we only use the MOLAP storage mode in Project REAL? There is also ROLAP and HOLAP storage,...

Author: Len Wyatt Date: 02/12/2007

Using SAN Volumes in Project REAL

Introduction As we started Project REAL, we were fortunate to be able to use multiple machines and...

Author: Len Wyatt Date: 02/12/2007

Analysis Services 2005 Performance Guide

Do you want to know how to get the best performance out of Analysis Services? Whether you have an...

Author: Len Wyatt Date: 02/12/2007

Database Applications Profile Survey

We are conducting a survey to better understand SQL Server workloads. Please consider providing your...

Author: Len Wyatt Date: 02/04/2007

Welcome!

Welcome to the new bloggy home of Microsoft’s small but mighty SQL Performance Team! Lots of smart...

Author: Len Wyatt Date: 01/24/2007