Site: http://blogs.msdn.com/sqlperf/default.aspx Link: http://blogs.msdn.com/sqlperf/rss.xml
by Data & SQL Storage Performance Team via SQL Server Performance on 11/30/2009 7:31:55 PM
On November 2, 2009, Unisys published two new TPC results (TPC-E and TPC-H) using the newly announced SQL Server 2008 R2* and Windows Server 2008 R2**. These results were published on the 96-core Unisys ES7000 system. These are the first SQL Server TPC results using more than 64 cores and they demonstrate the outstanding scalability of the Windows and SQL Server platform. The TPC-E publication was 2,012 tpsE with a price performance of $958.23 USD/tpsE. The configuratio ...
[ read more ]
by Data & SQL Storage Performance Team via SQL Server Performance on 8/17/2009 8:35:50 PM
Our partners at Dell and HP have published 2 new TPC-H results with SQL Server 2008 using Fusion-io’s ioDrive solid-state technology. These are the first TPC results using solid-state technology and they illustrate the high performance along with total cost-of-ownership savings you can achieve. These results dramatically improved the price/performance for systems using industry standard components. These results prove that solid-state technologies can be used to reduce ...
by Data & SQL Storage Performance Team via SQL Server Performance on 8/15/2009 4:38:00 AM
Since late last year, Microsoft has made the Attunity connectors to Oracle databases available to Enterprise Edition customers. We all recognized right away that these connectors were faster than the pre-existing options from either Microsoft or Oracle, when moving data into or out of an Oracle database. It wasn’t immediately obvious what speeds we could expect from the connectors, so I did some experimenting to see. This posting summarizes some findings from those experiments done earlier this ...
by Data & SQL Storage Performance Team via SQL Server Performance on 3/31/2009 7:56:00 PM
Yesterday, Intel launched its new Xeon 5500 series processors, code named Nehalem-EP. This is essentially the first server-class version of what Intel launched on the desktop as Core i7 last fall. With no frontside bus, and an embedded, multi-channel memory controller in the processor package, it is smoking fast. Pat Gelsinger did a side-by-side performance demo which launched an SSRS report, running reporting queries against a 1.5 TB SSAS OLAP cube, built using a Microsoft adCen ...
by Data & SQL Storage Performance Team via SQL Server Performance on 11/25/2008 5:04:00 AM
After running an experiment, using datacenters on each coast of the U.S., our friends in MSCOM ops verified that the combination of Windows Server 2008 and SQL Server 2008 are great for enabling database geo-replication, thanks to a 100X gain in performance. The experiment provided sufficient evidence to motivate a more ambitious proof-of-concept case study with MSDN. A new whitepaper, published this week, explains how SQL Server 2008 was able to take advantage of the all-new core networkin ...
by Data & SQL Storage Performance Team via SQL Server Performance on 11/10/2008 9:34:00 PM
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 on top of Windows Server 2008 R2. We expect to support up to 256 logical processors in this release, though that's a soft limit. The hard limits are much higher than ...
by Data & SQL Storage Performance Team via SQL Server Performance on 10/24/2008 2:46:00 AM
Glenn Paulley, Director of Engineering at Sybase iAnywhere, posted a commentary titled “The State of TPC-E” on his blog three weeks ago (10/3/08). A better title would have been “All TPC-E Results Are On Microsoft SQL Server. Why?” Mr. Paulley takes issue with Brian Moran’s statement that “the most rational answer is that Oracle and IBM have tried to top Microsoft’s numbers and simply can’t”. He says that while it may be true, he doubts it and says there are other plausib ...
by Data & SQL Storage Performance Team via SQL Server Performance on 8/6/2008 8:01:00 PM
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 less than three years since SQL Server 2005, but we're pleased to give you a great new release of SQL Server which not only adds fantastic new capabilities to your data platform, but ...
by Data & SQL Storage Performance Team via SQL Server Performance on 2/28/2008 2:07:51 AM
Today, as the old saying goes, is a red-letter day, with the launch of Windows Server 2008, Visual Studio 2008, and SQL Server 2008. Our team has been heads down, working to ensure SQL Server 2008 is delivered to you with great performance and scalability. You’ll see signs of this in the new SQL Server February 2008 Community Technology Preview, which includes great new performance features in the engine, SSRS, SSAS, and SSIS, as well as just thumping good performance. But don’t take my word ...
by Data & SQL Storage Performance Team via SQL Server Performance on 2/27/2008 10:36:00 PM
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 30 minutes. I wanted to provide some background material in the form of a Q&A on the record, since it’s hard to give many details in the context of a launch event.&nbs ...
by Data & SQL Storage Performance Team via SQL Server Performance on 8/30/2007 10:38:40 PM
I came across a question in the relationalserver.performance newsgroup where a customer was wondering about the spools seen in a recursive query execution plan. The query is shown below: USE Northwind;Go WITH EmpChart AS(SELECT EmployeeId, ReportsTo, 1 AS treelevelFROM EmployeesWHERE (Employees.ReportsTo = 2)UNION ALLSELECT e.EmployeeId, e.ReportsTo, treelevel +1FROM Employees eJOIN EmpChart ecON e.ReportsTo=ec.EmployeeID)SELECT * FROM EmpChart; The plan for the above query shows an index spool ...
by Data & SQL Storage Performance Team via SQL Server Performance on 5/18/2007 8:19:00 PM
When doing a performance investigation a useful thing to do is look at what data is present in the buffer pool. This can be used to analyze impact of running a query on the state of data pages in buffer pool. By collecting the pre and post picture of buffer pool, you can see the cost of running a query in terms of physical IOs that happened. You may argue that this can be done by looking at statistics IO output; however if you are running a series of queries and want to see a consolidated ...
by Data & SQL Storage Performance Team via SQL Server Performance on 5/11/2007 11:22:00 PM
The data flow task in SSIS (SQL Server Integration Services) sends data in series of buffers. How much data does one buffer hold? This is bounded by DefaultBufferMaxRows and DefaultBufferMaxSize, two Data Flow properties. They have default values of 10,000 and 10,485,760 (10 MB), respectively. That means, one buffer will contain either 10,000 rows or 10 MB of data, whichever is less. You can adjust these two properties based on your scenario. Setting them to a higher value can boost perf ...
by Data & SQL Storage Performance Team via SQL Server Performance on 5/11/2007 11:18:00 PM
SQL Server Integration Services (SSIS) allows parallel execution in two different ways. These are controlled by two properties as outlined below. The first one is MaxConcurrentExecutables, a property of the package. It defines how many tasks (executables) can run simultaneously. It defaults to -1 which is translated to the number of processors plus 2. Please note that if your box has hyperthreading turned on, it is the logical processor rather than the physically present processor that i ...
by Data & SQL Storage Performance Team via SQL Server Performance on 5/2/2007 3:16:00 AM
SQL Server Integration Services provide a set of performance counters. Among them the following few are helpful when you tune or debug your package: Buffers in use Flat buffers in use Private buffers in use Buffers spooled Rows read Rows written “Buffers in use”, “Flat buffers in use” and “Private buffers in use” are useful to discover leaks. During package execution time, you will see these counters fluctuating. But once the package finishes execution, their values should return to the ...
by Data & SQL Storage Performance Team via SQL Server Performance on 5/2/2007 12:12:00 AM
BLOBTempStoragePath and BufferTempStoragePath are two properties on Data Flow Task. They define where on the hard disk(s) to page buffer data to. BLOBs (text, next, image) are written to BLOBTempStoragePath. All other buffer data will be swapped to BufferTempStoragePath. See the figure below for where these two properties are exposed in designer. Now what could cause a buffer to swap? There are two possible causes. The first one is when a memory allocation fails. The second one is when W ...
by Data & SQL Storage Performance Team via SQL Server Performance on 4/29/2007 8:27:00 PM
Introduction OLE DB source adapter is one of the most commonly used components in SSIS data flow task. In this article, we will discuss a very important performance observation about this adapter. Use “SQL Command” to pull data from a view OLE DB source adapter can be set up to work in either “SQL command” data access mode or “Table or view” data access mode. See the figure below for where to set Data Access Mode in OLE DB Source Editor. In most cases, whether you use “SQL command” da ...
by Data & SQL Storage Performance Team via SQL Server Performance on 4/24/2007 6:03:47 PM
Introduction Most users see good performance from SSIS packages using out-of-the-box configurations and with little tuning. Sometimes, though, it is necessary to do tuning to get optimal performance. One of the most commonly used transformations is the Lookup transformation. There are several techniques for getting optimal performance from a Lookup transform in SSIS. A few of these are surprising the first time you see them. This article discusses some tuning techniques that we have found can b ...
by Data & SQL Storage Performance Team via SQL Server Performance on 4/14/2007 12:33:00 AM
Other than #temptables, @localvariables and many other objects being stored in tempdb what’s so temporary about it? TempDB is always present on each SQL Server instance and can be a determining factor of your overall performance. In many ways tempdb could be named scratchdb or pagefiledb. The following papers will help you understand what goes into tempdb and how to plan your deployments. These articles are for both developers and administrators. Working with tempd ...
The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.
