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...
Date: 05/25/2011
Kilimanjaro Ships!
SQL Server 2008 R2 launches today! While the name “R2” sounds like an incremental update to SS2008...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 02/27/2008
Spool operators in query plan...
I came across a question in the relationalserver.performance newsgroup where a customer was...
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...
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...
Date: 05/11/2007
Implement Parallel Execution in SSIS
SQL Server Integration Services (SSIS) allows parallel execution in two different ways. These are...
Date: 05/11/2007
Something about SSIS Performance Counters
SQL Server Integration Services provide a set of performance counters. Among them the following few...
Date: 05/01/2007
Set BLOBTempStoragePath and BufferTempStoragePath to Fast Drives
BLOBTempStoragePath and BufferTempStoragePath are two properties on Data Flow Task. They define...
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...
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...
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...
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...
Date: 04/11/2007
Microbenchmarking
Microbenchmarking is the art of testing your machine's basic configuration like disk latency, memory...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
Date: 02/12/2007
Database Applications Profile Survey
We are conducting a survey to better understand SQL Server workloads. Please consider providing your...
Date: 02/04/2007
Welcome!
Welcome to the new bloggy home of Microsoft’s small but mighty SQL Performance Team! Lots of smart...
Date: 01/24/2007