Friday, July 22, 2016

Denver SSUG Presentation About Latch Behavior

Yesterday I did a presentation about SQL Server Latch behavior at SQL Server User Group at Denver.

Hope everyone has learnt something and got some exposure to SQL Server latches which is internal to SQL Server and some time create issues. So that knowing about what they are and how they behaves is important in my opinion.

Below link contains the ppt and the demo scripts I used. The demo scripts are compatible with SQL Server 2014 or later.

Presentation and Demo scripts

Cheers!

2 comments:

  1. Good presentation, thank you for sharing. I as a beginner IT specialists, it's useful. For the future, I can recommend a good template for the presentation http://www.poweredtemplate.com/ppt-powerpoint-design-templates.html. They complement the presentation, making it as efficient as possible.

    ReplyDelete
    Replies
    1. Thank you Ronnie for the feedback.

      Delete

How to fix cardinality estimation anomalies [Video]

Use the link mentioned below to watch the presentation that I delivered for PASS DBA Virtual Chapter about Filtered Statistics.  http:...