Allan Mitchell
and myself are doing a double act, Allan is becoming one of the leading guys in the UK on StreamInsight
and will give an introduction to this new exciting technology; on top of that I'll being talking about SQL Server Disk IO - well, "Disk" might not be relevant anymore because I'll be talking about SSD
and IOFusion - basically I'll be talking about the underpinnings - making sure you understand
and get it right, how to monitor etc... If you've any specific problems or questions just ping me an email
[email protected].
To register for the event see: http://sqlserverfaq.com/events/217/SQL-Server-and-Disk-IO-File-GroupsFiles-SSDs-FusionIO-InRAM-DBs-Fragmentation-Tony-Rogerson-Complex-Event-Processing-Allan-Mitchell.aspx
18:15 SQL Server
and Disk IOTony Rogerson, SQL Server MVPTony's Blog; Tony on TwitterIn 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.19:15 Break19:45 Complex Event Processing (CEP)Allan Mitchell, SQL Server MVPhttp://sqlis.com/sqlisStreamInsight 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.
