The SQL Server Performance Starter Kit

I received some good feedback on my talk this Wednesday for the Calgary PASS Chapter.

This has led me to consider transposing the content from a presentation format, to possibly a series of blog posts, or even a video a la Pluralsight.

While this is an interesting idea, I can’t claim a single original thought, as everything I discussed is already capably presented by others.

And yet, the thought lurks. Maybe I will put together a performance checklist for the DBA.

Are You Sure?

I make a lot of assumptions in my day-to-day life, as well as in my job as an IT consultant.

To mitigate the inherent arrogance of making assumptions, I have to remember to ask myself “Are you sure?” when something appears obvious.

A client this week said that their SharePoint installation is slow. It runs out of memory, and pages to disk, despite there being almost 8GB of RAM free every time they look.

A lot of knee-jerk responses were noted in the email thread, which is a big warning sign.

So I had a look.

It turns out that the 32-bit version of SQL Server had accidentally been installed. No one checked until I ran my standard set of scripts, and noticed “X86”.

Moral of the story: the server was being starved of memory, despite there being plenty on the server. This is an easy fix, to install the 64-bit version. No need for Lock Pages in Memory, no need to move tempdb (yet), no need for any of the suggestions in the email thread.

Next time you’re working on a server, double-check. Ask yourself, “Are you sure?”.

I’m speaking tomorrow

The local SQL PASS chapter in Calgary is hosting yours truly as the speaker for this month.

I only have an hour, which I will easily go over, to talk about how I make SQL Server go faster.

The talk is titled “The Database is Slow” (The SQL Server Performance Tuning Starter Kit), and I’ll be covering everything from the hardware layer to query tuning.

If you’re in the area, come down to IBM Calgary tomorrow, Wednesday 19 August 2015, at 4:30pm. Entry is free, and food and soft drink will be provided.

Tickets are available at Eventbrite.

Speaking at Calgary SQL PASS User Group on 19 August 2015

As the title says, I’ll be speaking at the Calgary SQL PASS User Group on 19 August 2015.

My topic is SQL Server Performance Tuning Starter Kit, where I will tell you as much as I know about how to make SQL Server go faster, in the time provided.

The session will run for 90 minutes, and free food and drink will be provided. Book your free ticket at this Eventbrite link.

The agenda as it currently stands, is as follows:

  • Server Configuration
  • Storage Configuration
  • SQL Server Configuration
  • Database Configuration
  • Structures and Indexes
  • Statistics
  • Fragmentation
  • Query Tuning
  • Waits and Queues