Kilimanjaro Ships!

SQL Server 2008 R2 launches today! While the name “R2” sounds like an incremental update to SS2008 (or half of a Star Wars droid), in fact Kilimanjaro (the internal code name) is packed with big features. We’ve also got a lot to show for our work on performance and scalability. The four results at the…


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 stage, to announce our upcoming support for more than 64 logical processors, the current limit in Windows and SQL Server. This expanded scale-up capability is planned to be released in SQL Server code named “Kilimanjaro”, when running…


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 off, so the product is now in the hands of manufacturing, and in process toward web and media availability for you. We’ve shipped! MSDN and TechNet subscriber downloads are now live, with more to come. It’s been…


ETL World Record!

Today at the launch of SQL Server 2008, you may have seen the references to world-record performance doing a load of data using SSIS.  Microsoft and Unisys announced a record for loading data into a relational database using an Extract, Transform and Load (ETL) tool.  Over 1 TB of TPC-H data was loaded in under…


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 Server 2005 SP2 and fixes posted later. This is a must read for anyone deploying SQL Server 2005 SP2 to understand the various hotfixes, GDRs and procedures. Please visit his link for more details. SQL Server 2005…


New MSDN Books Online search functionality

Check out the new Books Online search functionality online. The link below provides  a scoped search of Books Online that returns a more precise and targeted result set. You can use it to search Books Online content quickly. Please direct your feedback to — Umachandar


SQL Server 2005 Performance Dashboard Reports

The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SQL Server 2005 SP2 release of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a…


SQL Server 2005 SP2 has been released…

SQL Server 2005 Service Pack 2 has been released. You can find more information from the service pack 2 page. This service pack extends the functionality of SQL Server in many ways. The What’s New document highlights the major changes in the Database Engine, Analysis Services, Integration Services and others. The service pack also has…


Database Applications Profile Survey

We are conducting a survey to better understand SQL Server workloads.   Please consider providing your workload characteristics and hardware configuration to help us better understand the workloads that run on SQL Server. This is a detailed survey so we are hoping to determine more than what SQM or SQLH2 or other mechanisms offer today….



Welcome to the new bloggy home of Microsoft’s small but mighty SQL Performance Team! Lots of smart folks on the SQL team work on performance, as some part of their job. We do it every waking moment. We live and breathe performance & scalability, across the box, at a code level and at a system…