SQL Server and Disk IO (File Groups/Files, SSD's, Fusion-IO, In-RAM DB's, Fragmentation) - Tony Rogerson; Physical Join Operators in SQL Server - Ami Levin; Complex Event Processing - Allan Mitchell
Network with your peers, come and learn or even present. Join us at this UK SQL Server User Group meeting - please make sure you register so we know numbers.
Got pre-meeting questions, or want to comment while at the meeting then use the #sqlfaq tag and it will appear on the site.
Agenda
17:30 SQL Server and Disk IO
Tony Rogerson, SQL Server MVP
Tony's Blog; Tony on Twitter
In this session Tony will talk about RAID levels, how SQL server writes to and reads from disk, the effect SSD has and will talk about other options for throughput enhancement like Fusion IO. He will look at the effect fragmentation has and how to minimise the impact, he will look at the File structure of a database and talk about what benefits multiple files and file groups bring. We will also touch on Database Mirroring and the effect that has on throughput, how to get a feeling for the throughput you should expect.
18:10 Physical Join Operators in SQL Server
Ami Levin, SQL Server MVP
SQL Server implements three different physical operators to perform joins. In this session we will see how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer’s decisions on which operator to use for various joins using (semi) real life examples and how to avoid common pitfalls.
Ami Levin is a Microsoft SQL Server MVP, with over 20 years experience in the IT industry. For the past 12 years, he has been consulting, speaking and teaching SQL worldwide. He manages the Israeli SQL Server user group, leads the SQL Server support forum in Hebrew, and is a regular speaker at Microsoft conferences. Ami is the CTO and co-founder of DBSophic, a software company that develops innovative solutions for performance optimization of SQL Server application workloads.
19:15 Break
19:30 Workload Tuning
Ami Levin, SQL Server MVP
Product demonstration of DBSophic
20:00 Complex Event Processing (CEP)
Allan Mitchell, SQL Server MVP
http://sqlis.com/sqlis/
StreamInsight is Microsoft’s first foray into the world of Complex Event Processing (CEP) and Event Stream Processing (ESP). In this session I want to show an introduction to this technology. I will show how and why it is useful. I will get us used to some new terminology but best of all I will show just how easy it is to start building your first CEP/ESP application.