This meetup is all about data. From small to big, SQL to NoSQL, BI, reports, development, design and more. If you're a developer, DBA, BI expert, data analyst or data scientist, this is a great place to meet and learn.
• 19:00-19:15 - Opening, Announcements, and More...
• 19:15-20:15 - Monitoring SQL Server without Breaking the Bank
• 20:15-20:30 - Q&A
Session: Monitoring SQL Server without Breaking the Bank – Gianluca Sartori (60 Minutes, English)
Monitoring SQL Server can become a very expensive business. Sure, the market offers countless paid solutions, but what if you have a large server estate and your budget is tight?
In this session we will combine multiple open source tools (InfluxDB, Telegraf, Grafana, dbatools and many more) to collect important performance metrics, analyze the data they collect, set up alerts for the critical events, troubleshoot issues and plan for the future. Join this session and you will see how monitoring is not a business for billionaires.
• 13:30-13:45 - Opening, Announcements, and More...
• 13:45-15:00 - Extended Events to the Rescue
• 15:00-15:15 - Q&A
Session: Extended Events to the Rescue – Guy Glantser (75 Minutes, Hebrew)
There are many monitoring tools and platforms within SQL Server, such as Profiler, Dynamic Management Views (DMVs), Event Notifications and the Data Collector. And then there is Extended Events, which is meant to replace some of the other tools and complement others.
Extended Events is a highly scalable and highly configurable monitoring platform, which every DBA ought to be familiar with. It has many advantages over alternative tools, and in some cases, it is the only tool that can provide the desired monitoring solution.
In this session we will demonstrate several common use cases. We will monitor query waits in order to troubleshoot long running queries. We will troubleshoot deadlocks in order to find the root cause and fix them. We will monitor page splits in order to improve index maintenance and reduce fragmentation. And these are just a few examples…
We will demonstrate how to set up an event session for each use case and how to analyze the collected data in a meaningful way. By the end of this session, you'll have several practical monitoring and troubleshooting solutions to apply in your environment.