SQL Server Performance
Best Practices, Tips, Benchmarks, Troubleshooting and Monitoring - SQL Server, ADO.NET, Analysis Services, and SSIS
The “Balanced Data Distributor” for SSISLen Wyatt, SQL Server Performance Team There is...
Date: 05/25/2011
SQL Server 2008 R2 launches today! While the name “R2” sounds like an incremental update to SS2008...
Date: 04/21/2010
On November 2, 2009, Unisys published two new TPC results (TPC-E and TPC-H) using the newly...
Date: 11/30/2009
Our partners at Dell and HP have published 2 new TPC-H results with SQL Server 2008 using...
Date: 08/17/2009
Since late last year, Microsoft has made the Attunity connectors to Oracle databases available to...
Date: 08/14/2009
Yesterday, Intel launched its new Xeon 5500 series processors, code named Nehalem-EP. This is...
Date: 03/31/2009
We suppose a more appropriate title would have been: Better Late Than Never. David should begin by...
Date: 03/03/2009
After running an experiment, using datacenters on each coast of the U.S., our friends in MSCOM ops...
Date: 11/24/2008
At last week's WinHEC in Los Angeles, SQL GM Quentin Clark joined Windows Server VP Bill Laing on...
Date: 11/10/2008
Glenn Paulley, Director of Engineering at Sybase iAnywhere, posted a commentary titled “The State of...
Date: 10/23/2008
Just left the final shiproom meeting for SQL Server 2008, and am happy to say every team has signed...
Date: 08/06/2008
Today, as the old saying goes, is a red-letter day, with the launch of Windows Server 2008, Visual...
Date: 02/27/2008
Today at the launch of SQL Server 2008, you may have seen the references to world-record performance...
Date: 02/27/2008
I came across a question in the relationalserver.performance newsgroup where a customer was...
Date: 08/30/2007
When doing a performance investigation a useful thing to do is look at what data is present in the...
Date: 05/18/2007
The data flow task in SSIS (SQL Server Integration Services) sends data in series of buffers. How...
Date: 05/11/2007
SQL Server Integration Services (SSIS) allows parallel execution in two different ways. These are...
Date: 05/11/2007
SQL Server Integration Services provide a set of performance counters. Among them the following few...
Date: 05/01/2007
BLOBTempStoragePath and BufferTempStoragePath are two properties on Data Flow Task. They define...
Date: 05/01/2007
Introduction OLE DB source adapter is one of the most commonly used components in SSIS data flow...
Date: 04/29/2007
Introduction Most users see good performance from SSIS packages using out-of-the-box configurations...
Date: 04/24/2007
Other than #temptables, @localvariables and many other objects being stored in tempdb what’s so...
Date: 04/13/2007
Bob Ward from PSS has a wonderful blog article that explains the details about the re-release of SQL...
Date: 04/11/2007
Microbenchmarking is the art of testing your machine's basic configuration like disk latency, memory...
Date: 04/09/2007
Check out the new Books Online search functionality online. The link below provides a scoped search...
Date: 03/30/2007
The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be...
Date: 03/29/2007
SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new...
Date: 03/23/2007
Len posted recently the link to the new Analysis Services performance guide. If you also care about...
Date: 03/23/2007
SQL Server 2005 Service Pack 2 has been released. You can find more information from the service...
Date: 02/19/2007
SQL Server does a great job of optimizing processing across a wide range of runtime scenarios, while...
Date: 02/16/2007
Why did we only use the MOLAP storage mode in Project REAL? There is also ROLAP and HOLAP storage,...
Date: 02/12/2007
Introduction As we started Project REAL, we were fortunate to be able to use multiple machines and...
Date: 02/12/2007
Do you want to know how to get the best performance out of Analysis Services? Whether you have an...
Date: 02/12/2007
We are conducting a survey to better understand SQL Server workloads. Please consider providing your...
Date: 02/04/2007
Welcome to the new bloggy home of Microsoft’s small but mighty SQL Performance Team! Lots of smart...
Date: 01/24/2007