SQL Server Diagnostic Information Queries for November 2014

I revised a number of the queries this month in all five versions of the script.  It was very nice to have so many people thank me for these queries during the PASS 2014 Conference! Here are the current query counts for each version: SQL Server 2014         72 Queries SQL Server 2012         69 Queries SQL […]

SQL Server 2014 RTM CU4

Microsoft has released SQL Server 2014 RTM CU4, which is Build 12.0.2430. This cumulative update has 54 hotfixes in the public fix list, which is a fairly large number. As usual, I think you should take a close look at the list of hotfixes, and then think pretty seriously about going through the testing and […]

Setting Your Page Verify Database Option to CHECKSUM

One thing I still run into quite often are SQL Server 2005 and newer databases that have their Page Verify database option set to TORN_PAGE or NONE. The most common reason for this is that an older database that was originally created in SQL Server 2000 or older was upgraded to SQL Server 2005 or […]

SQL Server Diagnostic Information Queries for September 2014

I revised a number of the queries this month in all five versions of the script. I have also added several new queries to the SQL Server 2012 and SQL Server 2014 versions of the script. Here are the current query counts for each version: SQL Server 2014         72 Queries SQL Server 2012         69 Queries […]

Small Enhancement to Microsoft SQL Server CU Knowledge Base Articles

Microsoft has made a small, but helpful improvement to the format for their Knowledge Base articles that accompany new Cumulative Updates for SQL Server 2012 and SQL Server 2014. As you hopefully know, there will not be any more cumulative updates for SQL Server 2008 or SQL Server 2008 R2, since those versions are now […]

SQL Server 2014 RTM Cumulative Update 3

Microsoft has released (about a week early by my calendar) SQL Server 2014 RTM Cumulative Update 3, which is build 12.0.2402. It has 32 fixes in the public fix list. As always, I think that you should strongly consider applying this update to your SQL Server 2014 instances, after you have done your normal round […]

SQL Server Diagnostic Information Queries for July 2014

I revised several of the queries this month in all five versions of the script. There are also two new queries for SQL Server 2014, and one new query in the SQL Server 2008 through SQL Server 2012 versions of the script. Rather than having a separate blog post for each version, I have just […]

SQL Server 2014 RTM Cumulative Update 2

Microsoft has released SQL Server 2014 RTM Cumulative Update 2, which is Build 12.0.2370.0. It has 48 hotfixes in the public fix list. This is one of the more interesting fixes: FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server […]

Upcoming SQLskills Training Classes

As Paul announced last week, SQLskills has revamped the previous IE1 and IE2 classes to focus even more on performance tuning and optimization. If you are interested in how to select and configure database hardware for various workloads as well as how to configure your operating system and SQL Server for the best performance and […]

SQL Server Diagnostic Information Queries for June 2014

I added several new queries this month to all five versions of the script. I also spent quite a bit of time getting all five versions back in synch as much as possible, as far as my comments and other minor differences that had cropped up over the last few months. Rather than having a […]

Most Recent Cumulative Updates for SQL Server 2008-2014

Here are the most recent cumulative updates for SQL Server 2014, 2012, 2008 R2 and 2008 (as of June 27, 2014) SQL Server 2014 RTM CU2 (12.0.2370)           released on June 27, 2014 Microsoft has now released the second cumulative update for SQL Server 2014 RTM, which has 48 hotfixes by my count from the KB […]

Recommended Intel Processors For SQL Server 2014 OLTP Workloads

If you are in the process of evaluating and selecting the components for a new database server to run an OLTP workload on SQL Server 2014 Enterprise Edition, you have several initial choices that you have to make as a part of the decision process. First you have to decide whether you want to go […]

SQL Server Diagnostic Information Queries for April 2014

I made some small improvements to a few of the queries this month. I plan to add several more SQL Server 2014 specific queries over the next couple of months, along with a lot more comments on how to interpret the results of each query in the entire set. Rather than having a separate blog […]

Building a Workstation for SQL Server 2014 Development and Testing

With the existing supply of high-performance and very affordable desktop computer components, it is not very difficult to assemble an extremely high performance workstation for SQL Server 2014 development and testing at a very reasonable cost. Depending on how much performance you want and what your available budget is, you can take several different routes […]

SQL Server Diagnostic Information Queries for March 2014

I made a couple of changes in the order of the queries this month and made some other small improvements to a few queries. Rather than having a separate blog post for each version, I’ll just put the links for all five major versions in this single post. There are two separate links for each […]

Two New TPC-E Benchmark Results for Intel Xeon Ivy Bridge-EX Processors

A couple of weeks ago, two new TPC-E benchmark submissions showed up for four-socket servers with the new 22nm, 15-core Intel Xeon E7-4890 v2 processor that I discussed a few days ago. NEC submitted a result for a four-socket NEC Express5800/A2040b system with a raw TPC-E score of 5,087.17, while IBM submitted a result for […]

Bigger Database Servers Get Faster

For quite some time, I have been talking about how current Intel-based four-socket database servers have had significantly lower single-threaded processor performance than current Intel-based two-socket database servers. This is because the first generation Intel Xeon E7 processors were using the relatively old 32nm Westmere microarchitecture that was introduced in early 2011 for the initial […]

SQL Server Diagnostic Information Queries for February 2014

I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather than having a separate blog post for each version, I’ll just put the links for all five major versions in this single post. There are two separate links for each version. The first one on […]

Spring SQLintersection Conference in Orlando

This year the Spring 2014 SQLintersection Conference will be in Orlando, FL at the JW Marriott Grand Lakes from April 12th to April 17, (including the pre-con and post-con workshops). There will be an informal “Ask the Experts” area with many of the speakers, including two Microsoft Premier Field Engineers, – David Pless and Tim […]

Escape the Winter and Learn About SQL Server Hardware in Tampa

On February 6-7, 2014, I will be teaching IEHW: Immersion Event on SQL Server Hardware in Tampa, FL. This is a great opportunity for you to learn how to properly select and configure your server hardware and storage subsystem to get the best performance and scalability for the lowest SQL Server licensing costs. It is […]

One Intel Processor Family to Avoid For SQL Server 2012/2014

On January 9, Intel launched the 22nm Intel Xeon E5-2400 v2 Product Family (Ivy Bridge-EN) of processors for two-socket servers. For SQL Server usage, this is not a good processor family to choose for a new server. While these processors are a nice improvement over the older 32nm Intel Xeon E5-2400 Product Family (Sandy Bridge-EN) […]

SQL Server Diagnostic Information Queries for January 2014

I spent some time this month to true up the SQL Server 2005 version, with the other versions for the queries that are common between all of these versions, since some small differences had cropped up over time across those versions. I also added the drive-level latency query to the 2005 version. Rather than having […]

SQL Server 2014 Diagnostic Information Queries (December 2013)

I have made quite a few updates and improvements to this set of queries for December 2013. I have added several new queries, and changed the order of some of the existing queries in the set, which now has a total of 65 separate queries. The blank results spreadsheet has also been updated to match. […]

Creating SQL Server Agent Alerts for Critical Errors

One necessary part of being a responsible DBA is to try to configure your SQL Server instances in such a manner so they will be as reliable as possible. This begins with how you initially install and configure the operating system and SQL Server, and what you do over time to maintain and monitor your […]

Scaling SQL Server 2012 Pre-Conference Session

In just a couple of weeks, I will be giving a full day pre-conference session at the SQLPASS 2013 Conference in Charlotte, North Carolina. My pre-conference session will be on Monday, October 14, 2013. This pre-con’s going to be a lot of fun, and it will be a great way to kick off the SQLPASS […]

SQL Server Diagnostic Information Queries for September 2013

I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I have also added a new version for SQL Server 2014. Rather than having a separate blog post for each version, I’ll just put the links for all five versions here. SQL Server 2005 […]

How To Avoid Orphaned Database Users with SQL Server Authentication

One common issue that database administrators often run into is the old, familiar “orphaned” user problem. This happens when you use SQL Server Authentication to create a SQL Server login on your database server. When you do this, SQL Server generates a unique SID for that SQL Server login. After you create the SQL Server […]

Building an Intel Haswell Desktop System for SQL Server 2012 Development

The 22nm 4th generation Intel Core desktop processors (aka Haswell) have been available for sale for a couple of months now, so I have had some requests to put together a suggested component list for a desktop system that would be suitable for SQL Server 2012 development and testing usage. As you may know, the […]

SQL Server 2014 Announced

Microsoft has finally released some information during the TechEd North America 2013 Day 1 Keynote about the next major version of SQL Server, which will be called SQL Server 2014. According to Mary Jo Foley, it is due to be released in early 2014, shortly after the release of Windows Server 2012 R2 (aka Windows […]