Monitor Page Splits in SQL Server and Learn about Apache Kafka

Agenda:

• 17:30-18:00 - Gathering, Networking, Hugs and Kisses

• 18:00-18:15 - Opening, Announcements, and More...

• 18:15-19:15 - First Session (Monitoring Page Splits in SQL Server)

• 19:15-19:30 - Break (More Networking)

• 19:30-20:30 - Second Session (Apache Kafka - The Ultimate Data Streaming Beast)

Sessions:

1. Monitoring Page Splits in SQL Server – Guy Glantser (60 Minutes)

Monitoring page splits in SQL Server is useful. It can be very useful, for example, in order to choose the appropriate fill factor for an index. By monitoring the number of page splits for a particular index over a period of time, we can determine whether the fill factor for that index should be adjusted in order to reduce the number of page splits and improve the overall performance.

In this session we are going to demonstrate all the possible options to monitor page splits in SQL Server, and we are going to show that all of these options are wrong. SQL Server is lying, and we're going to prove it. We will then demonstrate the only (documented) method to correctly monitor page splits in SQL Server as of today.

2. Apache Kafka – The Ultimate Data Streaming Beast – Lior King (60 Minutes)

In this session we will get to know Apache Kafka – the popular distributed data streaming platform. Kafka can be used for messaging, for complex event processing, as a commit log, and as a service bus. It has become an essential component in big data environments.

We'll learn about the concept of topics and partitions, about Kafka's architecture, and how it works behind the scenes. We'll discuss some use cases of Kafka, and demonstrate it with command line and Java/C#. We will also discuss some tools, such as KSQL and Kafka Connect.