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.

One Comment

    TechDay 2012,Vilnius « Žodis internetui …

    […] Paskutinėje paskaitoje Romualdas Stonkus parodė pavyzdžius, kaip veikia kiekvienas SQL serverio transakcijų isolation levelis ir kaip juos naudojant gaunamas deadlockas. Parodė pavyzdžių kuomet tapati užklausa vykdoma su skirtingais parametrais, tame pačiame duomenų kiekyje, generuoja skirtingus execution planus. Tokius atvejus pakankamai sunku sugauti ir pagavus kartais sprendimas butų – nurodyti SQL serveriui griežtai naudoti jūsų pasirinką planą. Taip pat nuskambėjo raginimas pradėti mokytis naudoti xEventais. MSSQL 2008 ši galymybė yra, tačiau nėra vartotjui draugiškos aplinkos, 2012 – atrodo jau yra. Daugiau indo su skaidrėmis jo bloge – čia. […]

Comments are closed.