Resources from my Techday 2012 presentation on SQL Server transaction performance

Recently I gave a presentation on SQL Server transaction performance diagnostics and improvement on Microsoft organized TechDay events in Lithuania and Latvia.

The time for the talk was very limited and topic – really big and complex. So I have decided to briefly cover some aspects like blocking & deadlocks, query plans and finally some tools for diagnostics, including my new favorite – extended events (xEvents).

For those who want to know more about the topics I’ve talked, you will have to dig deeper on your own, but hopefully you have some idea.

Here are couple of good points where to start:

There are many more sources, but definitely you can start with those links and Google Bing further absorbing all the good information along the way.

Of course, I have posted slides and scripts of my presentation here. And if you will go through these links, or at least take a look to extended events and system_health session – then my goal was achieved.

And make sure you know your data and pass this knowledge to your SQL Server in form of good physical design, indexes, statistics and appropriate queries.

SQL Server 2008 R2 – Cannot connect to WMI provider

Ok, I hate when these things happen and I love that many people are blogging about these issues. Anyway, it stole 15 minutes from my lifetime and … it is just stupid.

Anyway, I got the message that is shown in the Martins blog, which leads to Eric Charran blog. Solution worked just perfectly, just one thing to note: if you’re dealing with 64-bit platform, then the MOF pack will be in "Program Files (x86)…" and not in the 64-bit "Program Files" location.