SQL Server 2008 R2 Service Pack 2 Cumulative Update 1

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 1, which is Build 10.50.4260.0. This CU has 35 fixes listed in the public fix list. This CU should get the SQL Server 2008 R2 SP2 branch aligned with the fixes in SQL Server 2008 R2 SP1 CU7, although I don’t have official confirmation of that yet from Microsoft.  That is the normal pattern, where a new Service Pack is quickly followed up by a CU on the new SP branch that includes the hotfixes for the last couple of CUs on the previous Service Pack branch.

At least one important hotfix from SQL Server 2008 R2 SP1 CU6 is included in this CU, which is:

FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2

As always, keep in mind that this Cumulative Update is only for SQL Server 2008 R2 Service Pack 2, not for earlier Service Packs and not for SQL Server 2008.

Posted in Microsoft, SQL Server 2008 R2 | Tagged , | Leave a comment

Two New Cumulative Updates for SQL Server 2008

On July 17, Microsoft released two new Cumulative Updates for SQL Server 2008. The first cumulative update is SQL Server 2008 SP2 CU11, which is Build 10.00.4333. There are two fixes listed in the public fix list.

The second cumulative update is SQL Server 2008 SP3 CU6, which is Build 10.00.5788. There are fourteen fixes in the public fix list.

These two Microsoft KB articles show all of the cumulative updates for SQL Server 2008 SP2 and for SQL Server 2008 SP3.

The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2 was released

The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 3 was released

Keep in mind that these cumulative updates are only for SQL Server 2008, not for SQL Server 2008 R2.

Posted in Microsoft, SQL Server 2008 | Tagged , | Leave a comment

SQL Server 2008 R2 Service Pack 2

Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through SQL Server 2008 Service Pack 1 CU5. If you have already installed SQL Server 2008 R2 SP1 CU6 or CU7, you will want to wait until Microsoft releases SQL Server 2008 R2 SP2 CU1 (which should be relatively soon if past history is any guide). The release notes are here. This Service Pack is only for SQL Server 2008 R2.

This build chart should make the relationship between the SP1 and SP2 branches more clear. Although I don’t have a link, Microsoft will typically retire the RTM branch when Service Pack 2 has been released. That means that if you are still on the RTM branch, you are going to want to get on a newer branch (preferably SP2) as soon as you can.

     SQL Server 2008 R2 SP1 Builds     SQL Server 2008 R2 SP2 Builds
     Build             Description                          Build              Description
— 10.50.2500  SP1 RTM
— 10.50.2769  SP1 CU1
— 10.50.2772  SP1 CU2
— 10.50.2789  SP1 CU3
— 10.50.2796  SP1 CU4
— 10.50.2806  SP1 CU5        —>              10.50.4000    SP2 RTM
— 10.50.2811  SP1 CU6
— 10.50.2817  SP1 CU7      

The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released

The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released

Posted in Microsoft, SQL Server 2008 R2 | Tagged | Leave a comment

Two Socket Database Servers vs. Four Socket Database Servers

Fujitsu has submitted a new TPC-E benchmark for a two socket, Sandy Bridge-EP system that had a tpsE score of 1,871.81.  It is no real surprise that this system is using the very capable Intel Xeon E5-2690 processor, which has eight physical cores per processor and is the top of the Xeon E5 line in terms of performance and scalability. This is also the third TPC-E benchmark that has been submitted for SQL Server 2012.

The TPC-E OLTP benchmark is primarily limited by processor performance, assuming that you have enough I/O capacity in terms of IOPS and sequential throughput to properly drive the workload for the benchmark process. For official TPC-E submissions from a hardware vendor, this is a pretty safe assumption, given the cost and time required to submit test results to TPC.

SQL Server 2012 Enterprise Edition is licensed by the physical processor core instead of by the physical socket unlike previous versions of SQL Server. This means that it is even more important to carefully choose which processor to use for your database server. You want to get the best single-threaded performance possible for each physical processor core, so that you get the full value of your SQL Server 2012 core licenses. Choosing poorly when it comes your processor choice, and choosing poorly when it come to choosing between a two socket server and a four socket server can cause you to spend a lot more money on SQL Server 2012 Enterprise Edition licenses and actually get less performance.

This means that it makes sense to look at actual TPC-E scores divided by the total number of physical processor cores in the database server to get an idea about which processor will give you the most OLTP performance for each SQL Server 2012 core license.

Because of the way that Intel develops and releases processors to adhere to their “Tick-Tock” development schedule, and because of the more frequent processor revisions for the higher volume two socket space, a modern two socket server with the Intel Xeon E5-2690 processor is pretty much unbeatable for TPC-E performance from a score per core perspective.

Looking at Table 1, you can see a system with a Xeon E5-2690 having a 116.99 Score/Core rating, followed pretty closely by a previous generation Xeon X5690 with a 107.01 Score/Core. Even the older Xeon X5570 does quite well with a 102.14 Score/Core.

The best four socket system by this calculation is a Xeon X7560, coming in at a 63.97 Score/Core, followed pretty closely by a newer Xeon E7-4870 system with a 61.35 Score/Core. It seems that those two extra cores in a Westmere-EX are not giving as much as an advantage over the older Nehalem-EX as you would expect for TPC-E.

Processor tpsE Sockets Cores Score/Socket Score/Core
Xeon X5460 317.45 2 8 158.73 39.68
Xeon X5570 817.15 2 8 408.58 102.14
Opteron 6176 SE 887.38 2 24 443.69 36.97
Opteron 6282 SE 1232.84 2 32 616.42 38.53
Xeon X5690 1284.14 2 12 642.07 107.01
Xeon E7-2870 1560.7 2 20 780.35 78.04
Xeon E5-2690 1871.81 2 16 935.91 116.99
Xeon X7350 492.34 4 16 123.09 30.77
Xeon X7460 729.65 4 24 182.41 30.40
Opteron 6176 SE 1400.14 4 48 350.04 29.17
Xeon X7560 2046.96 4 32 511.74 63.97
Xeon E7-4870 2454.51 4 40 613.63 61.36

Table 1: TPC-E Performance by Processor

As I have said before, it is really hard to argue against choosing a modern, two socket database server for most OLTP workloads. The latest two socket Sandy Bridge-EP systems can support up to 384GB of RAM (with affordable 16GB DIMMs) and have PCI-E 3.0 support, with a pretty high number of PCI-E expansion slots. This should be more than enough CPU, memory, and I/O capacity for most workloads.

Posted in Computer Hardware, Processors, SQL Server 2012 | Tagged , | 5 Comments

SQL Server 2012 Diagnostic Information Queries (July 2012)

Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries, and two new queries. To go with it is an updated, blank SQL Server 2012 results spreadsheet, where the tabs in the spreadsheet are labeled and in the same order as the queries.

The idea is that you can run these queries one by one, click on the top left square of the results grid, and then right-click and select “Copy with Headers” to select and copy the results of the query and then paste them into the matching tab of the results spreadsheet.

Most of these queries only work on SQL Server 2012, although some will work on older versions of SQL Server. If you are using an older version of SQL Server, you should use the version of my diagnostic queries for that version of SQL Server.

The July 2012 version for SQL Server 2005 will be available in the next day or so. As always, let me know what you think of these queries.

Posted in SQL Server 2012 | Tagged , | 13 Comments

SQL Server 2008 Diagnostic Information Queries (July 2012)

Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries, and one new query. To go with it is an updated, blank 2008 results spreadsheet, where the tabs in the spreadsheet are labeled and in the same order as the queries. The idea is that you can run these queries one by one, click on the top left square of the results grid, and then right-click and select “Copy with Headers” to select and copy the results of the query and then paste them into the matching tab of the results spreadsheet.

These queries will work on both SQL Server 2008 and SQL Server 2008 R2 (although some of them will only work on SQL Server 2008 R2 SP1 or later). This is indicated in the instructions for each query.

The July 2012 versions for SQL Server 2005 and SQL Server 2012 will be available in the next day or so. As always, let me know what you think of these queries.

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 14 Comments

Where to Buy a New Laptop

Let’s say that you are in the market to buy a new laptop or ultra book to replace that old clunker that you have been suffering with. You want to be able to check out a number of different brands and models, hands on, and you want to see some better quality hardware than you will see at somewhere like Best Buy, Staples, or Office Depot. Where are you supposed to go to do this?

One place that I suggest you check out is the local Microsoft Store. There are 23 locations, soon to be 27 locations around the United States and Puerto Rico. This is a very small number compared to Apple, which has 363 stores worldwide, (according to Wikipedia), but the number is starting to grow a little more quickly, which I think is a good thing. I hate to see Microsoft completely concede the retail and consumer market to Apple without a fight. Having a retail presence, where Microsoft can show off their latest stuff, on good hardware, with a knowledgeable staff to support it seems like a good strategy to me.

Assuming that one of these few Microsoft Stores is close to you, you will find that they carry a pretty decent selection of higher quality laptops and ultra books compared to other brick and mortar stores. All of their machines are configured with Microsoft SIgnature, which means that they do not have any of the standard “bloatware” that you will find when you buy a Windows PC from somewhere else. They also are not covered with stupid product logo stickers, and the display models actually have their battery installed (so you can feel how much they really weigh).  Right now, they have laptops from $499-$1899, but they have quite few models in the $799-$1299 range, many with Intel “Ivy Bridge” processors, SSDs, and greater than 1366 x 768 screen resolution. These are good, mid-range laptops, which are much nicer than the $399-$599 plastic wonders that you will find at Best Buy.

It really pains me to have watched this “race to the bottom” for Windows laptops over the last two-three years. Due to price competition from netbooks a couple of years ago, and more recently from tablets, the Average Selling Price (ASP) for laptops has been steadily going down, leaving very small margins for the system vendors. Because of this, you will find most low-end laptops have terrible quality 1366 x 768 LCD screens, many will have very slow 5400rpm magnetic hard drives, and many will have only 4GB of RAM. They will also be loaded up with performance sapping bloatware, and they will be covered in those annoying product logo stickers (since the system vendors can make some extra money by polluting their systems with that stuff). When questioned about this, the system vendors used to claim that all most of their customers cared about was the price, and that they were willing to live with lower quality components (probably because they did not really know any better). Now, probably because of Apple and its infamous Retina Display, we are beginning to see some of the PC system vendors such as Samsung start to offer a larger selection of better machines that have very nice 1600 x 900 or 1920 x 1080 LCD displays which is a step in the right direction.

If you are in the market for a very high-end mobile workstation, with four memory slots, multiple drive bays, etc., so you can run a complete SQL Server 2012 AlwaysOn Availability Group infrastructure on multiple virtual machines, the Microsoft Store is not going to have what you are looking for. You will have to order a beast like that directly from your system vendor of choice. If you are looking for a good quality, mid to upper range machine, the Microsoft Store might have what you are looking for.

If you do not live near a Microsoft Store, another decent brick and mortar alternative is Micro Center, which also has 23 locations.  They carry a pretty wide range of laptops starting from the cheapest netbook to a few big, expensive 17” gaming laptops. Their machines are straight from the system vendor, loaded with all of the standard bloatware, but they do have a wider selection than the typical Best Buy. Their sales people are also more knowledgeable than the kids at Best Buy, but they are equally as aggressive about selling extended warranties. One thing I like to do whenever I am in a Best Buy or in a Micro Center is to listen to some of the tall tales that sales people tell to their credulous customers. It is quite entertaining for me!

Posted in Computer Hardware, Laptops, Microsoft | Tagged | 10 Comments

Win A Free Registration to SQLskills Immersion Event 1

You have until July 6 to enter to win a free seat at the SQLskills Internals and Performance (IE1) training class in Bellevue, WA on August 6 – 10, 2012, sponsored by SQLSentry.  This is really a great chance to get some excellent training from the best instructors in the industry (and I would still say that even if I was not working for SQLskills)!   Long before I was a SQL Server MVP, way back in 2006, I got a chance to go to a SQLskills Immersion class for a week, and I thoroughly enjoyed it.  It really helped me out in my job at NewsGator.

Whoever wins this contest will have the opportunity to learn a lot of extremely deep and comprehensive content about SQL Server internals and performance from Kimberly Tripp and Paul Randal. 

Make sure you read the complete rules, including the part about sending an e-mail to SQLSentry so they know what you did for your contest entry.

I will be attending as a student, myself, so I hope to see you there!

Posted in Microsoft, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Teaching | Tagged | Leave a comment

Two New Cumulative Updates for SQL Server 2008 R2

Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. The first one is SQL Server 2008 R2 RTM Cumulative Update 14, which is Build 10.50.1817.0. This CU has seven fixes in the public fix list, and it is likely to be one of the last cumulative updates for the RTM branch of SQL Server 2008 R2, since SQL Server 2008 R2 Service Pack 2 is likely to be released pretty soon. When that happens, the RTM branch will be retired, meaning that it will be an “unsupported service pack”.   You really should be planning to get off of the RTM code branch as soon as possible.

The second Cumulative Update is SQL Server 2008 R2 SP1 Cumulative Update 7, which is Build 10.50.2817.0. There are 24 fixes in the public fix for this CU. As always, I want to point out that these cumulative updates are only for SQL Server 2008 R2, not for SQL Server 2008. They are, as the name implies, cumulative updates, which means you do not have to install the previous cumulative updates on the RTM or SP1 code branch.

Posted in SQL Server 2008 R2 | Tagged , | Leave a comment

SQL Server 2012 RTM Cumulative Update 2

Last night, Microsoft released SQL Server 2012 RTM Cumulative Update 2, which is Build 11.0.2325.0. It has 37 fixes in the public fix list, which is a pretty high number for a cumulative update.  Microsoft maintains a build list for SQL Server 2012 RTM called The SQL Server 2012 builds that were released after SQL Server 2012 was released, which is a good idea to bookmark.

You can find out what build (of any version of SQL Server) that you are running by running this query:

— SQL and OS Version information for current instance
SELECT @@VERSION AS [SQL Server and OS Version Info];

 

SQL Server 2012 RTM Branch Builds
Build                   Description
11.00.1055        CTP0
11.00.1103        CTP1
11.00.1440        CTP3
11.00.1515        CTP3 plus Test Update
11.00.1750        RC0
11.00.1913        RC1
11.00.2300        RTM
11.00.2316        RTM CU1
11.00.2325        RTM CU2

 

image

Posted in SQL Server 2012 | Tagged | Leave a comment