Nov 26th - 6:30 to 7 PM - Registration and Snacks 7 PM to 8 PM - Topic 1 - Presentation by Nagaraj Venkatesan 8 PM to 8:15 - Break 8:15 PM to 9 - Topic 2 - Presentation by Sarbjit Singh
Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-15 (24) AV
Topic 1:Hekaton - In Memory tables - Transaction Logging and Checkpoint processes
Hekaton “In Memory” tables, introduced in SQL Server 2014, has achieved huge performance gains, after making several changes in query processing, transaction processing, and storage of data. One of the major changes has been the way in which "In Memory" transactions are written to transaction log and storage of "In Memory" data on to the disk. The presentation will do a deep dive into the transaction logging, checkpoint processes of "In Memory" tables, compare them against disk based tables and demonstrate the performance gains achieved in "In Memory" tables.
Nagaraj Venkatesan, a SQL Server enthusiast exploring SQL Server for the last 10 years. Working for NCS Pte Ltd as SQL Server DBA, Nagaraj maintains databases used by one of the busiest public facing applications in the city. He frequently blogs at strictlysql.blogspot.com and is a regular contributor sqlservercentral.com. Besides these, he also holds a Masters Degree in Computing from National University of Singapore
Topic 2: SQL Management Pack for SCOM - Session 2
Management pack for SQL Server provides the capabilities for Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
The monitoring provided by this management pack includes performance, availability, and configuration monitoring, along with performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues.
About Speaker: Sarbjit Singh
I bring 24 years of IT experience spanning consulting, architecture and training for Microsoft technologies such as Lync, Exchange, SQL Server, SharePoint, Windows Server, Active Directory, System Center range of products. I am also experienced in carrying out a Microsoft IO (Infrastructure Optimization) and Implementation of the MS MOF (Microsoft Operations Framework).
Since 2005, I have been a Microsoft Most Valuable Professional (MVP) with Technical Expertise in Lync, SCOM and SharePoint.
I have participated as a speaker and proctor in numerous conference and forums and co-authored a book on MS Exchange monitoring using SCOM. As a MVP, I am founder of Singapore Lync User Group and an active member of other MS Technologies User Group communities.
I hold a FIA International "C" racing license and I race actively in Japan and Malaysia in touring cars endurance and club races.I am an active Scuba Diver with interest in underwater videography.