Israeli SQL Server User Group

Welcome to Israel SQL Server PASS Chapter homepage.

Our sponsors:





Next Meeting

Next meeting




Monitor Page Splits in SQL Server and Learn about Apache Kafka

  • In-Person @ 2 HaPnina St. Raanana, HaSharon, Israel (map)
  • 17:00 - 19:00 (UTC+02:00) Jerusalem
  • Language: Hebrew

 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.


Israel Blogging Community:

Guy Glantser Dubi Lebel Matan Yungman Meir Dudai Geri Reshef Maria Zakourdaev Noam Brezis Eitan Blumin Asaf Aviv Michael Zilbershtein Itai Binyamin Ronen Ariely Pini Krisher




SQL Joke of the month:

DBAs make the best husbands. They understand relationships and know how to commit

Back to Top