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!

at
Labels: ,

2 comments:

  1. UnknownJuly 28, 2016 at 2:08 AM

    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

Subscribe to: Post Comments (Atom)

How to interpret Disk Latency

I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...

  • Sharding implementation in SQL Server
    Sharding is a data partitioning technique which is popular in NoSQL databases like MongoDB and Cassandra. You can scale out the data set h...
  • SQL Server on Mac
    I'm super excited to hear about the news, the first release of CTP (Community Technology Preview) of SQL Server on Linux at Microsoft ...
  • How To Generate In-Memory OLTP Migration Checklist
    In-Memory OLTP, code named Hakaton is a separate database engine introduced in SQL Server 2014 and it is combined with SQL Server traditio...