Author Archives: Glenn Berry

Special Discount Code for PASS Summit and Precon

Posted on October 5, 2016 by Glenn Berry

On Monday, October 24, 2016, I will be doing an all-day, Pre-Conference session on how to interpret my SQL Server diagnostic information queries. I have done many shorter versions of this session (such as 60 minutes, 75 minutes, or even … Continue reading →

Posted in PASS, Teaching | Tagged | Leave a comment

SQL Server Diagnostic Information Queries for June 2016

Posted on June 8, 2016 by Glenn Berry

This month, I have several improvements in the SQL Server 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. One new feature is a series of six dashes after each … Continue reading →

Posted in Diagnostic Queries, SQL Server 2012, SQL Server 2014, SQL Server 2016 | Tagged | Leave a comment

Processor Tall Tales From Best Buy

Posted on February 20, 2015 by Glenn Berry

I was recently doing some shopping at my local Best Buy, and I wandered through the computer section to see what they were currently selling (as I periodically like to do). While I was standing in the laptop area, a … Continue reading →

Posted in Intel, Laptops | Tagged | Leave a comment

Analyzing I/O Subsystem Performance at PASS 2014

Posted on November 6, 2014 by Glenn Berry

On November 5, 2014, I had the pleasure of presenting Analyzing I/O Subsystem Performance at the PASS 2014 Summit in Seattle. I was in room 6C, coming on after Conor Cunningham’s presentation on Query Store. People seemed to like the … Continue reading →

Posted in PASS, Storage Subsystems, Teaching | Leave a comment

Are Electric Cars Practical?

Posted on October 12, 2014 by Glenn Berry

Elon Musk unveiled the new Tesla Model S P85D last Thursday at a big event at Hawthorne Airport in California. In my opinion, this was one of the better public events for Tesla that Elon Musk has done (at least … Continue reading →

Posted in Automobiles, Electric Cars, Tesla | Tagged | 1 Comment

New Types of Azure Virtual Machines

Posted on September 22, 2014 by Glenn Berry

Microsoft has announced a new set of VM sizes for Azure Virtual Machines, known as the D-series, that have faster vCPUs (compared to their older A-series Azure VMs) and local, temporary SSDs. These local SSDs are touted as being good … Continue reading →

Posted in Azure Virtual Machines | Tagged , | Leave a comment

SQL Server Diagnostic Information Queries for September 2014

Posted on September 17, 2014 by Glenn Berry

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 … Continue reading →

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | 6 Comments

Tesla Model S Road Trip Results

Posted on September 16, 2014 by Glenn Berry

I recently drove my red Tesla Model S P85 from Parker, CO to Kansas City, MO, which ended up being a round trip distance of about 1240 miles. This was my longest road trip ever in the Tesla, and it … Continue reading →

Posted in Tesla | Tagged , | 5 Comments

Tesla Road Trip to SQLSaturday #300 in Kansas City

Posted on September 10, 2014 by Glenn Berry

I am going to be driving my red Tesla Model S P85 from Parker, Colorado to SQLSaturday #300 in Kansas City (which is happening on September 13, 2014). I will actually be leaving on Thursday morning, and driving to Topeka, … Continue reading →

Posted in SQLSaturday, Teaching | Tagged | 4 Comments

SQL Server Diagnostic Information Queries for April 2014

Posted on April 18, 2014 by Glenn Berry

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 … Continue reading →

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | 1 Comment