SQL Server 2005 Diagnostic Information Queries (May 2013)

Posted on May 7, 2013 by Glenn Berry

Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries.

To go with it is an updated, blank 2005 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.

Many of these queries only work on SQL Server 2005, although some of them will work on different versions of SQL Server. If you are using a different version of SQL Server, you should use the version of my diagnostic queries for that version of SQL Server.

As always, I welcome any feedback you may have about these queries

Posted in SQL Server 2005 | Tagged , | Leave a comment

SQL Server 2008 Diagnostic Information Queries (May 2013)

Posted on May 7, 2013 by Glenn Berry

Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008.

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.

Many of these queries only work on SQL Server 2008, although some of them will work on different versions of SQL Server. If you are using a different version of SQL Server, you should use the version of my diagnostic queries for that version of SQL Server.

As always, I welcome any feedback you may have about these queries.

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

SQL Server 2008 R2 Diagnostic Information Queries (May 2013)

Posted on May 6, 2013 by Glenn Berry

Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008 R2.

To go with it is an updated, blank 2008 R2 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.

Many of these queries only work on SQL Server 2008 R2, although some will work on older versions of SQL Server. A few of the queries also require SQL Server 2008 R2 Service Pack 1 or newer. 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.

As always, I welcome any feedback you may have about these queries.

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

SQL Server 2012 Diagnostic Information Queries (May 2013)

Posted on May 6, 2013 by Glenn Berry

Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have improved the formatting of the results to make many of the queries easier to read and interpret, especially for the missing index queries.

To go with it is an updated, blank 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.

Many 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.

Posted in SQL Server 2012 | Tagged , | Leave a comment

SQL Server 2012 Diagnostic Information Queries (April 2013)

Posted on April 15, 2013 by Glenn Berry

Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the formatting of the results to make many of the queries easier to read and interpret.

To go with it is an updated, blank 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.

Many 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.

Posted in SQL Server 2012 | Tagged , | 3 Comments

New SQL Server Cumulative Updates

Posted on April 15, 2013 by Glenn Berry

Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for SQL Server 2012.

The first one is SQL Server 2008 R2 SP1 CU12, which is Build 10.50.2874. This CU has seven fixes in the public fix list.

The second one is SQL Server 2008 R2 SP2 CU6, which is Build 10.50.4279. This CU has 13 fixes in the public fix list.

The two cumulative updates for SQL Server 2008 R2 add a new feature that lets you backup and restore databases from SQL Server to Windows Azure Blob Storage.

The final CU is SQL Server 2012 RTM CU7, which is Build 11.0.2405. This CU has 17 fixes in the public fix list. Many of these look pretty significant. You may be wondering where the “matching” CU for SQL Server 2012 SP1 is. The answer is that the RTM and SP1 branches of SQL Server 2012 are “out of synch”, so that the RTM branch is one month ahead of the RTM branch.

Microsoft is not planning on changing this, so you should get used to it.

Posted in SQL Server 2008 R2, SQL Server 2012 | Tagged | 4 Comments

Speaking at SQLSaturday #197 in Omaha on April 5-6

Posted on March 25, 2013 by Glenn Berry

I will be speaking on both Friday and Saturday (April 5-6) at SQLSaturday #197 in Omaha, Nebraska. I will be delivering a full day pre-con on Friday, and then doing Hardware 201 on Saturday. Here is the abstract for my pre-con:

Scaling SQL Server 2012

How can you scale SQL Server 2012? Scaling up is relatively easy (but can be expensive), while scaling out requires significant engineering time and effort. If you suggest hardware upgrades you may be accused of simply “throwing hardware at the problem”, and if you try to scale out, you may be thwarted by a lack of development resources or 3rd party software restrictions. As your database server nears its load capacity, what can you do? This session gives you concrete, practical advice on how to deal with this situation. Starting with your present workload, configuration and hardware, we will explore how to find and alleviate bottlenecks, whether they are workload related, configuration related, or hardware related. Next, we will cover how you can decide whether you should scale up or scale out your data tier. Once that decision is made, you will learn how to scale up properly, with nearly zero down-time. If you decide to scale out, you will learn about practical, production-ready techniques such as vertical partitioning, horizontal partitioning, and data dependent routing. We will also cover how to use middle-tier caching and other application techniques to increase your overall scalability.

You can get a copy of the flyer for both pre-cons here: SQL Saturday #197 Pre-Cons

Here is the session I will present on Saturday:

Hardware 201: Selecting Database Hardware

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD.

My friend and SQLskills colleague, Joe Sack will also be speaking at SQLSaturday #197.  I hope to see a lot of people at this event!

Posted in PASS, SQLSaturday, Teaching | Tagged | Leave a comment

Scaling SQL Server 2012 in Lisbon, Portugal

Posted on March 16, 2013 by Glenn Berry

I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon, Portugal. This was the first time I have spoken at a SQLSaturday outside of the United States, and I really enjoyed it! This never would have happened without the enthusiasm of fellow SQL MVP Niko Neugebauer, who is a good friend and an all-around good guy!

My employer, SQLskills gave away a certificate for a $500.00 discount on a future SQLskills Immersion Event class at the SQLSaturday preconference event. I also gave away a copy of SQL Server Hardware and a copy of Professional SQL Server 2012 Internals and Troubleshooting in a raffle at the end of the event. 

Here is the preconference session I delivered on Friday:

Scaling SQL Server 2012

How can you scale SQL Server 2012? Scaling up is relatively easy (but can be expensive), while scaling out requires significant engineering time and effort. If you suggest hardware upgrades you may be accused of simply “throwing hardware at the problem”, and if you try to scale out, you may be thwarted by a lack of development resources or 3rd party software restrictions. As your database server nears its load capacity, what can you do? This session gives you concrete, practical advice on how to deal with this situation. Starting with your present workload, configuration and hardware, we will explore how to find and alleviate bottlenecks, whether they are workload related, configuration related, or hardware related. Next, we will cover how you can decide whether you should scale up or scale out your data tier. Once that decision is made, you will learn how to scale up properly, with nearly zero down-time. If you decide to scale out, you will learn about practical, production-ready techniques such as vertical partitioning, horizontal partitioning, and data dependent routing. We will also cover how to use middle-tier caching and other application techniques to increase your overall scalability.

Posted in Microsoft, PASS, SQL Server 2012, Teaching, Travel | Tagged | 2 Comments

SQL Server 2012 Diagnostic Information Queries (March 2013)

Posted on March 3, 2013 by Glenn Berry

Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the formatting of the results to make many of the queries easier to read and interpret.

To go with it is an updated, blank 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.

One new feature (since February) is that I have modified the initial comment for these queries to make them work better with Mitch Wheat’s SQLDiagCmd program that is a standalone .NET program to run these queries and automatically capture the results in a nice Excel spreadsheet (which saves you the time and trouble of doing it manually). I recently discovered that Mitch also has a WinForms application that is even easier to use.

Many 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.

You should be aware that both Query 52 and Query 56 could take some time to run, depending on the size of your database and the speed of your hardware and storage subsystem.

As always, I welcome any feedback you may have about these queries.

Posted in Diagnostic Queries, SQL Server 2012 | Tagged , | 3 Comments

Hardware 301 Presentation

Posted on February 14, 2013 by Glenn Berry

I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times in one day yesterday! First was a virtual presentation for the PASS Virtual DBA chapter at 12PM, and then I got to do it again at the Rocky Mountain Oracle User’s Group Training Days 2013 at 4PM.

The RMOUG event was interesting, since I had never been to an Oracle conference before. It felt a little strange, since I did not know anyone (and no one knew me). 

I was also surprised that there was a noticeably higher percentage of women in attendance than you normally see at most technical conferences. Typically, you might see only roughly 1-2% of the attendees at most computer-related conferences being female (which is very unfortunate). Just from my casual observation yesterday, it seemed like the female percentage was at least double or triple that (which is still extremely low).

I am not sure what can really be done to change those numbers, besides continuing to encourage and mentor women who want to work in I.T.  I think there are a lot of societal factors that discourage many young women from pursuing I.T. careers.

Posted in Computer Hardware, Processors, Sandy Bridge, SQL Server 2012 | Tagged | 3 Comments